ServerAgentAdminMySQLServer Agent Administration MySQL Table: 1. Default Rule Book settings <tgroup><thead /><tbody> <row><entry><emphasis>Rule Book Section & parameters</emphasis></entry><entry><emphasis>Default Rule Book Settings</emphasis></entry><entry><emphasis>Notes</emphasis></entry></row> <row><entry>[Environment MySQL]</entry><entry /><entry /></row> <row><entry>;ODBC_CATALOGS</entry><entry>Y</entry><entry><para>Uncomment after loading odbccat defs</para></entry></row> </tbody></tgroup></table> <para>Agent Section</para><para>OpSysLogin<computeroutput>=</computeroutput> Yes; Users are validated against the operating system.</para><para>The following options can be used in the ConnectOptions field of the rule book (oplrqb.ini) to override client Options settings:</para><itemizedlist mark="bullet" spacing="compact"><listitem> <emphasis> -H</emphasis> <span style="color: red"> UNKNOWN tag: http://www.w3.org/1999/xhtml:hostname Connect to server running on . This defaults to localhost if unspecified </span></listitem> <listitem> <emphasis>-P</emphasis> <span style="color: red"> UNKNOWN tag: http://www.w3.org/1999/xhtml:port Contact server on port , which defaults to (3306) is unspecified. </span></listitem> <listitem> <emphasis>-T</emphasis> Disable all ODBC transaction support. The agent will never issue any extra statements for transaction management (commit, rollback, modification of transaction isolation level)</listitem> </itemizedlist><para>This ODBC database agent has been built and verified using MySQL release 3.23.48.</para><bridgehead class="http://www.w3.org/1999/xhtml:h4">Data type Mapping from ODBC Data types to MySQL Data types</bridgehead> <para>This information can be queried by the SQLTypeInfo catalog call.</para><para>Table: 2. Default Rule Book settings </para><table><title /><tgroup><thead /><tbody> <row><entry><emphasis>SQL type</emphasis> </entry><entry><emphasis> MySQL type</emphasis></entry></row> <row><entry>SQL_CHAR</entry><entry> char</entry></row> <row><entry>SQL_VARCHAR </entry><entry> varchar</entry></row> <row><entry>SQL_LONGVARCHAR</entry><entry> text</entry></row> <row><entry>SQL_DECIMAL </entry><entry> decimal</entry></row> <row><entry>SQL_NUMERIC </entry><entry> decimal</entry></row> <row><entry>SQL_BIT </entry><entry> not supported</entry></row> <row><entry>SQL_TINYINT</entry><entry> tinyint</entry></row> <row><entry>SQL_SMALLINT</entry><entry> smallint</entry></row> <row><entry>SQL_INTEGER </entry><entry> integer</entry></row> <row><entry>SQL_BIGINT </entry><entry> bigint</entry></row> <row><entry>SQL_REAL </entry><entry> real</entry></row> <row><entry>SQL_DOUBLE </entry><entry> double</entry></row> <row><entry>SQL_FLOAT </entry><entry> double</entry></row> <row><entry>SQL_BINARY </entry><entry> tinyblob</entry></row> <row><entry>SQL_VARBINARY </entry><entry> tinyblob</entry></row> <row><entry>SQL_LONGVARBINARY </entry><entry> longblob</entry></row> <row><entry>SQL_DATE </entry><entry>date</entry></row> <row><entry>SQL_TIME </entry><entry>time</entry></row> <row><entry>SQL_TIMESTAMP </entry><entry> timestamp</entry></row> </tbody></tgroup></table> <para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h4">Data type Mapping from MySQL Data types to ODBC Data types</bridgehead> <para>This information can be queried by the SQLColumns catalog call.<para>Table: 3. Default Rule Book settings </para><table><title /><tgroup><thead /><tbody> <row><entry>MySQL type </entry><entry>SQL type Precision</entry></row> <row><entry>bigint </entry><entry>SQL_BIGINT 19</entry></row> <row><entry>blob </entry><entry>SQL_VARBINARY 2^16-1</entry></row> <row><entry>char(n) </entry><entry>SQL_CHAR n</entry></row> <row><entry>date </entry><entry>SQL_CHAR 32</entry></row> <row><entry>datetime </entry><entry>SQL_CHAR 32</entry></row> <row><entry>decimal(p,s) </entry><entry>SQL_DECIMAL p</entry></row> <row><entry>double </entry><entry>SQL_DOUBLE 15</entry></row> <row><entry>enum </entry><entry>SQL_VARCHAR 255</entry></row> <row><entry>float </entry><entry>SQL_REAL 7</entry></row> <row><entry>int </entry><entry>SQL_INTEGER 10</entry></row> <row><entry>longblob </entry><entry> SQL_LONGVARBINARY 2^32-1</entry></row> <row><entry>longtext </entry><entry>SQL_LONGVARCHAR 2^32-1</entry></row> <row><entry>mediumblob </entry><entry>SQL_VARBINARY 2^24-1</entry></row> <row><entry>mediumint </entry><entry>SQL_INTEGER 8</entry></row> <row><entry>mediumtext </entry><entry>SQL_LONGVARCHAR 2^24-1</entry></row> <row><entry>set </entry><entry>SQL_VARCHAR 255</entry></row> <row><entry>smallint </entry><entry>SQL_SMALLINT 5</entry></row> <row><entry>text </entry><entry>SQL_LONGVARCHAR 2^16-1</entry></row> <row><entry>time </entry><entry>SQL_VARCHAR 32</entry></row> <row><entry>timestamp(n) </entry><entry>SQL_VARCHAR n</entry></row> <row><entry>tinyblob </entry><entry>SQL_VARBINARY 255</entry></row> <row><entry>tinyint </entry><entry>SQL_TINYINT 3</entry></row> <row><entry>tinytext </entry><entry>SQL_VARCHAR 255</entry></row> <row><entry>varchar(n) </entry><entry>SQL_VARCHAR n</entry></row> <row><entry>varchar(n) binary </entry><entry>SQL_VARCHAR n</entry></row> <row><entry>year </entry><entry>SQL_VARCHAR 4</entry></row> </tbody></tgroup></table> <para> </para></para></section></docbook>