Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\text.23.06.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/text.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="text.23.01.html#110017">18 The Text Driver</a> : Connection Option Descriptions</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="110017">Connection Option Descriptions</a></div> <div class="Body"><a name="161700">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="161701">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="161702">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', 'text.23.06.html#110440', '');" name="110355">Table 18-2</a></span> lists the connection string attributes supported by the Text driver.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 18-2. <a name="110440">Text 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="110444">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="110446">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', 'text.23.06.html#110760', '');" name="121238">AllowUpdateAndDelete (AUD)</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="121241">0 (Disabled)</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', 'text.23.06.html#111479', '');" name="121231">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="121234">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', 'text.23.06.html#111531', '');" name="121225">CacheSize (CSZ)</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="121227">4</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', 'text.23.06.html#110805', '');" name="121218">CenturyBoundary (CB)</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="121220">20</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', 'text.23.06.html#111718', '');" name="121246">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="121248">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', 'text.23.06.html#111586', '');" name="121260">DataFileExtension (DFE)</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="121262">TXT</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', 'text.23.06.html#111655', '');" name="121253">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="121255">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', 'text.23.06.html#110886', '');" name="121267">DecimalSymbol (CS)</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="121269">. (Period)</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', 'text.23.06.html#110915', '');" name="121298">Delimiter (DC)</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="121300">, (Comma)</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', 'text.23.06.html#111750', '');" name="121291">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="121293">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', 'text.23.06.html#110949', '');" name="121284">ExtraExtensions (EE)</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="121286">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', 'text.23.06.html#111817', '');" name="121274">FileOpenCache (FOC)</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="121279">0</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', 'text.23.06.html#110819', '');" name="121305">FirstLineNames (FLN)</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="121307">0 (Disabled)</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', 'text.23.06.html#111898', '');" name="121326">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="121328">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', 'text.23.06.html#113755', '');" name="121319">IntlSort (IS)</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="121321">0 (Disabled)</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', 'text.23.06.html#111047', '');" name="121312">ScanRows (SR)</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="121314">25</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" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.06.html#110900', '');" name="121333">TableType (TT)</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="121335">Comma</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', 'text.23.06.html#111440', '');" name="121340">UndefinedTable (UT)</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="121342">GUESS</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', 'text.23.06.html#113798', '');" name="121347">UseLongQualifiers (ULQ)</a></span> <br />WINDOWS 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="121349">0 (Disabled)</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="110744">Action for Undefined Tables</a></div> <div class="gutter_text_right"><a name="111439">Attribute</a></div> <div class="Body_attr"><a name="111440">UndefinedTable (UT)</a></div> <div class="gutter_text_right"><a name="111441">Description</a></div> <div class="Body"><a name="161742">Determines whether the driver prompts the user when it encounters a table for which it has </a>no structure information.</div> <div class="gutter_text_right"><a name="111446">Valid Values</a></div> <div class="Body"><a name="119465">PROMPT | GUESS</a></div> <div class="Body"><a name="119466">Specify PROMPT to prompt the user.</a></div> <div class="Body"><a name="119467">Specify GUESS for the driver to guess the format of the file.</a></div> <div class="gutter_text_right"><a name="111453">Default</a></div> <div class="Body"><a name="111454">GUESS</a></div> <div class="gutter_text_right"><a name="111455">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106399', '');" name="111460">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110758">Allow Update and Delete</a></div> <div class="gutter_text_right"><a name="110759">Attribute</a></div> <div class="Body_attr"><a name="110760">AllowUpdateAndDelete (AUD)</a></div> <div class="gutter_text_right"><a name="118077">Description</a></div> <div class="Body"><a name="110761">Allows Update and Delete statements. Because Update and Delete statements cause </a>immediate changes to a text file, only one connection at a time can operate on a file. Each update and delete on a text file can cause significant changes to the file, and performance may be degraded. Consider a more appropriate database form if performance is a significant factor.</div> <div class="gutter_text_right"><a name="114792">Valid Values</a></div> <div class="Body"><a name="114795">0 | 1</a></div> <div class="Body"><a name="114796">If set to 1 (Enabled), text files are opened exclusively by the current connection.</a></div> <div class="Body"><a name="114797">If set to 0 (Disabled), Update and Delete statements are not allowed.</a></div> <div class="gutter_text_right"><a name="110762">Default</a></div> <div class="Body"><a name="110763">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="123076">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106399', '');" name="123081">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110772">Application Using Threads</a></div> <div class="gutter_text_right"><a name="111477">Attribute</a></div> <div class="Body_attr"><a name="111479">ApplicationUsingThreads (AUT)</a></div> <div class="gutter_text_right"><a name="111480">Description</a></div> <div class="Body"><a name="161706">Determines whether the driver works with applications using multiple ODBC threads.</a></div> <div class="gutter_text_right"><a name="111489">Valid Values</a></div> <div class="Body"><a name="161746">0 | 1</a></div> <div class="Body"><a name="161747">If set to 1 (Enabled), the driver works with single-threaded and multi-threaded applications.</a></div> <div class="Body"><a name="161748">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="111496">Default</a></div> <div class="Body"><a name="111498">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="123105">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106399', '');" name="123110">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110789">Cache Size</a></div> <div class="gutter_text_right"><a name="111530">Attribute</a></div> <div class="Body_attr"><a name="111531">CacheSize (CSZ)</a></div> <div class="gutter_text_right"><a name="111532">Description</a></div> <div class="Body"><a name="161821">The number of 64 KB blocks the driver uses to cache database records. The larger the </a>number of blocks, the better the performance.</div> <div class="gutter_text_right"><a name="111534">Valid Values</a></div> <div class="Body"><a name="161802">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="161803">where </a><span class="EquationVariables">x</span> is a positive integer that specifies the number of 64 KB blocks for caching.</div> <div class="Body"><a name="161804">If set to 0, no records are cached.</a></div> <div class="Body"><a name="161805">If set to </a><span class="EquationVariables">x</span>, the specified number of 64 KB blocks are set aside for caching. The maximum number of blocks you can set depends on the system memory available. If the cache size is greater than 0, when browsing backwards, you are not able to see updates made by other users until you run the Select statement again.</div> <div class="gutter_text_right"><a name="111539">Default</a></div> <div class="Body"><a name="111540">4</a></div> <div class="gutter_text_right"><a name="123118">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106399', '');" name="123123">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110803">Century Boundary</a></div> <div class="gutter_text_right"><a name="110804">Attribute</a></div> <div class="Body_attr"><a name="110805">CenturyBoundary (CB)</a> </div> <div class="gutter_text_right"><a name="118095">Description</a></div> <div class="Body"><a name="110806">The cutoff year for century inference when converting two-digit dates to four-digit dates.</a></div> <div class="gutter_text_right"><a name="115602">Valid Values</a></div> <div class="Body" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="EquationVariables"><a name="115603">xx</a></span></div> <div class="Body"><a name="115604">where </a><span class="EquationVariables">xx</span> is a two-digit number.</div> <div class="Body"><a name="115699">Two-digit dates that are less than the specified year number are converted to </a><span class="Syntax">20</span><span class="EquationVariables">xx</span>. Two-digit dates greater than or equal to the number are converted to <span class="Syntax">19</span><span class="EquationVariables">xx</span>. For example, using the default value of 20, a date of 19 will be interpreted as 2019 and a date of 21 is interpreted as 1921.</div> <div class="gutter_text_right"><a name="110807">Default</a></div> <div class="Body"><a name="110808">20</a></div> <div class="gutter_text_right"><a name="123131">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106399', '');" name="123136">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110817">Column Names in First Line</a></div> <div class="gutter_text_right"><a name="110818">Attribute</a></div> <div class="Body_attr"><a name="110819">FirstLineNames (FLN)</a></div> <div class="gutter_text_right"><a name="118101">Description</a></div> <div class="Body"><a name="110820">Determines whether the driver looks for column names in the first line of the file.</a></div> <div class="Body"><a name="110821">NOTE: The Column Names in First Line setting applies only to tables not previously </a>defined. It also determines the attributes of new tables created with the Create Table statement.</div> <div class="gutter_text_right"><a name="116625">Valid Values</a></div> <div class="Body"><a name="116628">0 | 1</a></div> <div class="Body"><a name="116629">If set to 1 (</a>Enabled), the driver looks for column names in the first line of the file.</div> <div class="Body"><a name="116630">If set to 0 (Disabled), the driver does not look for column names in the first line of the file.</a></div> <div class="gutter_text_right"><a name="110822">Default</a></div> <div class="Body"><a name="110823">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="116871">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106364', '');" name="116876">General tab</a></span></div> <div class="head_2_no_TOC"><a name="110833">Data File Extension</a></div> <div class="gutter_text_right"><a name="111585">Attribute</a></div> <div class="Body_attr"><a name="111586">DataFileExtension (DFE)</a></div> <div class="gutter_text_right"><a name="111587">Description</a></div> <div class="Body"><a name="161752">A one- to three-character file name extension to use for data files.</a></div> <div class="gutter_text_right"><a name="111592">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="161756">ext</a></span></div> <div class="Body"><a name="161757">where </a><span class="EquationVariables">ext</span> is the name of the one- to three-character file name extension.</div> <div class="Body"><a name="161758">This value is used for all Create Table statements. Sending a Create Table using an </a>extension other than the value specified for this option causes an error.</div> <div class="Body"><a name="161759">In other SQL statements, such as Select or Insert, users can specify an extension other </a>than the one specified for this connection option. The Data File Extension value is used when no extension is specified.</div> <div class="gutter_text_right"><a name="110838">Default</a></div> <div class="Body"><a name="110839">TXT</a></div> <div class="gutter_text_right"><a name="123140">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106399', '');" name="123145">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110849">Data Source Name</a></div> <div class="gutter_text_right"><a name="111653">Attribute</a></div> <div class="Body_attr"><a name="111655">DataSourceName (DSN)</a></div> <div class="gutter_text_right"><a name="111656">Description</a></div> <div class="Body"><a name="161710">The name of a data source in your Windows Registry or odbc.ini file.</a></div> <div class="gutter_text_right"><a name="111661">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="161763">string</a></span> </div> <div class="Body"><a name="161764">where </a><span class="EquationVariables">string</span> is the name of a data source.</div> <div class="gutter_text_right"><a name="111667">Default</a></div> <div class="Body"><a name="111669">None</a></div> <div class="gutter_text_right"><a name="111670">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106364', '');" name="111675">General tab</a></span></div> <div class="head_2_no_TOC"><a name="110869">Database Directory</a></div> <div class="gutter_text_right"><a name="111717">Attribute</a></div> <div class="Body_attr"><a name="111718">Database (DB)</a></div> <div class="gutter_text_right"><a name="118111">Description</a></div> <div class="Body"><a name="161768">The directory that contains the data files.</a></div> <div class="gutter_text_right"><a name="111723">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="161772">database_directory</a></span></div> <div class="Body"><a name="161773">where </a><span class="EquationVariables">database_directory</span> is the full path name of the directory in which the data files are stored. If no directory is specified, the current working directory is used.</div> <div class="gutter_text_right"><a name="111729">Default</a></div> <div class="Body"><a name="111730">None</a></div> <div class="gutter_text_right"><a name="123285">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106364', '');" name="123290">General tab</a></span></div> <div class="head_2_no_TOC"><a name="110884">Decimal Symbol</a></div> <div class="gutter_text_right"><a name="110885">Attribute</a></div> <div class="Body_attr"><a name="110886">DecimalSymbol (CS)</a></div> <div class="gutter_text_right"><a name="118117">Description</a></div> <div class="Body"><a name="110887">The decimal separator used when data is stored.</a></div> <div class="gutter_text_right"><a name="116886">Valid Values</a></div> <div class="Body"><a name="116887">, | .</a></div> <div class="Body"><a name="116888">If set to Comma (,), the driver uses a comma as the decimal separator.</a></div> <div class="Body"><a name="116889">If set to Period (.), the driver uses a period as the decimal separator.</a></div> <div class="Body"><a name="116943">The international decimal symbol (.) must be used in DML statements and parameter </a>buffers.</div> <div class="gutter_text_right"><a name="110888">Default</a></div> <div class="Body"><a name="110889">. (Period)</a></div> <div class="gutter_text_right"><a name="123165">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106399', '');" name="123170">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110898">Default Table Type</a></div> <div class="gutter_text_right"><a name="110899">Attribute</a></div> <div class="Body_attr"><a name="110900">TableType (TT)</a></div> <div class="gutter_text_right"><a name="118149">Description</a></div> <div class="Body"><a name="110901">The type of text file (table) that is used when creating a new table and opening an undefined </a>table. </div> <div class="Body"><a name="116528">NOTE: The Default Table Type setting applies only to tables not previously defined. It also </a>determines the attributes of new tables created with the Create Table statement.</div> <div class="gutter_text_right"><a name="117032">Valid Values</a></div> <div class="Body"><a name="117033">Comma | Tab | Character | Fixed | Stream</a></div> <div class="Body"><a name="117074">The value chosen determines the type of text used for a table: comma-separated, </a>tab-separated, character-separated, fixed length, or stream.</div> <div class="gutter_text_right"><a name="110902">Default</a></div> <div class="Body"><a name="110903">Comma</a></div> <div class="gutter_text_right"><a name="123294">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106364', '');" name="125341">General tab</a></span></div> <div class="head_2_no_TOC"><a name="125343">Delimiter Character</a></div> <div class="gutter_text_right"><a name="125344">Attribute</a></div> <div class="Body_attr"><a name="110915">Delimiter (DC)</a></div> <div class="gutter_text_right"><a name="118155">Description</a></div> <div class="Body"><a name="116571">The character used as a delimiter for character-separated files.</a></div> <div class="Body"><a name="117684">NOTE: The Delimiter Character setting applies only to tables not previously defined. It also </a>determines the attributes of new tables created with the Create Table statement.</div> <div class="gutter_text_right"><a name="117470">Valid Values</a></div> <div class="Body" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="EquationVariables"><a name="117471">x</a></span></div> <div class="Body"><a name="117472">where </a><span class="EquationVariables">x</span> is any printable character except single quotes, double quotes, or semicolons.</div> <div class="Body"><a name="117474">Note that it is possible to specify a semicolon if you configure the data source using the </a>Windows ODBC Administrator.</div> <div class="gutter_text_right"><a name="110917">Default</a></div> <div class="Body"><a name="110918">, (Comma)</a></div> <div class="gutter_text_right"><a name="123303">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106364', '');" name="123308">General tab</a></span></div> <div class="head_2_no_TOC"><a name="111747">Description</a></div> <div class="gutter_text_right"><a name="111748">Attribute</a></div> <div class="Body_attr"><a name="111750">Description (n/a)</a></div> <div class="gutter_text_right"><a name="111751">Description</a></div> <div class="Body"><a name="161714">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="111756">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="161777">string</a></span> </div> <div class="Body"><a name="161778">where </a><span class="EquationVariables">string</span> is a description of a data source.</div> <div class="gutter_text_right"><a name="111762">Default</a></div> <div class="Body"><a name="111763">None</a></div> <div class="gutter_text_right"><a name="123312">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106364', '');" name="123317">General tab</a></span></div> <div class="head_2_no_TOC"><a name="110947">Extension List</a></div> <div class="gutter_text_right"><a name="110948">Attribute</a></div> <div class="Body_attr"><a name="110949">ExtraExtensions (EE)</a></div> <div class="gutter_text_right"><a name="118169">Description</a></div> <div class="Body"><a name="110950">A comma-separated list of file name extensions for the files that you want returned in </a>addition to the extension specified in the Data File Extension field.</div> <div class="Body"><a name="118340">NOTE: You must have also enabled the Files with Matching Extensions option.</a></div> <div class="gutter_text_right"><a name="118205">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="118208">ext</a></span> | <span class="Syntax">NONE</span></div> <div class="Body"><a name="118209">where </a><span class="EquationVariables">ext</span> is a file name extension.</div> <div class="Body"><a name="118392">To have files with no extensions returned, specify NONE. For example, if some of your files </a>have the extensions TXT and CSV and others have no extension, specify <span class="Syntax">TXT,CSV,NONE</span>.</div> <div class="Body"><a name="118528">By default, when an application requests a list of tables, only files that have been defined </a>are returned.</div> <div class="gutter_text_right"><a name="110952">Default</a></div> <div class="Body"><a name="110953">None</a></div> <div class="gutter_text_right"><a name="123174">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106399', '');" name="123179">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110962">File Open Cache</a></div> <div class="gutter_text_right"><a name="111816">Attribute</a></div> <div class="Body_attr"><a name="111817">FileOpenCache (FOC)</a></div> <div class="gutter_text_right"><a name="111818">Description</a></div> <div class="Body"><a name="161782">The maximum number of used file handles to cache.</a></div> <div class="gutter_text_right"><a name="111823">Valid Values</a></div> <div class="Body"><a name="161786">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="161787">where </a><span class="EquationVariables">x</span> is a positive integer.</div> <div class="Body"><a name="161788">If set to 0, no file open caching is performed.</a></div> <div class="Body"><a name="161789">If set to </a><span class="EquationVariables">x</span>, when a user opens and closes <span class="EquationVariables">x</span> tables, the tables are not actually closed. The driver keeps them open so that if another query uses one of these tables, the driver does not have to perform another open, which is expensive. The advantage of file open caching is improved performance. The disadvantage is that a user who tries to open the file exclusively may get a file locking conflict even though no one appears to have the file open.</div> <div class="gutter_text_right"><a name="111831">Default</a></div> <div class="Body"><a name="111832">0 (No File Open Caching)</a></div> <div class="gutter_text_right"><a name="123183">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106399', '');" name="123188">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="110980">IANAAppCodePage</a></div> <div class="gutter_text_right"><a name="111896">Attribute</a></div> <div class="Body_attr"><a name="111898">IANAAppCodePage (IACP)</a></div> <div class="gutter_text_right"><a name="111899">Description</a></div> <div class="Body"><a name="161718">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="161727">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="161728">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="161729">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="161730">In the ODBC section of the system information file (odbc.ini)</a></div> </td> </tr> </table> </div> <div class="gutter_text_right"><a name="111918">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="161793">IANA_code_page</a></span> </div> <div class="Body"><a name="161795">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="111929">Default</a></div> <div class="Body"><a name="111931">4 (ISO 8559-1 Latin-1)</a></div> <div class="gutter_text_right"><a name="123204">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106399', '');" name="123209">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="111003">Include Files with Matching Extensions</a></div> <div class="gutter_text_right"><a name="111004">Attribute</a></div> <div class="Body_attr"><a name="111005">n/a</a></div> <div class="gutter_text_right"><a name="118179">Description</a></div> <div class="Body"><a name="111006">Enables the driver to return files with a given file name extension in addition to the extension </a>specified through the Data File Extension option. After enabling this option, specify the file name extensions through the Extension List option.</div> <div class="gutter_text_right"><a name="118931">Valid Values</a></div> <div class="Body"><a name="118964">0 | 1</a></div> <div class="Body"><a name="118965">If set to 1 (Enabled), the driver returns files with the file name extensions</a> specified through the Extension List and Data File Extension options.</div> <div class="Body"><a name="118966">If set to 0 (Disabled), the driver returns only files with the file name extension specified </a>through the Data File Extension option.</div> <div class="gutter_text_right"><a name="111007">Default</a></div> <div class="Body"><a name="118712">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="123225">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106399', '');" name="123230">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="111014">International Sort</a></div> <div class="gutter_text_right"><a name="113754">Attribute</a></div> <div class="Body_attr"><a name="113755">IntlSort (IS)</a></div> <div class="gutter_text_right"><a name="113756">Description</a></div> <div class="Body"><a name="161683">Uses international sort order as defined by your operating system when you issue a Select </a>statement with an Order By clause.</div> <div class="gutter_text_right"><a name="113761">Valid Values</a></div> <div class="Body"><a name="161809">0 | 1</a></div> <div class="Body"><a name="161810">If set to 1 (Enabled), this order is always alphabetic, regardless of case; the letters are </a>sorted as "A, b, C." Refer to your operating system documentation concerning the sorting of accented characters.</div> <div class="Body"><a name="161811">If set to 0 (Disabled), ASCII sort order is used. This order sorts items alphabetically with </a>uppercase letters preceding lowercase letters. For example, "A, b, C" is sorted as "A, C, b."</div> <div class="gutter_text_right"><a name="113768">Default</a></div> <div class="Body"><a name="113769">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="123242">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106399', '');" name="123247">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="111045">Rows to Scan</a></div> <div class="gutter_text_right"><a name="111046">Attribute</a></div> <div class="Body_attr"><a name="111047">ScanRows (SR)</a></div> <div class="gutter_text_right"><a name="118185">Description</a></div> <div class="Body"><a name="111048">The number of rows in a text file that the driver scans to determine the data types in the file.</a></div> <div class="Body"><a name="116607">NOTE: The Rows to Scan setting applies only to tables not previously defined. It also </a>determines the attributes of new tables created with the Create Table statement.</div> <div class="gutter_text_right"><a name="119195">Valid Values</a></div> <div class="Body"><a name="119198">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="119315">where </a><span class="EquationVariables">x</span> is a positive integer.</div> <div class="Body"><a name="119392">If set to 0, all rows in the file are scanned.</a></div> <div class="Body"><a name="119393">If set to </a><span class="EquationVariables">x</span>, <span class="EquationVariables">x</span> rows are scanned to determine the data types in a file.</div> <div class="gutter_text_right"><a name="119264">Default</a></div> <div class="Body"><a name="119265">25</a></div> <div class="gutter_text_right"><a name="123257">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106399', '');" name="123262">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="111059">Use Long Qualifiers</a></div> <div class="gutter_text_right"><a name="113797">Attribute</a></div> <div class="Body_attr"><a name="113798">UseLongQualifiers (ULQ)</a></div> <div class="gutter_text_right"><a name="113799">Description</a></div> <div class="Body"><a name="161734">Determines whether the driver uses long path names.</a></div> <div class="gutter_text_right"><a name="113804">Valid Values</a></div> <div class="Body"><a name="161815">0 | 1</a></div> <div class="Body"><a name="161816">If set to 1 (Enabled), path names can be a maximum of 255 characters.</a></div> <div class="Body"><a name="161817">If set to 0 (Disabled), path names can be a maximum of 128 characters.</a></div> <div class="gutter_text_right"><a name="113811">Default</a></div> <div class="Body"><a name="113812">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="123270">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.04.html#106399', '');" name="123275">Advanced 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