Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\db2.09.05.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/db2.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="db2.09.01.html#282192">5 The DB2 Wire Protocol Driver</a> : Connection Option Descriptions</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="282192">Connection Option Descriptions</a></div> <div class="Body"><a name="656541">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. For example:</div> <div class="hanging_label_head"><a name="656542">Application Using Threads</a></div> <div class="gutter_text_right"><a name="656543">Attribute</a></div> <div class="Body"><a name="656544">ApplicationUsingThreads (AUT)</a></div> <div class="Body"><a name="656545">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="656546">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', 'db2.09.05.html#534279', '');" name="280687">Table 5-1</a></span> lists the connection string attributes supported by the DB2 Wire Protocol driver.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 5-1. <a name="534279">DB2 Wire Protocol 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="534283">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="534285">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" 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', 'db2.09.05.html#168202', '');" name="534290">AccountingInfo (AI)</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="534292">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" 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', 'db2.09.05.html#168220', '');" name="534297">AddStringToCreateTable (ASCT)</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="534299">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" 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', 'db2.09.05.html#168238', '');" name="534304">AlternateID (AID)</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="534306">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" 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', 'db2.09.05.html#170985', '');" name="534311">AlternateServers (ASRV)</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="534313">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" 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', 'db2.09.05.html#168256', '');" name="534318">ApplicationName (AN)</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="534320">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" 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', 'db2.09.05.html#168274', '');" name="534325">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="534327">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" 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', 'db2.09.05.html#176801', '');" name="534332">AuthenticationMethod (AM)</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="534334">0 (No Encryption)</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', 'db2.09.05.html#178798', '');" name="534339">BulkBinaryThreshold (BBT)</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="534341">32</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', 'db2.09.05.html#179451', '');" name="534346">BulkCharacterThreshold (BCT)</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="534348">-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" 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', 'db2.09.05.html#269667', '');" name="534353">BulkLoadBatchSize (BLBS)</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="534355">1024</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', 'db2.09.05.html#630152', '');" name="627893">BulkLoadFieldDelimiter (BLFD)</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="627895">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" 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', 'db2.09.05.html#631083', '');" name="627885">BulkLoadRecordDelimiter (BLRD)</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="627887">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" 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', 'db2.09.05.html#182817', '');" name="534360">CatalogSchema (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="534362">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" 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', 'db2.09.05.html#187285', '');" name="534367">CharsetFor65535 (CF6)</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="534369">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" 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', 'db2.09.05.html#188216', '');" name="534374">ClientHostName (CHN)</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="534376">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" 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', 'db2.09.05.html#188603', '');" name="534381">ClientUser (CU)</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="534383">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" 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', 'db2.09.05.html#232742', '');" name="534388">Collection (COL)</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="534390">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" 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', 'db2.09.05.html#486970', '');" name="534395">ConcurrentAccessResolution (CAR)</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="534397">0 (Automatic)</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', 'db2.09.05.html#232766', '');" name="534402">ConnectionReset (CR)</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="534404">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" 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', 'db2.09.05.html#189662', '');" name="534409">ConnectionRetryCount (CRC)</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="534411">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" 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', 'db2.09.05.html#189686', '');" name="534416">ConnectionRetryDelay (CRD)</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="534418">3</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', 'db2.09.05.html#191225', '');" name="534423">CurrentFunctionPath (CFP)</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="534425">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" 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', 'db2.09.05.html#191567', '');" name="534430">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="534432">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" 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', 'db2.09.05.html#309785', '');" name="534437">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="534439">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" 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', 'db2.09.05.html#193962', '');" name="534444">DefaultIsolationLevel (DIL)</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="534446">1 (READ_COMMITTED)</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', 'db2.09.05.html#193037', '');" name="534451">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="534453">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" 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', 'db2.09.05.html#196327', '');" name="534458">DynamicSections (DS)</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="534460">1000</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', 'db2.09.05.html#197099', '');" name="534465">EnableBulkLoad (EBL)</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="534467">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" 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', 'db2.09.05.html#198496', '');" name="534472">EncryptionMethod (EM)</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="534474">0 (No Encryption)</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', 'db2.09.05.html#199362', '');" name="534479">FailoverGranularity (FG)</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="534481">0 (Non-Atomic)</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', 'db2.09.05.html#199389', '');" name="534486">FailoverMode (FM)</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="534488">0 (Connection)</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', 'db2.09.05.html#199414', '');" name="534493">FailoverPreconnect (FP)</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="534495">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" 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', 'db2.09.05.html#552433', '');" name="552408">FetchTSWTZasTimestamp</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="552410">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" 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', 'db2.09.05.html#200881', '');" name="534500">GrantAuthid (GA)</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="534502">PUBLIC</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', 'db2.09.05.html#270759', '');" name="534507">GrantExecute (GE)</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="534509">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" 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', 'db2.09.05.html#203751', '');" name="534514">GSSClient (GSSC)</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="534516">native</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', 'db2.09.05.html#411945', '');" name="534521">HostNameInCertificate (HNIC)</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="534523">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', 'db2.09.05.html#206099', '');" name="534528">IANAAppCodePage (IACP)</a></span> 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="534530">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" 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', 'db2.09.05.html#208486', '');" name="534535">IpAddress (IP)</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="534537">localhost</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', 'db2.09.05.html#209843', '');" name="534542">KeyPassword (KP)</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="534544">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" 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', 'db2.09.05.html#209865', '');" name="534549">Keystore (KS)</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="534551">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" 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', 'db2.09.05.html#209887', '');" name="534556">KeystorePassword (KSP)</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="534558">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" 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', 'db2.09.05.html#211561', '');" name="534563">LoadBalanceTimeout (LBT)</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="534565">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" 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', 'db2.09.05.html#298425', '');" name="534570">LoadBalancing (LB)</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="534572">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" 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', 'db2.09.05.html#213839', '');" name="534577">Location (LOC)</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="534579">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" 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', 'db2.09.05.html#214939', '');" name="534584">LoginTimeout (LT)</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="534586">15</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', 'db2.09.05.html#271797', '');" name="534591">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="534593">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" 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', 'db2.09.05.html#299050', '');" name="534612">MaxPoolSize (MXPS)</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="534614">100</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', 'db2.09.05.html#299073', '');" name="534619">MinPoolSize (MNPS)</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="534621">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" 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', 'db2.09.05.html#219082', '');" name="534626">PackageCollection (PC)</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="534628">NULLID</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', 'db2.09.05.html#220093', '');" name="534633">PackageNamePrefix (PNP)</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="534635">DD</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', 'db2.09.05.html#219100', '');" name="534640">PackageOwner (PO)</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="534642">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" 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', 'db2.09.05.html#221854', '');" name="534647">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="534649">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" 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', 'db2.09.05.html#272183', '');" name="534654">Pooling (POOL)</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="534656">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" 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', 'db2.09.05.html#223081', '');" name="534661">ProgramID (PID)</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="534663">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" 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', 'db2.09.05.html#223796', '');" name="534668">QueryTimeout (QT)</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="534670">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" 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', 'db2.09.05.html#225090', '');" name="534675">ReportCodepageConversionErrors (RCCE)</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="534677">0 (Ignore Errors)</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', 'db2.09.05.html#225658', '');" name="534682">TcpPort (PORT)</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="534684">50000</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', 'db2.09.05.html#227963', '');" name="534689">Truststore (TS)</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="534691">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" 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', 'db2.09.05.html#227985', '');" name="534696">TruststorePassword (TSP)</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="534698">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" 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', 'db2.09.05.html#228700', '');" name="534703">UseCurrentSchema (UCS)</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="534705">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" 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', 'db2.09.05.html#229563', '');" name="534710">ValidateServerCertificate (VSC)</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="534712">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" 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', 'db2.09.05.html#230130', '');" name="534717">WithHold (WH)</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="534719">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" 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', 'db2.09.05.html#230638', '');" name="534724">XMLDescribeType (XDT)</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="534726">-10</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="168199">Accounting Info</a></div> <div class="gutter_text_right"><a name="168200">Attribute</a></div> <div class="Body_attr"><a name="168202">AccountingInfo (AI)</a></div> <div class="gutter_text_right"><a name="168529">Description</a></div> <div class="Body"><a name="168553">Accounting information to be stored in the database. This value sets the CURRENT </a>CLIENT_ACCTNG register (DB2 for Linux/UNIX/Windows) or the CLIENT ACCTNG register (DB2 for z/OS) in the database. This value is used by the DB2 Workload Manager.</div> <div class="Body"><a name="314794">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.06.html#107347', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="168549">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="168617">string</a></span> </div> <div class="Body"><a name="168689">where </a><span class="EquationVariables">string</span> is the accounting information. </div> <div class="gutter_text_right"><a name="168203">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="168205">None</a></div> <div class="gutter_text_right"><a name="168640">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#628565', '');" name="168215">Client Monitoring tab</a></span></div> <div class="head_2_no_TOC"><a name="168217">Add to Create Table</a></div> <div class="gutter_text_right"><a name="168218">Attribute</a></div> <div class="Body_attr"><a name="168220">AddStringToCreateTable (ASCT)</a></div> <div class="gutter_text_right"><a name="168772">Description</a></div> <div class="Body"><a name="168847">A string that is automatically added to all Create Table statements. This option is for users </a>who need to add an In Database clause to Create Table statements.</div> <div class="gutter_text_right"><a name="168887">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="168921">string</a></span> </div> <div class="Body"><a name="168924">where </a><span class="EquationVariables">string</span> is valid syntax for the In Database clause of a Create Table statement.</div> <div class="gutter_text_right"><a name="168221">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="168223">None</a></div> <div class="gutter_text_right"><a name="311120">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="311125">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="168235">Alternate ID</a></div> <div class="gutter_text_right"><a name="168236">Attribute</a></div> <div class="Body_attr"><a name="168238">AlternateID (AID)</a></div> <div class="gutter_text_right"><a name="169881">Description</a></div> <div class="Body"><a name="169925">The name of the default schema that is used to qualify unqualified database objects in </a>dynamically prepared SQL statements. If the attempt to change the current schema fails, the connection fails and you receive the message <span class="Syntax">Invalid value for Alternate</span><span class="Syntax"> </span><span class="Syntax">ID</span>. DB2 permissions must be set to SYSADM. (This option is not valid for DB2 V5R1 for iSeries.)</div> <div class="gutter_text_right"><a name="170307">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="170403">string</a></span> </div> <div class="Body"><a name="170427">where </a><span class="EquationVariables">string</span> is a valid DB2 schema name.</div> <div class="gutter_text_right"><a name="168239">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="168241">None</a></div> <div class="gutter_text_right"><a name="311165">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="311170">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="170982">Alternate Servers</a></div> <div class="gutter_text_right"><a name="170983">Attribute</a></div> <div class="Body_attr"><a name="170985">AlternateServers (ASRV)</a></div> <div class="gutter_text_right"><a name="172243">Description</a></div> <div class="Body"><a name="656550">A list of alternate database servers to which the driver tries to connect if the primary </a>database server is unavailable. Specifying a value for this option enables connection failover for the driver. The value you specify must be in the form of a string that defines the physical location of each alternate server. All of the other required connection information for each alternate server is the same as what is defined for the primary server connection.</div> <div class="gutter_text_right"><a name="524686">Valid Values</a></div> <div class="syntax_first"><a name="524687">(IPAddress=</a><span class="EquationVariables">ipvalue</span>:TcpPort=<span class="EquationVariables">portvalue</span>:{Database | Location}=</div> <div class="syntax"><span class="EquationVariables"><a name="524694">databasevalue</a></span>[, . . .])</div> <div class="Body"><a name="172870">You must specify the</a> IP address, port number, and database name (Linux/UNIX/Windows) or location (z/OS and iSeries) of each alternate server.</div> <div class="Body"><a name="656554">NOTE: An alternate server address in IPv6 format must be enclosed in double quotation </a>marks.</div> <div class="gutter_text_right"><a name="172891">Example</a></div> <div class="Body"><a name="172662">The following Alternate Servers values define two alternate database servers for connection </a>failover:</div> <div class="syntax_first"><a name="172663">AlternateServers=(IpAddress=123.456.78.90:</a><br />TcpPort=5177:Database=DB2DAT, IpAddress=223.456.78.90:TcpPort=5178:</div> <div class="syntax"><a name="524699">Database=DB2DAT3)</a></div> <div class="Body"><a name="172664">or</a></div> <div class="syntax_first"><a name="172327">AlternateServers=(IpAddress=123.456.78.90:</a><br />TcpPort=5177:Location=DB2DAT, IpAddress=223.456.78.90:TcpPort=5178:</div> <div class="syntax"><a name="524704">Location=DB2DAT3)</a></div> <div class="gutter_text_right"><a name="170986">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="170988">None</a></div> <div class="gutter_text_right"><a name="173087">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111162', '');" name="171007">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="168253">Application Name</a></div> <div class="gutter_text_right"><a name="168254">Attribute</a></div> <div class="Body_attr"><a name="168256">ApplicationName (AN)</a></div> <div class="gutter_text_right"><a name="173820">Description</a></div> <div class="Body"><a name="495336">The name of the application to be stored in the database. This value sets the CURRENT </a>CLIENT_APPLNAME register (DB2 for Linux/UNIX/Windows) or CLIENT APPLNAME register (DB2 for z/OS) in the database. For DB2 V9.1 and higher for Linux/UNIX/Windows, this value also sets the APPL_NAME value of the SYSIBMADM.APPLICATIONS table. This value is used by the DB2 Workload Manager.</div> <div class="Body"><a name="314666">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.06.html#107347', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="174761">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="174765">string</a></span> </div> <div class="Body"><a name="174768">where </a><span class="EquationVariables">string</span> is the name of the application.</div> <div class="gutter_text_right"><a name="168257">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="168259">None</a></div> <div class="gutter_text_right"><a name="311210">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#628565', '');" name="493559">Client Monitoring tab</a></span></div> <div class="head_2_no_TOC"><a name="168271">Application Using Threads</a></div> <div class="gutter_text_right"><a name="168272">Attribute</a></div> <div class="Body_attr"><a name="168274">ApplicationUsingThreads (AUT)</a></div> <div class="gutter_text_right"><a name="174991">Description</a></div> <div class="Body"><a name="656558">Determines whether the driver works with applications using multiple ODBC threads.</a></div> <div class="Body"><a name="308988">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.06.html#107347', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="308989">Valid Values</a></div> <div class="Body"><a name="656562">0 | 1</a></div> <div class="Body"><a name="656563">If set to 1 (Enabled), the driver works with single-threaded and multi-threaded applications.</a></div> <div class="Body"><a name="656564">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="168275">Default</a></div> <div class="Body"><a name="311260">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="311296">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="311301">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="311268">Authentication Method</a></div> <div class="gutter_text_right"><a name="176799">Attribute</a></div> <div class="Body_attr"><a name="176801">AuthenticationMethod (AM)</a></div> <div class="gutter_text_right"><a name="176807">Description</a></div> <div class="Body"><a name="656568">Specifies the method the driver uses to authenticate the user to the server when a </a>connection is established. If the specified authentication method is not supported by the database server, the connection fails and the driver generates an error.</div> <div class="gutter_text_right"><a name="177924">Valid Values</a></div> <div class="Body"><a name="177636">0 | 1 | 2 | 3 | 4 | 7 | 8</a></div> <div class="Body"><a name="656572">If set to 0 (No Encryption), the driver sends the user ID and password in clear text to the </a>server for authentication.</div> <div class="Body"><a name="656576">If set to 1 (Encrypt Password), the driver sends the user ID in clear text and an encrypted </a>password to the server for authentication.</div> <div class="Body"><a name="656580">If set to 2 (Encrypt UID and Password), the driver sends an encrypted user ID and </a>password to the server for authentication.</div> <div class="Body"><a name="656584">If set to 3 (Client Authentication), the driver uses client authentication when establishing a </a>connection. The database server relies on the client to authenticate the user and does not provide additional authentication.</div> <div class="Body"><a name="656588">If set to 4 (Kerberos Authentication), the driver uses Kerberos authentication. This method </a>supports both Windows Active Directory Kerberos and MIT Kerberos environments.</div> <div class="Body"><a name="485848">If set to 7 (Encrypted Password AES), the driver encrypts the password with 256-bit AES </a>encryption in the connection request. (DB2 V9.7 and higher only.)</div> <div class="Body"><a name="484174">If set to 8 (Encrypted UID and Password AES), the driver encrypts the user id and password </a>with 256-bit AES encryption in the connection request. (DB2 V9.7 and higher only.)</div> <div class="Body"><a name="486804">NOTE: The use of AES encryption (values 7 and 8) requires that the DataDirect OpenSSL </a>library be installed.</div> <div class="gutter_text_right"><a name="484176">Default</a></div> <div class="Body"><a name="177771">0 (No Encryption)</a></div> <div class="gutter_text_right"><a name="288707">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#110650', '');" name="288709">Security tab</a></span></div> <div class="head_2_no_TOC"><a name="288711">Batch Size</a></div> <div class="gutter_text_right"><a name="269665">Attribute</a></div> <div class="Body_attr"><a name="269667">BulkLoadBatchSize (BLBS)</a></div> <div class="gutter_text_right"><a name="269668">Description</a></div> <div class="Body"><a name="656592">The number of rows that the driver sends to the database at a time during bulk operations. </a>This value applies to all methods of bulk loading.</div> <div class="gutter_text_right"><a name="288816">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="656596">x</a></span></div> <div class="Body"><a name="656597">where </a><span class="EquationVariables">x</span> is a positive integer that specifies the number of rows to be sent.</div> <div class="gutter_text_right"><a name="288821">Default</a></div> <div class="Body"><a name="269680">1024</a></div> <div class="gutter_text_right"><a name="269681">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111580', '');" name="269686">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="178795">Bulk Binary Threshold</a></div> <div class="gutter_text_right"><a name="178796">Attribute</a></div> <div class="Body_attr"><a name="178798">BulkBinaryThreshold (BBT)</a></div> <div class="gutter_text_right"><a name="178872">Description</a></div> <div class="Body"><a name="656603">The maximum size, in KB, of binary data that is exported to the bulk data file. </a></div> <div class="gutter_text_right"><a name="179189">Valid Values</a></div> <div class="Body"><a name="656607">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="656608">where </a><span class="EquationVariables">x</span> is an integer that specifies the number of KB.</div> <div class="Body"><a name="656609">If set to -1, all binary data, regardless of size, is written to the bulk data file, not to an </a>external file.</div> <div class="Body"><a name="656610">If set to 0, all binary data, regardless of size, is written to an external file, not the bulk data </a>file. A reference to the external file is written to the bulk data file.</div> <div class="Body"><a name="656611">If set to </a><span class="EquationVariables">x</span>, any binary data exceeding this specified number of KB is written to an external file, not the bulk data file. A reference to the external file is written to the bulk data file.</div> <div class="gutter_text_right"><a name="178799">Default</a></div> <div class="Body"><a name="178801">32</a></div> <div class="gutter_text_right"><a name="179231">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111580', '');" name="178815">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="179448">Bulk Character Threshold</a></div> <div class="gutter_text_right"><a name="179449">Attribute</a></div> <div class="Body_attr"><a name="179451">BulkCharacterThreshold (BCT)</a></div> <div class="gutter_text_right"><a name="179700">Description</a></div> <div class="Body"><a name="656615">The maximum size, in KB, of character data that is exported to the bulk data file. </a></div> <div class="gutter_text_right"><a name="180440">Valid Values</a></div> <div class="Body"><a name="656619">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="656620">where </a><span class="EquationVariables">x</span> is an integer that specifies the number of KB.</div> <div class="Body"><a name="656621">If set to -1, all character data, regardless of size, is written to the bulk data file, not to an </a>external file.</div> <div class="Body"><a name="656622">If set to 0, all character data regardless of size, is written to an external file, not the bulk data </a>file. A reference to the external file is written to the bulk data file.</div> <div class="Body"><a name="656623">If set to </a><span class="EquationVariables">x</span>, any character data exceeding this specified number of KB is written to an external file, not the bulk data file. A reference to the external file is written to the bulk data file.</div> <div class="gutter_text_right"><a name="179452">Default</a></div> <div class="Body"><a name="179454">-1</a></div> <div class="gutter_text_right"><a name="180523">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111580', '');" name="179468">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="182814">Catalog Schema</a></div> <div class="gutter_text_right"><a name="182815">Attribute</a></div> <div class="Body_attr"><a name="182817">CatalogSchema (CS)</a></div> <div class="gutter_text_right"><a name="182876">Description</a></div> <div class="Body"><a name="619067">The DB2 schema to use for Catalog functions. Specifying a schema allows you to use </a>copies or views of the system catalog tables for catalog functions. </div> <div class="gutter_text_right"><a name="183948">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="185123">schema_name</a></span> </div> <div class="Body"><a name="185146">where </a><span class="EquationVariables">schema_name</span> is the name of a valid DB2 schema. If you do not specify a value for this attribute, the driver uses SYSIBM when connected to z/OS, QSYS2 when connected to iSeries, and SYSCAT when connected to Linux/UNIX/Windows.</div> <div class="gutter_text_right"><a name="619520">Example</a></div> <div class="Body"><a name="619521">Create a view DB2ADMIN.TABLES from SYSCAT.TABLES.</a></div> <div class="syntax_first"><a name="619522">CREATE VIEW DB2ADMIN.TABLES AS SELECT * FROM SYSCAT.TABLES WHERE OWNER LIKE </a>'ODBC%'</div> <div class="Body"><a name="619523">Set CatalogSchema=DB2ADMIN, and do the SQLTables thing. </a></div> <div class="syntax_first"><a name="619554">"TABLE_CAT", "TABLE_SCHEM", "TABLE_NAME", "TABLE_TYPE", "REMARKS"</a></div> <div class="Body"><a name="619982">The results come from the DB2ADMIN.TABLES view. Three rows are fetched from five </a>columns.</div> <div class="syntax"><a name="619555"><Null>, "DB2ADMIN", "BUG", "TABLE", <Null></a></div> <div class="syntax"><a name="619556"><Null>, "DB2ADMIN", "DATETEST", "TABLE", <Null></a></div> <div class="syntax"><a name="619557"><Null>, "DB2ADMIN", "TESTCP", "TABLE", <Null></a></div> <div class="gutter_text_right"><a name="182818">Default</a></div> <div class="Body"><a name="185076">None</a></div> <div class="gutter_text_right"><a name="311333">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="311338">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="185825">Character Set for CCSID 65535</a></div> <div class="gutter_text_right"><a name="185826">Attribute</a></div> <div class="Body_attr"><a name="187285">CharsetFor65535 (CF6)</a></div> <div class="gutter_text_right"><a name="187286">Description </a></div> <div class="Body"><a name="187287">The IANA code page to be used by the driver to convert character data stored as bit data in </a>character columns (Char, Varchar, Longvarchar, Clob, Char for Bit Data, Varchar for Bit Data, Longvarchar for Bit Data) defined with CCSID 65535.</div> <div class="gutter_text_right"><a name="187392">Valid Values</a></div> <div class="Body"><a name="187393">0 | </a><span class="EquationVariables">IANA_code_page</span></div> <div class="Body"><a name="187426">where </a><span class="EquationVariables">IANA_code_page</span> is a valid IANA code page. Refer to <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'appcodepage.03.3.html#106707', '');">â??IBM to IANA Code Page Valuesâ??</a></span> in <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'appcodepage.03.1.html#108909', '');">Chapter 1</a></span> of 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 a list of the most commonly used IBM code pages and their IANA code page equivalents.</div> <div class="Body"><a name="251644">If unspecified or set to 0, the driver returns these columns as binary columns </a>(SQL_BINARY, SQL_VARBINARY, SQL_LONGVARBINARY) and does no conversion of the data.</div> <div class="Body"><a name="251645">If an IANA code page is specified, the driver returns these columns as character columns in </a>the character set specified. The driver does no conversion of data supplied in bound parameters. </div> <div class="gutter_text_right"><a name="185829">Default</a></div> <div class="Body"><a name="185831">0</a></div> <div class="gutter_text_right"><a name="311350">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="311355">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="188213">Client Host Name</a></div> <div class="gutter_text_right"><a name="188214">Attribute</a></div> <div class="Body_attr"><a name="188216">ClientHostName (CHN)</a></div> <div class="gutter_text_right"><a name="188365">Description</a></div> <div class="Body"><a name="188375">The host name of the client machine to be stored in the database. This value sets the </a>CURRENT CLIENT_WRKSTNNAME register (DB2 for Linux/UNIX/Windows) or CLIENT WRKSTNNAME register (DB2 for z/OS) in the database. This value is used by the DB2 Workload Manager.</div> <div class="Body"><a name="314677">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.06.html#107347', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="415998">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="495782">string</a></span> </div> <div class="Body"><a name="495783">where </a><span class="EquationVariables">string</span> is the host name of the client machine.</div> <div class="gutter_text_right"><a name="495784">Default</a></div> <div class="Body"><a name="495785">None</a></div> <div class="gutter_text_right"><a name="311367">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#628565', '');" name="493597">Client Monitoring tab</a></span></div> <div class="head_2_no_TOC"><a name="188600">Client User</a></div> <div class="gutter_text_right"><a name="188601">Attribute</a></div> <div class="Body_attr"><a name="188603">ClientUser (CU)</a></div> <div class="gutter_text_right"><a name="188759">Description</a></div> <div class="Body"><a name="188994">The user ID to be stored in the database. This option sets the CURRENT CLIENT_USERID </a>register (DB2 for Linux/UNIX/Windows) and CLIENT USERID register (DB2 for z/OS) in the database. This value is used by the DB2 Workload Manager.</div> <div class="Body"><a name="314688">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.06.html#107347', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="189116">Valid Values</a></div> <div class="Body"><a name="189168">-1</a> | <span class="EquationVariables">client_userid</span> </div> <div class="Body"><a name="189189">where </a><span class="EquationVariables">client_userid</span> is a valid user ID.</div> <div class="Body"><a name="416053">The value -1 means that the driver uses the userid of the user that is currently logged onto </a>the client.</div> <div class="gutter_text_right"><a name="188604">Default</a></div> <div class="Body"><a name="188606">None</a></div> <div class="gutter_text_right"><a name="311380">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#628565', '');" name="493573">Client Monitoring tab</a></span></div> <div class="head_2_no_TOC"><a name="232740">Collection</a></div> <div class="gutter_text_right"><a name="232741">Attribute</a></div> <div class="Body_attr"><a name="232742">Collection (COL)</a></div> <div class="gutter_text_right"><a name="525003">Description</a></div> <div class="Body"><a name="525004">The current collection or library. Valid only on DB2 for z/OS and iSeries.</a></div> <div class="Body"><a name="525005">For DB2 for z/OS, this value is the user ID. If an attempt to change the current schema fails, </a>the connection fails and you receive the message <span class="Syntax">Invalid value for Alternate ID</span>.</div> <div class="Body"><a name="236712">For DB2 for iSeries, this value is the name of the schema to be used as the default qualifier </a>for unqualified object names. If you want to access a table outside of this schema, you must specify the schema name and the table name. For example: </div> <div class="syntax_first"><span class="Syntax"><a name="236713">SELECT * FROM </a></span><span class="EquationVariables">Schema.Tablename</span></div> <div class="Body"><a name="234288">Also, if the Alternate ID option is set, it overrides this option.</a></div> <div class="Body"><a name="234289">NOTE: This option is mutually exclusive with the Database Name option.</a></div> <div class="gutter_text_right"><a name="234280">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="234706">user_ID</a></span> (DB2 for z/OS) | <span class="EquationVariables">schema_name</span> (DB2 for iSeries)</div> <div class="Body"><a name="234767">where </a></div> <div class="Body"><span class="EquationVariables"><a name="234780">user_ID</a></span> is a valid user ID. DB2 permissions on the user ID must be set to SYSADM.</div> <div class="Body"><span class="EquationVariables"><a name="234771">schema_name</a></span> is the default schema to use for unqualified object names.</div> <div class="gutter_text_right"><a name="232743">Default</a></div> <div class="Body"><a name="232745">None</a></div> <div class="gutter_text_right"><a name="234831">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109554', '');" name="232760">General tab</a></span></div> <div class="head_2_no_TOC"><a name="486967">Concurrent Access Resolution</a></div> <div class="gutter_text_right"><a name="486968">Attribute</a></div> <div class="Body_attr"><a name="486970">ConcurrentAccessResolution (CAR)</a></div> <div class="gutter_text_right"><a name="486971">Description</a></div> <div class="Body"><a name="486978">Specifies whether a read-only query can access the currently committed value of rows that </a>are locked by a transaction that is updating the rows. The driver must be connected to DB2 V9.7 for LUW or higher and the application isolation level must be either read committed or repeatable read.</div> <div class="gutter_text_right"><a name="486980">Valid Values</a></div> <div class="Body"><a name="486983">0 | 1 | 2</a></div> <div class="Body"><a name="487104">If set to 0 (Automatic), the driver persists the server behavior, as specified by the </a>cur_commit server parameter. If cur_commit is set to "Available" or "Disable," then the current behavior, pending until the row lock is released, is used. When cur_commit is set to "On," the driver returns the last committed value of the row, regardless of whether the row is locked.</div> <div class="Body"><a name="486984">If set to 1 (Wait For Outcome), the driver always waits for the transaction to be completed </a>before returning a row of data that has been locked by another transaction, regardless of how the cur_commit parameter is configured on the server. </div> <div class="Body"><a name="487121">If set to 2 (Use Currently Committed), the driver returns the value that was committed during </a>the last transaction if the cur_commit parameter is configured to "On" or "Available," even though the row is locked.</div> <div class="Body"><a name="487137">NOTE: This option is ignored when connecting to a DB2 server version earlier than </a>DB2 V9.7 for LUW.</div> <div class="gutter_text_right"><a name="486987">Default</a></div> <div class="Body"><a name="486989">0 (Automatic)</a></div> <div class="gutter_text_right"><a name="486990">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="487024">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="272180">Connection Pooling</a></div> <div class="gutter_text_right"><a name="272181">Attribute</a></div> <div class="Body_attr"><a name="272183">Pooling (POOL)</a></div> <div class="gutter_text_right"><a name="272184">Description</a></div> <div class="Body"><a name="656627">Specifies whether to use the driverâ??s connection pooling.</a></div> <div class="Body"><a name="656628">NOTE: The application must be thread-enabled to use connection pooling.</a></div> <div class="Body"><a name="417065">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.06.html#107347', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="292356">Valid Values</a></div> <div class="Body"><a name="656632">0 | 1</a></div> <div class="Body"><a name="656633">If set to 1 (Enabled), the driver uses connection pooling. </a></div> <div class="Body"><a name="656634">If set to 0 (Disabled), the driver does not use connection pooling.</a></div> <div class="gutter_text_right"><a name="272190">Default</a></div> <div class="Body"><a name="272192">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="272193">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111487', '');" name="272198">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="232763">Connection Reset</a></div> <div class="gutter_text_right"><a name="232764">Attribute</a></div> <div class="Body_attr"><a name="232766">ConnectionReset (CR)</a></div> <div class="gutter_text_right"><a name="237107">Description</a></div> <div class="Body"><a name="656638">Determines whether the state of connections that are removed from the connection pool for </a>reuse by the application is reset to the initial configuration of the connection.</div> <div class="Body"><a name="417088">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.06.html#107347', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="292385">Valid Values</a></div> <div class="Body"><a name="656642">0 | 1</a></div> <div class="Body"><a name="656643">If set to 1 (Enabled), the state of connections removed from the connection pool for reuse </a>by an application is reset to the initial configuration of the connection. Resetting the state can negatively impact performance because additional commands must be sent over the network to the server to reset the state of the connection.</div> <div class="Body"><a name="656644">If set to 0 (Disabled), the state of connections is not reset.</a></div> <div class="gutter_text_right"><a name="232767">Default</a></div> <div class="Body"><a name="232769">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="312071">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111487', '');" name="312076">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="189659">Connection Retry Count</a></div> <div class="gutter_text_right"><a name="189660">Attribute</a></div> <div class="Body_attr"><a name="189662">ConnectionRetryCount (CRC)</a></div> <div class="gutter_text_right"><a name="189867">Description</a></div> <div class="Body"><a name="656648">The number of times the driver retries connection attempts to the primary database server, </a>and if specified, alternate servers until a successful connection is established. </div> <div class="Body"><a name="656649">This option and the Connection Retry Delay connection option, which specifies the wait </a>interval between attempts, can be used in conjunction with failover.</div> <div class="gutter_text_right"><a name="292409">Valid Values</a></div> <div class="Body"><a name="656653">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="656654">where </a><span class="EquationVariables">x</span> is a positive integer from 1 to 65535.</div> <div class="Body"><a name="656655">If set to 0, the driver does not try to connect after the initial unsuccessful attempt.</a></div> <div class="Body"><a name="656656">If set to </a><span class="EquationVariables">x</span>, the driver retries connection attempts the specified number of times. If a connection is not established during the retry attempts, the driver returns an error that is generated by the last server to which it tried to connect.</div> <div class="gutter_text_right"><a name="189663">Default</a></div> <div class="Body"><a name="189665">0</a></div> <div class="gutter_text_right"><a name="311991">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111162', '');" name="311996">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="189683">Connection Retry Delay</a></div> <div class="gutter_text_right"><a name="189684">Attribute</a></div> <div class="Body_attr"><a name="189686">ConnectionRetryDelay (CRD)</a></div> <div class="gutter_text_right"><a name="190233">Description</a></div> <div class="Body"><a name="656660">The number of seconds the driver waits between connection retry attempts when </a>Connection Retry Count is set to a positive integer.</div> <div class="Body"><a name="656661">This option and the Connection Retry Count connection option can be used in conjunction </a>with failover.</div> <div class="gutter_text_right"><a name="292462">Valid Values</a></div> <div class="Body"><a name="656665">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="656666">where </a><span class="EquationVariables">x</span> is a positive integer from 1 to 65535.</div> <div class="Body"><a name="656667">If set to 0, there is no delay between retries.</a></div> <div class="Body"><a name="656668">If set to </a><span class="EquationVariables">x</span>, the driver waits the specified number of seconds between connection retry attempts.</div> <div class="gutter_text_right"><a name="189687">Default</a></div> <div class="Body"><a name="189689">3</a></div> <div class="gutter_text_right"><a name="311978">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111162', '');" name="311983">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="191222">Current Function Path</a></div> <div class="gutter_text_right"><a name="191223">Attribute</a></div> <div class="Body_attr"><a name="191225">CurrentFunctionPath (CFP)</a></div> <div class="gutter_text_right"><a name="191291">Description</a></div> <div class="Body"><a name="191313">A comma-separated list of DB2 schema names used to resolve unqualified function names </a>and data type references in dynamically prepared SQL statements. This value also is used to resolve unqualified stored procedure names specified in CALL statements.</div> <div class="gutter_text_right"><a name="191330">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="191334">schema_name</a></span>[,...] </div> <div class="Body"><a name="191337">where </a><span class="EquationVariables">schema_name</span> is the name of a valid DB2 schema.</div> <div class="gutter_text_right"><a name="191226">Default</a></div> <div class="Body"><a name="191228">None</a></div> <div class="gutter_text_right"><a name="311393">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="311398">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="309782">Data Source Name</a></div> <div class="gutter_text_right"><a name="309783">Attribute</a></div> <div class="Body_attr"><a name="309785">DataSourceName (DSN)</a></div> <div class="gutter_text_right"><a name="309786">Description</a></div> <div class="Body"><a name="656672">The name of a data source in your Windows Registry or odbc.ini file.</a></div> <div class="gutter_text_right"><a name="309791">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="656676">string</a></span> </div> <div class="Body"><a name="656677">where </a><span class="EquationVariables">string</span> is the name of a data source.</div> <div class="gutter_text_right"><a name="309797">Default</a></div> <div class="Body"><a name="309799">None</a></div> <div class="gutter_text_right"><a name="309800">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109554', '');" name="309805">General tab</a></span></div> <div class="head_2_no_TOC"><a name="191564">Database Name</a></div> <div class="gutter_text_right"><a name="191565">Attribute</a></div> <div class="Body_attr"><a name="191567">Database (DB)</a></div> <div class="gutter_text_right"><a name="191655">Description</a></div> <div class="Body"><a name="656681">The name of the database to which you want to connect.</a></div> <div class="Body"><a name="191793">Valid only for DB2 for Linux/UNIX/Windows. </a></div> <div class="Body"><a name="292610">This option is mutually exclusive with the Location Name and Collection options.</a></div> <div class="gutter_text_right"><a name="292488">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="656685">ext</a></span></div> <div class="Body"><a name="656686">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="656687">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="656688">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="292491">Default</a></div> <div class="Body"><a name="191570">None</a></div> <div class="gutter_text_right"><a name="311578">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109554', '');" name="311583">General tab</a></span></div> <div class="head_2_no_TOC"><a name="193959">Default Isolation Level</a></div> <div class="gutter_text_right"><a name="193960">Attribute</a></div> <div class="Body_attr"><a name="193962">DefaultIsolationLevel (DIL)</a></div> <div class="gutter_text_right"><a name="194371">Description</a></div> <div class="Body"><a name="193966">The method by which locks on data in the database are acquired and released. </a></div> <div class="Body"><a name="193973">The following table shows how ODBC isolation levels map to DB2 isolation levels.</a></div> <table class="Format_B" cellspacing="0" summary=""> <caption></caption> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><span style="color: #000000; font-size: 10.0pt; font-style: normal; font-variant: normal; font-weight: bold; text-transform: none; vertical-align: baseline;"><a name="193976">ODBC</a></span></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_column_heads"><a name="193978">DB2</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="193980">Read Uncommitted</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="193982">Uncommitted Read</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="193984">Read Committed</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="193986">Cursor Stability</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="193988">Repeatable Read</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="193990">Read Stability</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="193992">Serializable</a></div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="193994">Repeatable Read</a></div> </td> </tr> </table> <div class="Body"><a name="242337">Refer to </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'lock.09.1.html#106144', '');">Chapter 7 â??Locking and Isolation Levelsâ??</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;"> </span><span class="Emphasis" style="font-size: 10.0pt;">Reference</span> for details about ODBC isolation levels.</div> <div class="gutter_text_right"><a name="194221">Valid Values</a></div> <div class="Body"><a name="194246">0 | 1 | 2 | 3 | 4</a></div> <div class="Body"><a name="257994">If set to 0 (READ_UNCOMMITTED), other processes can be read from the database. Only </a>modified data is locked and is not released until the transaction ends.</div> <div class="Body"><a name="257995">If set to 1 (READ_COMMITTED) other processes can change a row that your application </a>has read if the cursor is not on the row you want to change. This level prevents other processes from changing records that your application has changed until your application commits them or ends the transaction. </div> <div class="Body"><a name="533303">It also prevents your application from reading a modified record that has not been </a>committed by another process, unless the Concurrent Access Resolution connection option is set to:</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="533447">Automatic (0) and the cur_commit server parameter is set to On</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="533476">Use Currently Committed (2) and the cur_commit server parameter is set to On or </a>Available</div> </td> </tr> </table> </div> <div class="Body"><a name="533464">In either of these cases, the application can read the last committed value. See the </a>connection option <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.05.html#486967', '');">â??Concurrent Access Resolutionâ??</a></span> for further details.</div> <div class="Body"><a name="533488">See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.11.html#488259', '');">â??Cursor Stability Isolation Levelâ??</a></span> for information about enhancements to the Read Committed (Cursor Stability) isolation level.</div> <div class="Body"><a name="257996">If set to 2 (REPEATABLE_READ), other processes are prevented from accessing data that </a>your application has read or modified. All read or modified data is locked until transaction ends.</div> <div class="Body"><a name="257997">If set to 3 (SERIALIZABLE), other processes are prevented from changing records that are </a>read or changed by your application (including phantom records) until your program commits them or ends the transaction. This level prevents the application from reading modified records that have not been committed by another process. If your application opens the same query during a single unit of work under this isolation level, the results table will be identical to the previous table; however, it can contain updates made by your application.</div> <div class="Body"><a name="257998">If set to 4 (NONE), your application can read modified records even if they have not been </a>committed by another application. This level can only be set in the data source, not from the application. (This level is valid only on DB2 for iSeries, and is the only isolation level that works for collections that have journaling disabled.)</div> <div class="gutter_text_right"><a name="194320">Default</a></div> <div class="Body"><a name="194322">1 (READ_COMMITTED)</a></div> <div class="gutter_text_right"><a name="311406">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="311411">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="193034">Description</a></div> <div class="gutter_text_right"><a name="193035">Attribute</a></div> <div class="Body_attr"><a name="193037">Description (n/a)</a></div> <div class="gutter_text_right"><a name="194594">Description</a></div> <div class="Body"><a name="656692">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="292755">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="656696">string</a></span> </div> <div class="Body"><a name="656697">where </a><span class="EquationVariables">string</span> is a description of a data source.</div> <div class="gutter_text_right"><a name="195426">Default</a></div> <div class="Body"><a name="194630">None</a></div> <div class="gutter_text_right"><a name="311591">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109554', '');" name="311596">General tab</a></span></div> <div class="head_2_no_TOC"><a name="196324">Dynamic Sections</a></div> <div class="gutter_text_right"><a name="196325">Attribute</a></div> <div class="Body_attr"><a name="196327">DynamicSections (DS)</a></div> <div class="gutter_text_right"><a name="196474">Description</a></div> <div class="Body"><a name="196706">The maximum number of prepared statements that the driver can have open at any time. </a></div> <div class="Body"><a name="196927">A dynamic section is associated with a prepared statement. The driver only keeps open the </a>number of prepared statements specified by the dynamic sections value. If the driver detects that the number of dynamic sections available in the bound DB2 packages is less than the number of dynamic sections requested in the connection string or data source, it generates the following message:</div> <div class="syntax_first"><a name="196708">The current number of dynamic sections available for use is different than the </a>number of dynamic sections currently specified in the connection string or data source.</div> <div class="gutter_text_right"><a name="196475">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="196766">x</a></span> </div> <div class="Body"><a name="196769">where </a><span class="EquationVariables">x</span> is a positive integer that specifies the number of prepared statements.</div> <div class="gutter_text_right"><a name="196328">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="196330">1000</a></div> <div class="gutter_text_right"><a name="196790">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#106667', '');" name="196342">Modify Bindings tab</a></span></div> <div class="head_2_no_TOC"><a name="197096">Enable Bulk Load</a></div> <div class="gutter_text_right"><a name="197097">Attribute</a></div> <div class="Body_attr"><a name="197099">EnableBulkLoad (EBL)</a></div> <div class="gutter_text_right"><a name="197349">Description</a></div> <div class="Body"><a name="656701">Specifies the bulk load method. </a></div> <div class="gutter_text_right"><a name="292878">Valid Values</a></div> <div class="Body"><a name="656705">0 | 1</a></div> <div class="Body"><a name="656706">If set to 1 (Enabled), the driver uses the database bulk load protocol when an application </a>executes an INSERT with multiple rows of parameter data. If the protocol cannot be used, the driver returns a warning.</div> <div class="Body"><a name="656707">If set to 0 (Disabled), the driver uses standard parameter arrays.</a></div> <div class="gutter_text_right"><a name="197100">Default</a></div> <div class="Body"><a name="197102">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="198060">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111580', '');" name="197116">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="198493">Encryption Method</a></div> <div class="gutter_text_right"><a name="198494">Attribute</a></div> <div class="Body_attr"><a name="198496">EncryptionMethod (EM)</a></div> <div class="gutter_text_right"><a name="198808">Description</a></div> <div class="Body"><a name="656711">The method the driver uses to encrypt data sent between the driver and the database </a>server. If the specified encryption method is not supported by the database server, the connection fails and the driver returns an error.</div> <div class="Body"><a name="198824">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.06.html#107347', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="198812">Valid Values</a></div> <div class="Body"><a name="198959">0 | 1 | 2</a></div> <div class="Body"><a name="656715">If set to 0 (No Encryption), data is not encrypted.</a></div> <div class="Body"><a name="656716">If set to 1 (SSL), data is encrypted using SSL. If the server supports protocol negotiation, </a>the driver and server negotiate the use of TLS v1, SSL v3, or SSL v2 in that order.</div> <div class="Body"><a name="258419">If set to 2 (Database Encryption), data is encrypted using the DB2 encryption protocol </a>(supported only on DB2 for Linux/UNIX/Windows and DB2 for z/OS).</div> <div class="Body"><a name="258420">This option can only be set to 1 or 2 when Authentication</a> Method is set to 0, 1, or 2.</div> <div class="gutter_text_right"><a name="198497">Default</a></div> <div class="Body"><a name="198499">0 (No Encryption)</a></div> <div class="gutter_text_right"><a name="311667">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#110650', '');" name="311672">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="199359">Failover Granularity</a></div> <div class="gutter_text_right"><a name="199360">Attribute</a></div> <div class="Body_attr"><a name="199362">FailoverGranularity (FG)</a></div> <div class="gutter_text_right"><a name="260070">Description</a></div> <div class="Body"><a name="656720">Determines whether the driver fails the entire failover process or continues with the process </a>if errors occur while trying to reestablish a lost connection. </div> <div class="Body"><a name="656721">This option applies only when Failover Mode is set to 1 (Extended Connection) or 2 </a>(Select). </div> <div class="Body"><a name="656722">The Alternate Servers option specifies one or multiple alternate servers for failover and is </a>required for all failover methods.</div> <div class="gutter_text_right"><a name="199384">Valid Values</a></div> <div class="Body"><a name="656726">0 | 1 | 2 | 3</a></div> <div class="Body"><a name="656727">If set to 0 (Non-Atomic), the driver continues with the failover process and posts any errors </a>on the statement on which they occur. </div> <div class="Body"><a name="656728">If set to 1 (Atomic) the driver fails the entire failover process if an error is generated as the </a>result of anything other than executing and repositioning a Select statement. If an error is generated as a result of repositioning a result set to the last row position, the driver continues with the failover process, but generates a warning that the Select statement must be reissued. </div> <div class="Body"><a name="656729">If set to 2 (Atomic Including Repositioning), the driver fails the entire failover process if any </a>error is generated as the result of restoring the state of the connection or the state of work in progress.</div> <div class="Body"><a name="656730">If set to 3 (Disable Integrity Check), the driver does not verify that the rows that were </a>restored during the failover process match the original rows. This value applies only when Failover Mode is set to 2 (Select).</div> <div class="gutter_text_right"><a name="199620">Default</a></div> <div class="Body"><a name="199622">0 (Non-Atomic)</a></div> <div class="gutter_text_right"><a name="312004">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111162', '');" name="312009">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="199386">Failover Mode</a></div> <div class="gutter_text_right"><a name="199387">Attribute</a></div> <div class="Body_attr"><a name="199389">FailoverMode (FM)</a></div> <div class="gutter_text_right"><a name="591984">Description</a></div> <div class="Body"><a name="656734">Specifies the type of failover method the driver uses. </a></div> <div class="Body"><a name="656735">The Alternate Servers option specifies one or multiple alternate servers for failover and is </a>required for all failover methods.</div> <div class="Body"><a name="591992">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.06.html#107347', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="200370">Valid Values</a></div> <div class="Body"><a name="656739">0 | 1 | 2</a></div> <div class="Body"><a name="656740">If set to 0 (Connection), the driver provides failover protection for new connections only. </a></div> <div class="Body"><a name="656741">If set to 1 (Extended Connection), the driver provides failover protection for new and lost </a>connections, but not any work in progress. </div> <div class="Body"><a name="656742">If set to 2 (Select), the driver provides failover protection for new and lost connections. In </a>addition, it preserves the state of work performed by the last Select statement executed.</div> <div class="gutter_text_right"><a name="199390">Default</a></div> <div class="Body"><a name="199392">0 (Connection)</a></div> <div class="gutter_text_right"><a name="312021">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111162', '');" name="312026">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="200434">Failover Preconnect</a></div> <div class="gutter_text_right"><a name="199412">Attribute</a></div> <div class="Body_attr"><a name="199414">FailoverPreconnect (FP)</a></div> <div class="gutter_text_right"><a name="200804">Description</a></div> <div class="Body"><a name="656746">Specifies whether the driver tries to connect to the primary and an alternate server at the </a>same time. </div> <div class="Body"><a name="656747">This attribute applies only when Failover Mode is set to 1 (Extended Connection) or 2 </a>(Select) and at least one alternate server is specified.</div> <div class="Body"><a name="656748">The Alternate Servers option specifies one or multiple alternate servers for failover and is </a>required for all failover methods.</div> <div class="gutter_text_right"><a name="199433">Valid Values</a></div> <div class="Body"><a name="656752">0 | 1</a></div> <div class="Body"><a name="656753">If set to 0 (Disabled), the driver tries to connect to an alternate server only when failover is </a>caused by an unsuccessful connection attempt or a lost connection. This value provides the best performance, but your application typically experiences a short wait while the failover connection is attempted.</div> <div class="Body"><a name="656754">If set to 1 (Enabled), the driver tries to connect to the primary and an alternate server at the </a>same time. This can be useful if your application is time-sensitive and cannot absorb the wait for the failover connection to succeed.</div> <div class="gutter_text_right"><a name="200603">Default</a></div> <div class="Body"><a name="200605">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="312032">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111162', '');" name="444434">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="552430">Fetch Time Stamp With Time Zone as Timestamp </a></div> <div class="gutter_text_right"><a name="552431">Attribute</a></div> <div class="Body_attr"><a name="552433">FetchTSWTZasTimestamp </a></div> <div class="gutter_text_right"><a name="552434">Descriptio</a> n</div> <div class="Body"><a name="552912">Determines whether the driver returns Timestamp with Time Zone columns as an ODBC </a>SQL_TYPE_TIMESTAMP or as a SQL_VARCHAR data type. </div> <div class="gutter_text_right"><a name="552441">Valid Values</a></div> <div class="Body"><a name="552444">0 | 1</a></div> <div class="Body"><a name="552445">If set to 0 (Disabled), Timestamp with Time Zone columns are mapped to SQL_VARCHAR, </a>allowing your application to retrieve the information as a String.</div> <div class="Body"><a name="552446">If set to 1 (Enabled), the driver maps Timestamp with Time Zone columns to the ODBC </a>SQL_TYPE_TIMESTAMP data type, which can result in time zone information being truncated.</div> <div class="gutter_text_right"><a name="552448">Default</a></div> <div class="Body"><a name="552450">0 (map to SQL_VARCHAR)</a></div> <div class="gutter_text_right"><a name="552451">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="552456">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="630149">Field Delimiter</a></div> <div class="gutter_text_right"><a name="630150">Attribute</a></div> <div class="Body_attr"><a name="630152">BulkLoadFieldDelimiter (BLFD)</a></div> <div class="gutter_text_right"><a name="630153">Description</a></div> <div class="Body"><a name="657001">Specifies the character that the driver will use to delimit the field entries in a bulk load data </a>file.</div> <div class="gutter_text_right"><a name="630158">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="657040">x</a></span></div> <div class="Body"><a name="657041">where </a><span class="EquationVariables">x</span> is any printable character. </div> <div class="Body"><a name="657042">For simplicity, avoid using a value that can be in the data, including all alphanumeric </a>characters, the dash(-), the colon(:), the period (.), the forward slash (/), the space character, the single quote (') and the double quote ("). You can use some of these characters as delimiters if all of the data in the file is contained within double quotes.</div> <div class="Body"><a name="657043">NOTE: The Bulk Load Field Delimiter character must be different from the Bulk Load </a>Record Delimiter.</div> <div class="gutter_text_right"><a name="630166">Default</a></div> <div class="Body"><a name="630167">None</a></div> <div class="gutter_text_right"><a name="630168">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111580', '');" name="630173">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="444437">Grant Execute to [check box]</a></div> <div class="gutter_text_right"><a name="444438">Attribute</a></div> <div class="Body_attr"><a name="270759">GrantExecute (GE)</a></div> <div class="gutter_text_right"><a name="270760">Description</a></div> <div class="Body"><a name="270761">Determines how EXECUTE privileges are granted on DB2 packages. </a></div> <div class="gutter_text_right"><a name="270762">Valid Values</a></div> <div class="Body"><a name="270763">0 | 1</a></div> <div class="Body"><a name="270764">If set to 1 (Enabled), EXECUTE privileges are granted on DB2 packages that you are </a>creating. By default, the schema to which privileges are granted is PUBLIC.</div> <div class="Body"><a name="270765">If set to 0 (Disabled), EXECUTE privileges are granted to the schema that created the DB2 </a>packages.</div> <div class="gutter_text_right"><a name="270766">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="270768">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="311865">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#106667', '');" name="311870">Modify Bindings tab</a></span></div> <div class="head_2_no_TOC"><a name="200878">Grant Execute to [field]</a></div> <div class="gutter_text_right"><a name="200879">Attribute</a></div> <div class="Body_attr"><a name="200881">GrantAuthid (GA)</a></div> <div class="gutter_text_right"><a name="200990">Description</a></div> <div class="Body"><a name="201569">Determines which DB2 schema is granted EXECUTE privileges for DB2 packages.</a></div> <div class="gutter_text_right"><a name="202149">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="202715">schema_name</a></span> </div> <div class="Body"><a name="202718">where </a><span class="EquationVariables">schema_name</span> is the name of a valid DB2 schema.</div> <div class="gutter_text_right"><a name="200882">Default</a></div> <div class="Body"><a name="200884">PUBLIC</a></div> <div class="gutter_text_right"><a name="311904">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#106667', '');" name="311909">Modify Bindings tab</a></span></div> <div class="head_2_no_TOC"><a name="203747">GSS Client Library</a></div> <div class="gutter_text_right"><a name="203749">Attribute</a></div> <div class="Body_attr"><a name="203751">GSSClient (GSSC)</a></div> <div class="gutter_text_right"><a name="204009">Description</a></div> <div class="Body"><a name="656758">The name of the GSS client library that the driver uses to communicate with the Key </a>Distribution Center (KDC). </div> <div class="Body"><a name="656759">The driver uses the path defined by the PATH environment variable for loading the specified </a>client library.</div> <div class="gutter_text_right"><a name="204572">Valid Values</a></div> <div class="Body"><a name="656763">native | </a><span class="EquationVariables">client_library</span></div> <div class="Body"><a name="656764">where </a><span class="EquationVariables">client_library</span> is a GSS client library installed on the client.</div> <div class="Body"><a name="656765">If set to </a><span class="EquationVariables">client_library</span>, the driver uses the specified GSS client library.</div> <div class="Body"><a name="656766">If set to native, the driver uses the GSS client shipped with the operating system.</a></div> <div class="gutter_text_right"><a name="203752">Default</a></div> <div class="Body"><a name="203754">native</a></div> <div class="gutter_text_right"><a name="311688">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#110650', '');" name="311693">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="203769">Host Name In Certificate</a></div> <div class="gutter_text_right"><a name="203770">Attribute</a></div> <div class="Body_attr"><a name="411945">HostNameInCertificate (HNIC)</a></div> <div class="gutter_text_right"><a name="203776">Description</a></div> <div class="Body"><a name="656770">A host name for certificate validation when SSL encryption is enabled (Encryption Method=</a>1) and validation is enabled (Validate Server Certificate=1). This option provides additional security against man-in-the-middle (MITM) attacks by ensuring that the server the driver is connecting to is the server that was requested.</div> <div class="gutter_text_right"><a name="457054">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="656774">host_name | #SERVERNAME#</a></span> </div> <div class="Body"><a name="656775">where the </a><span class="EquationVariables">host_name</span> is the host name specified in the certificate. Consult your SSL administrator for the correct value.</div> <div class="Body"><a name="656776">If set to a host name, the driver examines the subjectAltName values included in the </a>certificate. If a dnsName value is present in the subjectAltName values, then the driver compares the value specified for Host Name In Certificate with the dnsName value. The connection succeeds if the values match. The connection fails if the Host Name In Certificate value does not match the dnsName value.</div> <div class="Body"><a name="656777">If no subjectAltName values exist or a dnsName value is not in the list of subjectAltName </a>values, then the driver compares the value specified for Host Name In Certificate with the commonName part of the Subject name in the certificate. The commonName typically contains the host name of the machine for which the certificate was created. The connection succeeds if the values match. The connection fails if the Host Name In Certificate value does not match the commonName. If multiple commonName parts exist in the Subject name of the certificate, the connection succeeds if the Host Name In Certificate value matches any of the commonName parts.</div> <div class="Body"><a name="656778">If set to </a><span class="EquationVariables">#SERVERNAME#</span>, the driver compares the host server name specified as part of a data source or connection string to the dnsName or the commonName value.</div> <div class="gutter_text_right"><a name="457063">Default</a></div> <div class="Body"><a name="457064">None</a></div> <div class="gutter_text_right"><a name="311711">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#110650', '');" name="640750">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="640762">IANAAppCodePage </a></div> <div class="gutter_text_right"><a name="640763">Attribute</a></div> <div class="Body_attr"><a name="206099">IANAAppCodePage (IACP)</a></div> <div class="gutter_text_right"><a name="206237">Description</a></div> <div class="Body"><a name="656782">An Internet Assigned Numbers Authority (IANA) value. You must specify a value for this </a>option if your application is not Unicodeâ??enabled 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. </div> <div class="Body"><a name="656790">The driver uses the specified IANA code page to convert "W" (wide) functions to ANSI.</a></div> <div class="Body"><a name="656791">The driver and Driver Manager both check for the value of IANAAppCodePage in the </a>following order:</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="656792">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="656793">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="656794">In the ODBC section of the system information file (odbc.ini)</a></div> </td> </tr> </table> </div> <div class="Body"><a name="656795">If the driver does not find an IANAAppCodePage value, the driver uses the default value of </a>4 (ISO 8859-1 Latin-1).</div> <div class="gutter_text_right"><a name="297368">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="656799">IANA_code_page</a></span> </div> <div class="Body"><a name="656801">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="297376">Default</a></div> <div class="Body"><a name="206102">4 (ISO 8559-1 Latin-1)</a></div> <div class="gutter_text_right"><a name="311435">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="311440">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="208483">Ip Address</a></div> <div class="gutter_text_right"><a name="208484">Attribute</a></div> <div class="Body_attr"><a name="208486">IpAddress (IP)</a></div> <div class="gutter_text_right"><a name="208652">Description</a></div> <div class="Body"><a name="209012">Identifies the machine where catalog tables are stored.</a></div> <div class="gutter_text_right"><a name="208656">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="209161">host_name</a></span> | <span class="EquationVariables">IP_address</span></div> <div class="Body"><a name="209184">where </a></div> <div class="Body"><span class="EquationVariables"><a name="209224">host_name</a></span> is the host name of the machine where catalog tables are stored. The driver must be able to find this name (with the correct address assignment) in the HOSTS file on the workstation or in a DNS server.</div> <div class="Body"><span class="EquationVariables"><a name="656808">IP_address</a></span> is the IP address of the machine where catalog tables are stored. The IP address can be specified in either IPv4 or IPv6 format, or a combination of the two. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'usingproduct.05.05.html#107073', '');">â??Using IP Addressesâ??</a></span> for details about these formats.</div> <div class="Body"><a name="596480">Default</a></div> <div class="Body"><a name="208489">localhost</a></div> <div class="gutter_text_right"><a name="311620">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109554', '');" name="311625">General tab</a></span></div> <div class="head_2_no_TOC"><a name="209840">Key Password</a></div> <div class="gutter_text_right"><a name="209841">Attribute</a></div> <div class="Body_attr"><a name="209843">KeyPassword (KP)</a></div> <div class="gutter_text_right"><a name="210025">Description</a></div> <div class="Body"><a name="656816">The password used to access the individual keys in the keystore file when SSL is enabled </a>(Encryption Method=1) and SSL client authentication is enabled on the database server. Keys stored in a keystore can be individually password-protected. To extract the key from the keystore, the driver must have the password of the key.</div> <div class="gutter_text_right"><a name="297701">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="656820">key_password</a></span></div> <div class="Body"><a name="656821">where </a><span class="EquationVariables">key_password</span> is the password of a key in the keystore.</div> <div class="gutter_text_right"><a name="209844">Default</a></div> <div class="Body"><a name="209846">None</a></div> <div class="gutter_text_right"><a name="311730">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#110650', '');" name="311735">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="209862">Keystore</a></div> <div class="gutter_text_right"><a name="209863">Attribute</a></div> <div class="Body_attr"><a name="209865">Keystore (KS)</a></div> <div class="gutter_text_right"><a name="210215">Description</a></div> <div class="Body"><a name="656825">The name of the directory containing the keystore file to be used when SSL is enabled </a>(Encryption Method=1) and SSL client authentication is enabled on the database server. The keystore file contains the certificates that the client sends to the server in response to the serverâ??s certificate request. If you do not specify a directory, the current directory is used.</div> <div class="Body"><a name="656826">NOTE: The keystore and truststore files may be the same file.</a></div> <div class="gutter_text_right"><a name="297737">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="656830">keystore_directory</a></span></div> <div class="Body"><a name="656831">where </a><span class="EquationVariables">keystore_directory</span> is the location of the keystore file.</div> <div class="gutter_text_right"><a name="209866">Default</a></div> <div class="Body"><a name="209868">None</a></div> <div class="gutter_text_right"><a name="311739">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#110650', '');" name="311744">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="209884">Keystore Password</a></div> <div class="gutter_text_right"><a name="209885">Attribute</a></div> <div class="Body_attr"><a name="209887">KeystorePassword (KSP)</a></div> <div class="gutter_text_right"><a name="210585">Description</a></div> <div class="Body"><a name="656835">The password used to access the keystore file when SSL is enabled (Encryption Method=1) </a>and SSL client authentication is enabled on the database server. The keystore file contains the certificates that the client sends to the server in response to the serverâ??s certificate request. </div> <div class="Body"><a name="656836">NOTE: The keystore and truststore files may be the same file; therefore, they may have the </a>same password.</div> <div class="gutter_text_right"><a name="297752">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="656840">keystore_password</a></span></div> <div class="Body"><a name="656841">where </a><span class="EquationVariables">keystore_password</span> is the password of the keystore file.</div> <div class="gutter_text_right"><a name="210584">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="209890">None</a></div> <div class="gutter_text_right"><a name="311748">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#110650', '');" name="311753">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="211558">Load Balance Timeout</a></div> <div class="gutter_text_right"><a name="211559">Attribute</a></div> <div class="Body_attr"><a name="211561">LoadBalanceTimeout (LBT)</a></div> <div class="gutter_text_right"><a name="211682">Description</a></div> <div class="Body"><a name="656845">The number of seconds to keep inactive connections open in a connection pool. An inactive </a>connection is a database session that is not associated with an ODBC connection handle, that is, a connection in the pool that is not in use by an application.</div> <div class="Body"><a name="656846">NOTE: The Min Pool Size option may cause some connections to ignore this value.</a></div> <div class="Body"><a name="417379">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.06.html#107347', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="298568">Valid Values</a></div> <div class="Body"><a name="656850">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="656851">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="656852">If set to 0, inactive connections are kept open.</a></div> <div class="Body"><a name="656853">If set to </a><span class="EquationVariables">x</span>, inactive connections are closed after the specified number of seconds passes.</div> <div class="gutter_text_right"><a name="242739">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="211564">0</a></div> <div class="gutter_text_right"><a name="312084">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111487', '');" name="312089">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="298422">Load Balancing</a></div> <div class="gutter_text_right"><a name="298423">Attribute</a></div> <div class="Body_attr"><a name="298425">LoadBalancing (LB)</a></div> <div class="gutter_text_right"><a name="298426">Description</a></div> <div class="Body"><a name="656857">Determines whether the driver uses client load balancing in its attempts to connect to the </a>database servers (primary and alternate). You can specify one or multiple alternate servers by setting the Alternate Servers option. </div> <div class="gutter_text_right"><a name="298591">Valid Values</a></div> <div class="Body"><a name="656861">0 | 1</a></div> <div class="Body"><a name="656862">If set to 1 (Enabled), the driver uses client load balancing and attempts to connect to the </a>database servers (primary and alternate servers) in random order. </div> <div class="Body"><a name="656863">If set to 0 (Disabled), the driver does not use client load balancing and connects to each </a>server based on their sequential order (primary server first, then, alternate servers in the order they are specified).</div> <div class="Body"><a name="656864">NOTE: This option has no effect unless alternate servers are defined for the Alternate </a>Servers connection option.</div> <div class="gutter_text_right"><a name="298435">Default</a></div> <div class="Body"><a name="298437">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="298438">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111162', '');" name="298440">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="213836">Location Name</a></div> <div class="gutter_text_right"><a name="213837">Attribute</a></div> <div class="Body_attr"><a name="213839">Location (LOC)</a></div> <div class="gutter_text_right"><a name="213974">Description</a></div> <div class="Body"><a name="214378">Valid only for DB2 for z/OS and iSeries. The name of the DB2 location that you want to </a>access. </div> <div class="Body"><a name="214380">On DB2 for z/OS, your system administrator can determine the name of your DB2 location </a>using the <span class="Syntax">DISPLAY</span><span class="Syntax"> </span><span class="Syntax">DDF</span> command.</div> <div class="Body"><a name="214381">On DB2 for iSeries, your system administrator can determine the name of your DB2 location </a>using the <span class="Syntax">WRKRDBDIRE</span> command. The name of the database that is listed as *LOCAL" is the value to use.</div> <div class="Body"><a name="214382">This option is mutually exclusive with the Database Name option.</a></div> <div class="gutter_text_right"><a name="213994">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="214556">location_name</a></span> </div> <div class="Body"><a name="214571">where </a><span class="EquationVariables">location_name</span> is the name of a valid DB2 location.</div> <div class="gutter_text_right"><a name="213840">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="213842">None</a></div> <div class="gutter_text_right"><a name="311629">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109554', '');" name="311634">General tab</a></span></div> <div class="head_2_no_TOC"><a name="214936">Login Timeout</a></div> <div class="gutter_text_right"><a name="214937">Attribute</a></div> <div class="Body_attr"><a name="214939">LoginTimeout (LT)</a></div> <div class="gutter_text_right"><a name="215071">Description</a></div> <div class="Body"><a name="656868">The number of seconds the driver waits for a connection to be established before returning </a>control to the application and generating a timeout error. To override the value that is set by this connection option for an individual connection, set a different value in the SQL_ATTR_LOGIN_TIMEOUT connection attribute using the SQLSetConnectAttr() function.</div> <div class="gutter_text_right"><a name="298670">Valid Values</a></div> <div class="Body"><a name="656872">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="656873">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="656874">If set to -1, the connection request does not time out. The driver silently ignores the </a>SQL_ATTR_LOGIN_TIMEOUT attribute.</div> <div class="Body"><a name="656875">If set to 0, the connection request does not time out, but the driver responds to the </a>SQL_ATTR_LOGIN_TIMEOUT attribute.</div> <div class="Body"><a name="656876">If set to </a><span class="EquationVariables">x</span>, the connection request times out after the specified number of seconds unless the application overrides this setting with the SQL_ATTR_LOGIN_TIMEOUT attribute.</div> <div class="gutter_text_right"><a name="215344">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="215346">15</a></div> <div class="gutter_text_right"><a name="311450">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="311455">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="299048">Max Pool Size</a></div> <div class="gutter_text_right"><a name="299049">Attribute</a></div> <div class="Body_attr"><a name="299050">MaxPoolSize (MXPS)</a></div> <div class="gutter_text_right"><a name="299051">Description</a></div> <div class="Body"><a name="656880">The maximum number of connections allowed within a single connection pool. When the </a>maximum number of connections is reached, no additional connections can be created in the connection pool.</div> <div class="Body"><a name="417263">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.06.html#107347', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="299056">Valid Values</a></div> <div class="Body"><a name="656884">An integer from 1 to 65535</a></div> <div class="Body"><a name="656885">For example, if set to 20, the maximum number of connections allowed in the pool is 20.</a></div> <div class="gutter_text_right"><a name="299062">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="299064">100</a></div> <div class="gutter_text_right"><a name="312093">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111487', '');" name="312098">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="299071">Min Pool Size</a></div> <div class="gutter_text_right"><a name="299072">Attribute</a></div> <div class="Body_attr"><a name="299073">MinPoolSize (MNPS)</a></div> <div class="gutter_text_right"><a name="299074">Description</a></div> <div class="Body"><a name="656889">The minimum number of connections that are opened and placed in a connection pool, in </a>addition to the active connection, when the pool is created. The connection pool retains this number of connections, even when some connections exceed their Load Balance Timeout value. </div> <div class="Body"><a name="417344">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.06.html#107347', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="299079">Valid Values</a></div> <div class="Body"><a name="656893">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="656894">where </a><span class="EquationVariables">x</span> is an integer from 1 to 65535.</div> <div class="Body"><a name="656895">For example, if set to 5, the start-up number of connections in the pool is 5 in addition to the </a>current existing connection.</div> <div class="Body"><a name="656896">If set to 0, no connections are opened in addition to the current existing connection.</a></div> <div class="gutter_text_right"><a name="299085">Default</a></div> <div class="Body"><a name="299087">0</a></div> <div class="gutter_text_right"><a name="312102">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111487', '');" name="312107">Pooling tab</a></span></div> <div class="head_2_no_TOC"><a name="219079">Package Collection</a></div> <div class="gutter_text_right"><a name="219080">Attribute</a></div> <div class="Body_attr"><a name="219082">PackageCollection (PC)</a></div> <div class="gutter_text_right"><a name="219184">Description</a></div> <div class="Body"><a name="219218">The name of the DB2 collection or location where the driver creates bind packages and, </a>when required, searches for them.</div> <div class="gutter_text_right"><a name="219250">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="219268">collection_name</a></span> </div> <div class="Body"><a name="219273">where </a><span class="EquationVariables">collection_name</span> is a valid DB2 collection or location name.</div> <div class="gutter_text_right"><a name="219083">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="219085">NULLID</a></div> <div class="gutter_text_right"><a name="311927">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#106667', '');" name="311932">Modify Bindings tab</a></span></div> <div class="head_2_no_TOC"><a name="220090">Package Name Prefix</a></div> <div class="gutter_text_right"><a name="220091">Attribute</a></div> <div class="Body_attr"><a name="220093">PackageNamePrefix (PNP)</a></div> <div class="gutter_text_right"><a name="220222">Description</a></div> <div class="Body"><a name="220459">A two-character prefix used for package names when the driver executes dynamic SQL. </a>The default package name uses the following syntax:</div> <div class="syntax_first"><span class="EquationVariables"><a name="220460">DD</a></span>O<span class="EquationVariables">iVRMx</span></div> <div class="Body"><a name="220461">where:</a></div> <div class="Body"><span class="EquationVariables"><a name="220577">DD</a></span> is the two-character prefix.</div> <div class="Body"><span class="EquationVariables"><a name="220462">i</a></span> is one of the following characters:</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="220634">Sâ??Serializable : DB2 RR</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="220635">Râ??Repeatable Read : DB2 RS</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="220636">Câ??Committed Read : DB2 CS</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="220466">Uâ??Uncommitted Read : DB2 UC</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="220467">Nâ??Not committed: DB2 NC</a></div> </td> </tr> </table> </div> <div class="Body"><span class="EquationVariables"><a name="220468">VRM</a></span> is the Version Release Modification, for example, you can specify 520 to represent version 5.2.0.</div> <div class="Body"><span class="EquationVariables"><a name="220469">x</a></span> is a one-character suffix that specifies:</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="220470">Aâ??Cursor queries/updates</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="220471">Bâ??Cursor queries/updates with hold</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="220472">Câ??Stored procedures (section 1 is for stored procedures that do not have parameters; </a>section 2 is for procedures that do have parameters)</div> </td> </tr> </table> </div> <div class="Body"><a name="220473">For example, the package name DDOC520A would represent a package using the </a>Committed Read isolation level, at version 5.20, and using cursor queries/updates.</div> <div class="gutter_text_right"><a name="220226">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="220658">xx</a></span></div> <div class="Body"><a name="220661">where </a><span class="EquationVariables">xx</span> is a two-character prefix.</div> <div class="gutter_text_right"><a name="220094">Default</a></div> <div class="Body"><a name="220096">DD</a></div> <div class="gutter_text_right"><a name="311459">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="311464">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="219097">Package Owner</a></div> <div class="gutter_text_right"><a name="219098">Attribute</a></div> <div class="Body_attr"><a name="219100">PackageOwner (PO)</a></div> <div class="gutter_text_right"><a name="220754">Description</a></div> <div class="Body"><a name="220955">The AuthID assigned to the package. </a></div> <div class="gutter_text_right"><a name="221233">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="221307">authid</a></span></div> <div class="Body"><a name="221319">where </a><span class="EquationVariables">authid</span> is a valid DB2 AuthID that has permissions to execute all the SQL in the package.</div> <div class="gutter_text_right"><a name="219101">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="219103">None</a></div> <div class="gutter_text_right"><a name="311952">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#106667', '');" name="311957">Modify Bindings tab</a></span></div> <div class="head_2_no_TOC"><a name="221851">Password</a></div> <div class="gutter_text_right"><a name="221852">Attribute</a></div> <div class="Body_attr"><a name="221854">Password (PWD)</a></div> <div class="gutter_text_right"><a name="221923">Description</a></div> <div class="Body"><a name="656900">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="221944">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="656904">pwd</a></span> </div> <div class="Body"><a name="656905">where </a><span class="EquationVariables">pwd</span> is a valid password.</div> <div class="gutter_text_right"><a name="221945">Default</a></div> <div class="Body"><a name="221857">None</a></div> <div class="gutter_text_right"><a name="426775">GUI Tab</a></div> <div class="Body"><a name="426773">n/a</a></div> <div class="head_2_no_TOC"><a name="223078">Program ID</a></div> <div class="gutter_text_right"><a name="223079">Attribute</a></div> <div class="Body_attr"><a name="223081">ProgramID (PID)</a></div> <div class="gutter_text_right"><a name="223172">Description</a></div> <div class="Body"><a name="223296">The product and version information of the driver on the client to be stored in the database. </a>This value sets the CLIENT_PRDID value in the database. For DB2 V9.1 and higher for Linux/UNIX/Windows, this value is located in the SYSIBMADM.APPLICATIONS table. This value is used by the DB2 Workload Manager.</div> <div class="Body"><a name="314770">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.06.html#107347', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="223262">Valid Values</a></div> <div class="syntax_first"><a name="223646">DDT</a><span class="EquationVariables">VVRRM</span></div> <div class="Body"><a name="223636">where </a><span class="EquationVariables">DDTVVRRM</span> is a value that identifies the product and version of the driver on the client.</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="559898"> </a><span class="EquationVariables">DDT</span> identifies a DataDirect Connect driver. </div> </td> </tr> </table> </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"><span class="EquationVariables"><a name="559900">VV</a></span> identifies a 2-digit version number (with high-order 0 in the case of a 1-digit version). </div> </td> </tr> </table> </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"><span class="EquationVariables"><a name="559916">RR</a></span> identifies a 2-digit release number (with high-order 0 in the case of a 1-digit release). </div> </td> </tr> </table> </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"><span class="EquationVariables"><a name="559917">M</a></span> identifies a 1-character modification level (0-9 or A-Z).</div> </td> </tr> </table> </div> <div class="gutter_text_right"><a name="559918">Example</a></div> <div class="Body"><a name="223293">DDT06010</a></div> <div class="gutter_text_right"><a name="223082">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="223084">None</a></div> <div class="gutter_text_right"><a name="311482">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#628565', '');" name="493625">Client Monitoring tab</a></span></div> <div class="head_2_no_TOC"><a name="223793">Query Timeout</a></div> <div class="gutter_text_right"><a name="223794">Attribute</a></div> <div class="Body_attr"><a name="223796">QueryTimeout (QT)</a></div> <div class="gutter_text_right"><a name="223868">Description</a></div> <div class="Body"><a name="656909">The number of seconds for the default query timeout for all statements that are created by a </a>connection. To override the value set by this connection option for an individual statement, set a different value in the SQL_ATTR_QUERY_TIMEOUT statement attribute on the SQLSetStmtAttr() function.</div> <div class="Body"><a name="525079">Query timeout is supported on DB2 for Linux/UNIX/Windows 8.1 and higher and on DB2 for </a>z/OS 8.1 and higher</div> <div class="gutter_text_right"><a name="223814">Valid Values</a></div> <div class="Body"><a name="656913">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="656914">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="656915">If set to -1, the query does not time out. The driver silently ignores the </a>SQL_ATTR_QUERY_TIMEOUT attribute.</div> <div class="Body"><a name="656916">If set to 0, the query does not time out, but the driver responds to the </a>SQL_ATTR_QUERY_TIMEOUT attribute.</div> <div class="Body"><a name="656917">If set to </a><span class="EquationVariables">x</span>, all queries time out after the specified number of seconds unless the application overrides this value by setting the SQL_ATTR_QUERY_TIMEOUT attribute.</div> <div class="gutter_text_right"><a name="409454">Default</a></div> <div class="Body"><a name="224055">0</a></div> <div class="gutter_text_right"><a name="311491">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="311496">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="631080">Record Delimiter</a></div> <div class="gutter_text_right"><a name="631081">Attribute</a></div> <div class="Body_attr"><a name="631083">BulkLoadRecordDelimiter (BLRD)</a></div> <div class="gutter_text_right"><a name="631084">Description</a></div> <div class="Body"><a name="657029">Specifies the character that the driver will use to delimit the record entries in a bulk load data </a>file.</div> <div class="gutter_text_right"><a name="631089">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="657033">x</a></span></div> <div class="Body"><a name="657034">where </a><span class="EquationVariables">x</span> is any printable character. </div> <div class="Body"><a name="657035">For simplicity, avoid using a value that can be in the data, including all alphanumeric </a>characters, the dash(-), the colon(:), the period (.), the forward slash (/), the space character, the single quote (') and the double quote ("). You can use some of these characters as delimiters if all of the data in the file is contained within double quotes.</div> <div class="Body"><a name="657036">NOTE: The Bulk Load Record Delimiter character must be different from the Bulk Load </a>Field Delimiter.</div> <div class="gutter_text_right"><a name="631097">Default</a></div> <div class="Body"><a name="631098">None</a></div> <div class="gutter_text_right"><a name="631099">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#111580', '');" name="631104">Bulk tab</a></span></div> <div class="head_2_no_TOC"><a name="225087"> Report Codepage Conversion Errors</a></div> <div class="gutter_text_right"><a name="225088">Attribute</a></div> <div class="Body_attr"><a name="225090">ReportCodepageConversionErrors (RCCE)</a></div> <div class="gutter_text_right"><a name="225209">Description</a></div> <div class="Body"><a name="656921">Specifies how the driver handles code page conversion errors that occur when a character </a>cannot be converted from one character set to another.</div> <div class="Body"><a name="656922">An error message or warning can occur if an ODBC call causes a conversion error, or if an </a>error occurs during code page conversions to and from the database or to and from the application. The error or warning generated is <span class="Syntax">Code page conversion error encountered</span>. In the case of parameter data conversion errors, the driver adds the following sentence: <span class="Syntax">Error in parameter</span><span class="Syntax"> </span><span class="EquationVariables">x</span>, where <span class="EquationVariables">x</span> is the parameter number. The standard rules for returning specific row and column errors for bulk operations apply.</div> <div class="gutter_text_right"><a name="225523">Valid Values</a></div> <div class="Body"><a name="656926">0 | 1 | 2</a></div> <div class="Body"><a name="656927">If set to 0 (Ignore Errors), the driver substitutes 0x1A for each character that cannot be </a>converted and does not return a warning or error.</div> <div class="Body"><a name="656928">If set to 1 (Return Error), the driver returns an error instead of substituting 0x1A for </a>unconverted characters.</div> <div class="Body"><a name="656929">If set to 2 (Return Warning), the driver substitutes 0x1A for each character that cannot be </a>converted and returns a warning.</div> <div class="gutter_text_right"><a name="225091">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="225093">0 (Ignore Errors)</a></div> <div class="gutter_text_right"><a name="311500">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="311505">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="225655">Tcp Port</a></div> <div class="gutter_text_right"><a name="225656">Attribute</a></div> <div class="Body_attr"><a name="225658">TcpPort (PORT)</a></div> <div class="gutter_text_right"><a name="225792">Description</a></div> <div class="Body"><a name="226368">The port number that is assigned to the DB2 DRDA listener process on the server host </a>machine. </div> <div class="Body"><a name="227329">On DB2 for iSeries only, execute </a><span class="Syntax">NETSTAT</span> from a command line to determine the correct port number. Select option 3 to display a list of active ports on the iSeries machine. Find the entry for DRDA, and press F14 to toggle and display the port number. If DRDA is not currently listening, the command <span class="Syntax">CHGDDMTCPA AUTOSTART(*YES) PWDRQD(*YES)</span> starts the listener and ensures that it is active at IPL.</div> <div class="gutter_text_right"><a name="226922">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="226963">IP_address</a></span> | <span class="EquationVariables">service_name</span></div> <div class="Body"><a name="227030">where:</a></div> <div class="Body"><span class="EquationVariables"><a name="227077">IP_address</a></span> is the portâ??s IP address.</div> <div class="Body"><span class="EquationVariables"><a name="227158">service_name</a></span> is the portâ??s service name. The driver must be able to find this name (with the correct port assignment) in the SERVICES file on the workstation. </div> <div class="gutter_text_right"><a name="226115">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="226117">50000</a></div> <div class="gutter_text_right"><a name="311642">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109554', '');" name="311647">General tab</a></span></div> <div class="head_2_no_TOC"><a name="227960">Truststore</a></div> <div class="gutter_text_right"><a name="227961">Attribute</a></div> <div class="Body_attr"><a name="227963">Truststore (TS)</a></div> <div class="gutter_text_right"><a name="228074">Description</a></div> <div class="Body"><a name="656933">The directory that contains the truststore file and the truststore file name to be used when </a>SSL is enabled (Encryption Method=1) and server authentication is used. The truststore file contains a list of the valid Certificate Authorities (CAs) that are trusted by the client machine for SSL server authentication. If you do not specify a directory, the current directory is used.</div> <div class="Body"><a name="656934">NOTE: The truststore and keystore files may be the same file.</a></div> <div class="gutter_text_right"><a name="299435">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="656938">truststore_directory\filename</a></span> </div> <div class="Body"><a name="656939">where </a><span class="EquationVariables">truststore_directory</span> is the directory where the truststore file is located and <span class="EquationVariables">filename</span> is the file name of the truststore file.</div> <div class="gutter_text_right"><a name="227964">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="227966">None</a></div> <div class="gutter_text_right"><a name="311757">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#110650', '');" name="311762">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="227982">Truststore Password</a></div> <div class="gutter_text_right"><a name="227983">Attribute</a></div> <div class="Body_attr"><a name="227985">TruststorePassword (TSP)</a></div> <div class="gutter_text_right"><a name="228319">Description</a></div> <div class="Body"><a name="656943">The password that is used to access the truststore file when SSL is enabled (Encryption </a>Method=1) and server authentication is used. The truststore file contains a list of the Certificate Authorities (CAs) that the client trusts. </div> <div class="Body"><a name="656944">NOTE: The truststore and keystore files may be the same file; therefore, they may have the </a>same password.</div> <div class="gutter_text_right"><a name="299464">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="656948">truststore_password</a></span></div> <div class="Body"><a name="656949">where </a><span class="EquationVariables">truststore_password</span> is a valid password for the truststore file.</div> <div class="gutter_text_right"><a name="227986">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="227988">None</a></div> <div class="gutter_text_right"><a name="311778">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#110650', '');" name="311783">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="228697">Use Current Schema for Catalog Functions</a></div> <div class="gutter_text_right"><a name="228698">Attribute</a></div> <div class="Body_attr"><a name="228700">UseCurrentSchema (UCS)</a></div> <div class="gutter_text_right"><a name="228777">Description</a></div> <div class="Body"><a name="228851">Specifies whether results are restricted to the tables and views in the current schema if a </a>catalog function call is made without specifying a schema or if the schema is specified as the wildcard character %. Restricting results to the tables and views in the current schema improves performance of catalog calls that do not specify a schema. </div> <div class="gutter_text_right"><a name="229315">Valid Values</a></div> <div class="Body"><a name="229435">0 | 1</a></div> <div class="Body"><a name="265537">If set to 1 (Enabled), results of catalog function calls are restricted to the tables and views in </a>the current schema.</div> <div class="Body"><a name="265538">If set to 0 (Disabled), results of catalog function calls are not restricted.</a></div> <div class="gutter_text_right"><a name="228701">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="228703">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="311525">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="311530">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="271794">User Name</a></div> <div class="gutter_text_right"><a name="271795">Attribute</a></div> <div class="Body_attr"><a name="271797">LogonID (UID)</a></div> <div class="gutter_text_right"><a name="271798">Description</a></div> <div class="Body"><a name="656953">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="299587">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="656957">userid</a></span></div> <div class="Body"><a name="656958">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="299590">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="271807">None</a></div> <div class="gutter_text_right"><a name="311799">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#110650', '');" name="311804">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="229560">Validate Server Certificate</a></div> <div class="gutter_text_right"><a name="229561">Attribute</a></div> <div class="Body_attr"><a name="229563">ValidateServerCertificate (VSC)</a></div> <div class="gutter_text_right"><a name="229620">Description</a></div> <div class="Body"><a name="656962">Determines whether the driver validates the certificate that is sent by the database server </a>when SSL encryption is enabled (Encryption Method=1). When using SSL server authentication, any certificate sent by the server must be issued by a trusted Certificate Authority (CA). Allowing the driver to trust any certificate returned from the server even if the issuer is not a trusted CA is useful in test environments because it eliminates the need to specify truststore information on each client in the test environment. </div> <div class="Body"><a name="656963">Truststore information is specified using the Trust Store and Trust Store Password options. </a></div> <div class="gutter_text_right"><a name="229736">Valid Values</a></div> <div class="Body"><a name="656967">0 | 1</a></div> <div class="Body"><a name="656968">If set to 1 (Enabled), the driver validates the certificate that is sent by the database server. </a>Any certificate from the server must be issued by a trusted CA in the truststore file. If the Host Name In Certificate option is specified, the driver also validates the certificate using a host name. The Host Name In Certificate option provides additional security against man-in-the-middle (MITM) attacks by ensuring that the server the driver is connecting to is the server that was requested. </div> <div class="Body"><a name="656970">If set to 0 (Disabled), the driver does not validate the certificate that is sent by the database </a>server. The driver ignores any truststore information specified by the Trust Store and Trust Store Password options. </div> <div class="gutter_text_right"><a name="229564">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="229566">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="311832">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#110650', '');" name="311837">Security tab</a></span> </div> <div class="head_2_no_TOC"><a name="230127">With Hold Cursors</a></div> <div class="gutter_text_right"><a name="230128">Attribute</a></div> <div class="Body_attr"><a name="230130">WithHold (WH)</a></div> <div class="gutter_text_right"><a name="230216">Description</a></div> <div class="Body"><a name="230311">Determines whether the cursor stays open on a commit.</a></div> <div class="gutter_text_right"><a name="230436">Valid Values</a></div> <div class="Body"><a name="230448">0 | 1</a></div> <div class="Body"><a name="265698">If set to 1 (Enabled), cursor behavior is Preserve, which keeps cursors open after a commit </a>or rollback (SQLGetInfo( ) returns SQL_CB_PRESERVE for SQL_COMMIT_CURSOR_BEHAVIOR).</div> <div class="Body"><a name="265699">If set to 0 (Disabled), cursor behavior is Delete, which closes all cursors open after a commit </a>or rollback (SQLGetInfo( ) returns SQL_CB_DELETE).</div> <div class="gutter_text_right"><a name="230131">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="230133">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="311534">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="311539">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="299855">XML Describe Type</a></div> <div class="gutter_text_right"><a name="230636">Attribute</a></div> <div class="Body_attr"><a name="230638">XMLDescribeType (XDT)</a></div> <div class="gutter_text_right"><a name="230820">Description</a></div> <div class="Body"><a name="656974">The SQL data type that is returned by SQLGetTypeInfo for the XML data type.</a></div> <div class="Body"><a name="230837">See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.08.html#540840', '');">â??Using the XML Data Typeâ??</a></span> for further information about the XML data type.</div> <div class="gutter_text_right"><a name="300019">Valid Values</a></div> <div class="Body"><a name="656978"> </a> -4 | -10</div> <div class="Body"><a name="656979">If set to -4 (SQL_LONGVARBINARY), the driver uses the description </a>SQL_LONGVARBINARY for columns that are defined as the XML data type. </div> <div class="Body"><a name="656980">If set to -10 (SQL_WLONGVARCHAR), the driver uses the description </a>SQL_WLONGVARCHAR for columns that are defined as the XML data type.</div> <div class="Body"><a name="602522">Default</a></div> <div class="Body" style="margin-top: 7.0pt;"><a name="230641">-10</a></div> <div class="gutter_text_right"><a name="311555">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'db2.09.04.html#109871', '');" name="311560">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