Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\informixcli.22.04.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Connection Option Descriptions</title> <link rel="StyleSheet" href="css/informixcli.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="informixcli.22.01.html#108745">17 The Informix Driver</a> : Connection Option Descriptions</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="108745">Connection Option Descriptions</a></div> <div class="Body"><a name="154599">The following connection option descriptions are listed alphabetically by the GUI name that </a>appears on the driver Setup dialog box. The connection string attribute name, along with its short name, is listed immediately underneath the GUI name. </div> <div class="Body"><a name="154600">In most cases, the GUI name and the attribute name are the same; however, some </a>exceptions exist. If you need to look up an option by its connection string attribute name, please refer to the alphabetical table of connection string attribute names.</div> <div class="Body"><a name="154601">Also, a few connection string attributes, for example, Password, do not have equivalent </a>options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.</div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.04.html#108804', '');" name="111162">Table 17-1</a></span> lists the connection string attributes supported by the Informix driver.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 17-1. <a name="108804">Informix Attribute Names</a> </div> </caption> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="108808">Attribute (Short Name)</a></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="108810">Default</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.04.html#110512', '');" name="133475">ApplicationUsingThreads (AUT)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="133477">1 (Enabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.04.html#110539', '');" name="133468">CancelDetectInterval (CDI)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="133470">0 (None)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.04.html#110608', '');" name="133482">Database (DB)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="133484">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.04.html#110589', '');" name="133489">Database (DL)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="133491">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.04.html#110632', '');" name="133496">DataSourceName (DSN)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="133498">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.04.html#115640', '');" name="133517">Description (n/a)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="133519">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.04.html#110694', '');" name="133510">HostName (HOST)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="133512">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.04.html#110723', '');" name="133503">IANAAppCodePage (IACP)</a></span> <br />UNIX ONLY</div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="133505">4 (ISO 8559-1 Latin 1)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.04.html#114311', '');" name="133524">LogonID (UID)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="133526">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.04.html#110798', '');" name="133552">Password (PWD)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="133554">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.04.html#110843', '');" name="133545">ServerName (SRVR)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="133547">None</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.04.html#110881', '');" name="133538">TrimBlankFromIndexName (TBFIN)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="133540">1 (Enabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.04.html#110902', '');" name="133531">UseDefaultLogin (UDL)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="133533">0 (Disabled)</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="110509">Application Using Threads</a></div> <div class="gutter_text_right"><a name="110510">Attribute</a></div> <div class="Body_attr"><a name="110512">ApplicationUsingThreads (AUT)</a></div> <div class="gutter_text_right"><a name="111667">Description</a></div> <div class="Body"><a name="154488">Determines whether the driver works with applications using multiple ODBC threads.</a></div> <div class="Body"><a name="111672">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.05.html#106746', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="111676">Valid Values</a></div> <div class="Body"><a name="154589">0 | 1</a></div> <div class="Body"><a name="154590">If set to 1 (Enabled), the driver works with single-threaded and multi-threaded applications.</a></div> <div class="Body"><a name="154591">If set to 0 (Disabled), the driver does not work with multi-threaded applications. If using the </a>driver with single-threaded applications, this value avoids additional processing required for ODBC thread-safety standards.</div> <div class="gutter_text_right"><a name="111683">Default</a></div> <div class="Body"><a name="111685">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="110529">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#106384', '');" name="110534">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110536">Cancel Detect Interval</a></div> <div class="gutter_text_right"><a name="110537">Attribute</a></div> <div class="Body_attr"><a name="110539">CancelDetectInterval (CDI)</a></div> <div class="gutter_text_right"><a name="110540">Description</a></div> <div class="Body"><a name="154605">Determines whether long-running queries in threaded applications can be cancelled if the </a>application issues a SQLCancel.</div> <div class="Body"><a name="113786">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.05.html#106746', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="113790">Valid Values</a></div> <div class="Body"><a name="154609">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="154610">where </a><span class="EquationVariables">x</span> is the number of seconds the driver waits before checking for SQLCancel calls.</div> <div class="Body"><a name="154611">If set to 0 (None), the driver does not allow long-running queries in threaded applications to </a>be canceled, even if the application issues a SQLCancel.</div> <div class="Body"><a name="154612">If set to </a><span class="EquationVariables">x</span> (seconds), for every pending query, the driver checks for SQLCancel calls at the specified interval. If the driver determines that a SQLCancel has been issued, the driver cancels the query.</div> <div class="gutter_text_right"><a name="154613">Example</a></div> <div class="Body"><a name="154614">If you specify 5, for every pending query, the driver checks every five seconds to see </a>whether the application has issued a SQLCancel call. If it detects a SQLCancel call, the driver cancels the query.</div> <div class="gutter_text_right"><a name="110553">Default</a></div> <div class="Body"><a name="110555">0 (None)</a></div> <div class="gutter_text_right"><a name="118426">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#106384', '');" name="118431">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110563">Cursor Behavior</a></div> <div class="gutter_text_right"><a name="110564">Attribute</a></div> <div class="Body_attr"><a name="110565">CursorBehavior (CB)</a></div> <div class="gutter_text_right"><a name="110566">Description</a></div> <div class="Body"><a name="110567">Determines whether cursors will be preserved or closed at the end of transactions.</a></div> <div class="gutter_text_right"><a name="110568">Valid Values</a></div> <div class="table_text"><a name="110569">0 | 1</a></div> <div class="Body"><a name="110570">If set to 1 (Enabled), cursors are held at their current position when transactions end. This </a>value may slow the performance of your database operations.</div> <div class="Body"><a name="110574">If set to set to 0 (Disabled), cursors are closed at the end of transactions.</a></div> <div class="gutter_text_right"><a name="110575">Default</a></div> <div class="Body"><a name="110576">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="118442">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#106384', '');" name="118447">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110587">Database List</a></div> <div class="gutter_text_right"><a name="110588">Attribute</a></div> <div class="Body_attr"><a name="110589">Database (DL)</a></div> <div class="gutter_text_right"><a name="110590">Description</a></div> <div class="Body"><a name="110591">A list of database names that will be displayed in the Logon dialog box if </a><span class="Action_bold">Get DB List From </span><span class="Action_bold">Informix</span> on the Advanced tab is <span class="Emphasis">not</span> selected.</div> <div class="gutter_text_right"><a name="110592">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="110593">database_name</a></span>[,<span class="EquationVariables">database_name</span>][...]</div> <div class="Body"><a name="110594">where </a><span class="EquationVariables">database_name</span> is a database name you want to appear in the Logon dialog box. Separate multiple values with commas.</div> <div class="gutter_text_right"><a name="110595">Example</a></div> <div class="Body"><span class="Syntax"><a name="110596">db1</a></span>, <span class="Syntax">db2</span>, <span class="Syntax">db3</span></div> <div class="gutter_text_right"><a name="110597">Default</a></div> <div class="Body"><a name="110598">None</a></div> <div class="gutter_text_right"><a name="110599">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#108092', '');" name="110604">Connection tab</a></span></div> <div class="head_2_no_TOC"><a name="110605">Database Name</a></div> <div class="gutter_text_right"><a name="110606">Attribute</a></div> <div class="Body_attr"><a name="110608">Database (DB)</a></div> <div class="gutter_text_right"><a name="110609">Description</a></div> <div class="Body"><a name="154492">The name of the database to which you want to connect.</a></div> <div class="gutter_text_right"><a name="110614">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="154496">database_name</a></span> </div> <div class="Body"><a name="154497">where </a><span class="EquationVariables">database_name</span> is the name of a valid database.</div> <div class="gutter_text_right"><a name="110620">Default</a></div> <div class="Body"><a name="110621">None</a></div> <div class="gutter_text_right"><a name="110622">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#106337', '');" name="110627">General tab</a></span></div> <div class="head_2_no_TOC"><a name="110629">Data Source Name</a></div> <div class="gutter_text_right"><a name="110630">Attribute</a></div> <div class="Body_attr"><a name="110632">DataSourceName (DSN)</a></div> <div class="gutter_text_right"><a name="110633">Description</a></div> <div class="Body"><a name="154531">The name of a data source in your Windows Registry or odbc.ini file.</a></div> <div class="gutter_text_right"><a name="110638">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="154535">string</a></span> </div> <div class="Body"><a name="154536">where </a><span class="EquationVariables">string</span> is the name of a data source.</div> <div class="gutter_text_right"><a name="110644">Default</a></div> <div class="Body"><a name="110646">None</a></div> <div class="gutter_text_right"><a name="110647">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#106337', '');" name="110652">General tab</a></span></div> <div class="head_2_no_TOC"><a name="114308">Default User Name</a></div> <div class="gutter_text_right"><a name="114309">Attribute</a></div> <div class="Body_attr"><a name="114311">LogonID (UID)</a></div> <div class="gutter_text_right"><a name="114313">Description</a></div> <div class="Body"><a name="154571">The default user ID that is used to connect to your database. Your ODBC application may </a>override this value or you may override it in the logon dialog box or connection string.</div> <div class="gutter_text_right"><a name="114318">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="154575">userid</a></span></div> <div class="Body"><a name="154576">where </a><span class="EquationVariables">userid</span> is a valid user ID with permissions to access the database.</div> <div class="gutter_text_right"><a name="114324">Default</a></div> <div class="Body"><a name="114325">None</a></div> <div class="gutter_text_right"><a name="118513">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#108092', '');" name="118518">Connection tab</a></span></div> <div class="head_2_no_TOC"><a name="115637">Description</a></div> <div class="gutter_text_right"><a name="115638">Attribute</a></div> <div class="Body_attr"><a name="115640">Description (n/a)</a></div> <div class="gutter_text_right"><a name="115641">Description</a></div> <div class="Body"><a name="154636">An optional long description of a data source. This description is not used as a runtime </a>connection attribute, but does appear in the ODBC.INI section of the Registry and in the odbc.ini file.</div> <div class="gutter_text_right"><a name="115646">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="154640">string</a></span> </div> <div class="Body"><a name="154641">where </a><span class="EquationVariables">string</span> is a description of a data source.</div> <div class="gutter_text_right"><a name="115652">Default</a></div> <div class="Body"><a name="115653">None</a></div> <div class="gutter_text_right"><a name="118571">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#106337', '');" name="118576">General tab</a></span></div> <div class="head_2_no_TOC"><a name="110654">Enable Insert Cursors</a></div> <div class="gutter_text_right"><a name="110655">Attribute</a></div> <div class="Body_attr"><a name="110656">EnableInsertCursors (EIC)</a></div> <div class="gutter_text_right"><a name="110657">Description</a></div> <div class="Body"><a name="110658">Determines whether the driver can use Insert cursors during inserts governed by </a>parameters. </div> <div class="gutter_text_right"><a name="110659">Valid Values</a></div> <div class="Body"><a name="110660">If set to 1 (Enabled), the driver uses Insert cursors.</a></div> <div class="Body"><a name="110664">If set to 0 (Disabled), the driver does not use Insert cursors.</a></div> <div class="gutter_text_right"><a name="110665">Default</a></div> <div class="Body"><a name="110666">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="118458">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#106384', '');" name="118463">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110674">Get DB List From Informix (GDBLFI)</a></div> <div class="gutter_text_right"><a name="110675">Attribute</a></div> <div class="Body_attr"><a name="110676">GetDBListFromInformix (GDBLFI)</a></div> <div class="gutter_text_right"><a name="110677">Description</a></div> <div class="Body"><a name="110678">Determines whether the driver requests the database list to be returned from the Informix </a>server or from the database list that the user entered at driver setup. </div> <div class="gutter_text_right"><a name="110679">Valid Values</a></div> <div class="Body"><a name="110680">0 | 1</a></div> <div class="Body"><a name="110681">If set to 1 (Enabled), the driver requests the database list from the Informix server. </a></div> <div class="Body"><a name="110682">If set to 0 (Disabled), the driver uses the list that was entered by the user at driver setup.</a></div> <div class="gutter_text_right"><a name="110683">Default</a></div> <div class="Body"><a name="110684">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="118470">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#106384', '');" name="118475">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110691">Host Name</a></div> <div class="gutter_text_right"><a name="110692">Attribute</a></div> <div class="Body_attr"><a name="110694">HostName (HOST)</a></div> <div class="gutter_text_right"><a name="110696">Description</a></div> <div class="Body"><a name="113837">The name of the server to which you want to connect.</a></div> <div class="gutter_text_right"><a name="110698">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="122240">server_name</a></span></div> <div class="Body"><a name="122241">where </a><span class="EquationVariables">server_name</span> is the name of the server to which you want to connect.</div> <div class="gutter_text_right"><a name="113823">Default</a></div> <div class="Body"><a name="110708">None</a></div> <div class="gutter_text_right"><a name="118583">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#106337', '');" name="118588">General tab</a></span></div> <div class="head_2_no_TOC"><a name="110720">IANAAppCodePage</a></div> <div class="gutter_text_right"><a name="110721">Attribute</a></div> <div class="Body_attr"><a name="110723">IANAAppCodePage (IACP)</a></div> <div class="gutter_text_right"><a name="110724">Description</a></div> <div class="Body"><a name="154546">An Internet Assigned Numbers Authority (IANA) value. You must specify a value for this </a>option if your application is not Unicodeâ??enabled and/or if your database character set is not Unicode (refer to <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'unicode.06.1.html#106144', '');">Chapter 4 â??Internationalization, Localization, and Unicodeâ??</a></span> in the <span class="Emphasis">DataDirect Connect Series </span><span class="forbody">for</span> <span class="Emphasis" style="font-size: 8.0pt;">ODBC</span><span class="Emphasis" style="font-size: 10.0pt;"> Reference</span> for details). The value you specify must match the database character encoding and the system locale.</div> <div class="Body"><a name="154555">The Driver Manager checks for the value of IANAAppCodePage in the following order:</a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="154556">In the connection string</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="154557">In the Data Source section of the system information file (odbc.ini)</a></div> </td> </tr> </table> </div> <div class="list_bulleted_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_single_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_single_inner"><a name="154558">In the ODBC section of the system information file (odbc.ini)</a></div> </td> </tr> </table> </div> <div class="gutter_text_right"><a name="110750">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="154562">IANA_code_page</a></span> </div> <div class="Body"><a name="154564">where </a><span class="EquationVariables">IANA_code_page</span> is one of the valid values listed in <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'appcodepage.03.1.html#108909', '');">Chapter 1 â??Values for the Attribute IANAAppCodePageâ??</a></span> in the <span class="Emphasis">DataDirect Connect Series </span><span class="forbody">for</span> <span class="Emphasis" style="font-size: 8.0pt;">ODBC</span><span class="Emphasis" style="font-size: 10.0pt;"> Reference</span>. The value must match the database character encoding and the system locale.</div> <div class="gutter_text_right"><a name="110761">Default</a></div> <div class="Body"><a name="110763">4 (ISO 8559-1 Latin-1)</a></div> <div class="gutter_text_right"><a name="118482">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#106384', '');" name="118487">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110795">Password</a></div> <div class="gutter_text_right"><a name="110796">Attribute</a></div> <div class="Body_attr"><a name="110798">Password (PWD)</a></div> <div class="gutter_text_right"><a name="110799">Description</a></div> <div class="Body"><a name="154580">The password that the application uses to connect to your database. The Password option </a>cannot be specified through the driver Setup dialog box and should not be stored in a data source. It is specified through the Logon dialog box or a connection string.</div> <div class="gutter_text_right"><a name="110804">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="154584">pwd</a></span> </div> <div class="Body"><a name="154585">where </a><span class="EquationVariables">pwd</span> is a valid password.</div> <div class="gutter_text_right"><a name="110810">Default</a></div> <div class="Body"><a name="110811">None</a></div> <div class="gutter_text_right"><a name="122855">GUI Tab</a></div> <div class="Body"><a name="122865">n/a</a></div> <div class="head_2_no_TOC"><a name="110816">Protocol Type</a></div> <div class="gutter_text_right"><a name="110817">Attribute</a></div> <div class="Body_attr"><a name="110818">Protocol (PRO)</a></div> <div class="gutter_text_right"><a name="110819">Description</a></div> <div class="Body"><a name="110820">Determines the protocol used by the driver to communicate with the server.</a></div> <div class="gutter_text_right"><a name="110821">Valid Values</a></div> <div class="Body"><a name="110822">olsocspx | olsoctcp | onsocspx | onsoctcp | seipcpip | sesocspx | sesoctcp</a></div> <div class="Body"><a name="110829">Specify the appropriate Informix protocol.</a></div> <div class="gutter_text_right"><a name="115336">Default</a></div> <div class="Body"><a name="115337">None</a></div> <div class="gutter_text_right"><a name="118525">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#108092', '');" name="118530">Connection tab</a></span></div> <div class="head_2_no_TOC"><a name="110840">Server Name</a></div> <div class="gutter_text_right"><a name="110841">Attribute</a></div> <div class="Body_attr"><a name="110843">ServerName (SRVR)</a></div> <div class="gutter_text_right"><a name="110844">Description</a></div> <div class="Body"><a name="154618">The name of the Informix server.</a></div> <div class="gutter_text_right"><a name="110846">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="154622">server_name</a></span></div> <div class="Body"><a name="154623">where </a><span class="EquationVariables">server_name</span> is a name that uniquely identifies the Informix server.</div> <div class="gutter_text_right"><a name="110849">Default</a></div> <div class="Body"><a name="110850">None</a></div> <div class="gutter_text_right"><a name="118534">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#108092', '');" name="118539">Connection tab</a></span></div> <div class="head_2_no_TOC"><a name="110861">Service Name </a></div> <div class="gutter_text_right"><a name="110862">Attribute</a></div> <div class="Body_attr"><a name="110863">Service (SERV)</a></div> <div class="gutter_text_right"><a name="110864">Description</a></div> <div class="Body"><a name="110865">The name of the Informix service. The service name is assigned by the system </a>administrator.</div> <div class="gutter_text_right"><a name="110866">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="110867">service_name</a></span></div> <div class="Body"><a name="110868">where </a><span class="EquationVariables">service_name</span> is the a name that uniquely identifies the Informix service. This name must be specified as it appears in the services file on the server machine. </div> <div class="gutter_text_right"><a name="110869">Default</a></div> <div class="Body"><a name="110870">None</a></div> <div class="gutter_text_right"><a name="118543">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#108092', '');" name="118548">Connection tab</a></span></div> <div class="head_2_no_TOC"><a name="110878">Trim Blank From Index Name</a></div> <div class="gutter_text_right"><a name="110879">Attribute</a></div> <div class="Body_attr"><a name="110881">TrimBlankFromIndexName (TBFIN)</a></div> <div class="gutter_text_right"><a name="110882">Description</a></div> <div class="Body"><a name="154627">Determines whether the driver trims leading spaces from system-generated index names. </a>Some applications cannot process a leading space in index names.</div> <div class="gutter_text_right"><a name="110884">Valid Values</a></div> <div class="Body"><a name="154631">If set to 1 (Enabled), the driver trims leading spaces from system-generated index names.</a></div> <div class="Body"><a name="154632">If set to 0 (Disabled), the driver does not trim leading spaces from system-generated index </a>names.</div> <div class="gutter_text_right"><a name="110887">Default</a></div> <div class="Body"><a name="110889">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="118495">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#106384', '');" name="118500">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110900">Use Default Login</a></div> <div class="gutter_text_right"><a name="110901">Attribute</a></div> <div class="Body_attr"><a name="110902">UseDefaultLogin (UDL)</a></div> <div class="gutter_text_right"><a name="110903">Description</a></div> <div class="Body"><a name="110904">Determines where the driver reads login credentials.</a></div> <div class="gutter_text_right"><a name="110905">Valid Values</a></div> <div class="Body"><a name="110906">0 | 1</a></div> <div class="Body"><a name="110907">If set to 0 (Disabled), login credentials are read from the Windows Registry, the connection </a>string, or the Logon to Informix dialog box.</div> <div class="table_text"><a name="110908">If set to 1 (Enabled), login credentials are read directly from the Informix registry. </a></div> <div class="gutter_text_right"><a name="127835">Default</a></div> <div class="Body"><a name="127836">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="127837">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'informixcli.22.03.html#108092', '');" name="118561">Connection tab</a></span></div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de