Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\greenplum.26.04.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Connection Option Descriptions</title> <link rel="StyleSheet" href="css/greenplum.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="greenplum.26.01.html#231981">20 The Greenplum Wire Protocol Driver </a> : Connection Option Descriptions</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="231981">Connection Option Descriptions</a></div> <div class="Body"><a name="406064">The following connection option descriptions are listed alphabetically by the GUI name that </a>appears on the driver Setup dialog box. The connection string attribute name, along with its short name, is listed immediately underneath the GUI name. </div> <div class="Body"><a name="406065">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="406066">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', 'greenplum.26.04.html#243214', '');" name="231990">Table 20-1</a></span> lists the connection string attributes supported by the Greenplum Wire Protocol driver.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 20-1. <a name="243214">Greenplum 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="261241">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="243220">Default</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#188071', '');" name="326662">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="326664">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', 'greenplum.26.04.html#196589', '');" name="326655">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="326657">1 (Enabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#183966', '');" name="326683">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="326685">0 (Disabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#195202', '');" name="326676">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="326678">0</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#195230', '');" name="326669">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="326671">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#108926', '');" name="326690">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="326692">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', 'greenplum.26.04.html#234101', '');" name="326697">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="326699">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', 'greenplum.26.04.html#189884', '');" name="326854">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="326856">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', 'greenplum.26.04.html#393102', '');" name="326847">EnableDescribeParam (EDP)</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="339228">1 (Enabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#143132', '');" name="390617">EnableKeysetCursors (EKC)</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="390619">0</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#146017', '');" name="326833">ExtendedColumnMetaData (ECMD)</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="326835">0 (Disabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#198884', '');" name="326826">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="326828">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#198915', '');" name="326819">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="326821">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#198944', '');" name="326812">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="326814">0 (Disabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#124908', '');" name="326805">FetchRefCursors (FRC)</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="326807">1 (Enabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#110619', '');" name="326798">FetchTSWTZasTimestamp (FTSWTZAT)</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="326800">0 (Disabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#110551', '');" name="326791">FetchTWFSasTime (FTWFSAT)</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="326793">0 (Disabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#197146', '');" name="326784">HostName (HOST)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="326786">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', 'greenplum.26.04.html#192329', '');" name="326770">IANAAppCodePage (IACP)</a></span> <br />UNIX ONLY</div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="326772">4 (ISO 8559-1 Latin-1)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#192375', '');" name="326763">InitializationString (IS)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="326765">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', 'greenplum.26.04.html#393968', '');" name="391918">KeysetCursorOptions (KCO)</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="391920">0 - RowID Columns</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', 'greenplum.26.04.html#186717', '');" name="326735">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="326737">0</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#223123', '');" name="326728">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="326730">0 (Disabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#222391', '');" name="326721">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="326723">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#183513', '');" name="326861">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="326863">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', 'greenplum.26.04.html#349343', '');" name="369768">MaxLongVarcharSize (MLVS)</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="369770">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', 'greenplum.26.04.html#121089', '');" name="326882">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="326884">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#349674', '');" name="369792">MaxVarcharSize (MVS)</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="369794">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', 'greenplum.26.04.html#121138', '');" name="326875">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="326877">0</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#209708', '');" name="326868">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="326870">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', 'greenplum.26.04.html#183940', '');" name="326889">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="326891">0 (Disabled)</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#199818', '');" name="326931">PortNumber (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="326933">5432</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', 'greenplum.26.04.html#199840', '');" name="326924">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="326926">0</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#199867', '');" name="326917">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="326919">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"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#185612', '');" name="326910">TransactionErrorBehavior (TEB)</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="326912">1 (Rollback Transaction)</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', 'greenplum.26.04.html#183537', '');" name="326938">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="326940">-10</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="243535">Alternate Servers</a></div> <div class="gutter_text_right"><a name="188069">Attribute</a></div> <div class="Body_attr"><a name="188071">AlternateServers (ASRV)</a></div> <div class="gutter_text_right"><a name="188072">Description</a></div> <div class="Body"><a name="406070">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="188077">Valid Values</a></div> <div class="syntax_first"><span style="font-size: 9.0pt;"><a name="212729">(</a></span>HostName=<span class="EquationVariables">hostvalue</span>:PortNumber=<span class="EquationVariables">portvalue</span>:Database<span class="EquationVariables">=databasevalue</span>[, . . .]<span style="font-size: 9.0pt;">)</span></div> <div class="Body"><a name="188078">You must specify the host name, port number, and database name of each alternate server.</a></div> <div class="gutter_text_right"><a name="188080">Example</a></div> <div class="Body"><a name="188081">The following Alternate Servers value defines two alternate database servers for connection </a>failover:</div> <div class="syntax_first"><a name="311237">AlternateServers=(HostName=GreenplumServer:PortNumber=5431:Database=Pgredb1, </a><br />HostName=255.201.11.24:PortNumber=5432:Database=Pgredb2)</div> <div class="gutter_text_right"><a name="188083">Default</a></div> <div class="Body"><a name="188084">None</a></div> <div class="gutter_text_right"><a name="188085">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#259734', '');" name="188094">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="196586">Application Using Threads</a></div> <div class="gutter_text_right"><a name="196587">Attribute</a></div> <div class="Body_attr"><a name="196589">ApplicationUsingThreads (AUT)</a></div> <div class="gutter_text_right"><a name="196590">Description</a></div> <div class="Body"><a name="406074">Determines whether the driver works with applications using multiple ODBC threads.</a></div> <div class="Body"><a name="196598">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.05.html#125858', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="196602">Valid Values</a></div> <div class="Body"><a name="406078">0 | 1</a></div> <div class="Body"><a name="406079">If set to 1 (Enabled), the driver works with single-threaded and multi-threaded applications.</a></div> <div class="Body"><a name="406080">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="196604">Default</a></div> <div class="Body"><a name="196606">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="196607">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="196616">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="183937">Connection Pooling</a></div> <div class="gutter_text_right"><a name="183938">Attribute</a></div> <div class="Body_attr"><a name="183940">Pooling (POOL)</a></div> <div class="gutter_text_right"><a name="232864">Description</a></div> <div class="Body"><a name="406084">Specifies whether to use the driverâ??s connection pooling.</a></div> <div class="Body"><a name="406085">NOTE: The application must be thread-enabled to use connection pooling.</a></div> <div class="Body"><a name="291628">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.05.html#125858', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="232869">Valid Values</a></div> <div class="Body"><a name="406089">0 | 1</a></div> <div class="Body"><a name="406090">If set to 1 (Enabled), the driver uses connection pooling. </a></div> <div class="Body"><a name="406091">If set to 0 (Disabled), the driver does not use connection pooling.</a></div> <div class="gutter_text_right"><a name="183948">Default</a></div> <div class="Body"><a name="183950">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="183951">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#231823', '');" name="193629">Pooling tab</a></span> </div> <div class="head_2_no_TOC"><a name="193631">Connection Reset</a></div> <div class="gutter_text_right"><a name="193632">Attribute</a></div> <div class="Body_attr"><a name="183966">ConnectionReset (CR)</a></div> <div class="gutter_text_right"><a name="232900">Description</a></div> <div class="Body"><a name="406095">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="291655">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.05.html#125858', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="232905">Valid Values</a></div> <div class="Body"><a name="406099">0 | 1</a></div> <div class="Body"><a name="406100">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="406101">If set to 0 (Disabled), the state of connections is not reset.</a></div> <div class="gutter_text_right"><a name="213931">Default</a></div> <div class="Body"><a name="213933">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="247024">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#231823', '');" name="247030">Pooling tab</a></span> </div> <div class="head_2_no_TOC"><a name="195199">Connection Retry Count</a></div> <div class="gutter_text_right"><a name="195200">Attribute</a></div> <div class="Body_attr"><a name="195202">ConnectionRetryCount (CRC)</a></div> <div class="gutter_text_right"><a name="232924">Description</a></div> <div class="Body"><a name="406105">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="406106">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="232930">Valid Values</a></div> <div class="Body"><a name="406110">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="406111">where </a><span class="EquationVariables">x</span> is a positive integer from 1 to 65535.</div> <div class="Body"><a name="406112">If set to 0, the driver does not try to connect after the initial unsuccessful attempt.</a></div> <div class="Body"><a name="406113">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="214131">Default</a></div> <div class="Body"><a name="214133">0</a></div> <div class="gutter_text_right"><a name="246585">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#259734', '');" name="246590">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="195227">Connection Retry Delay</a></div> <div class="gutter_text_right"><a name="195228">Attribute</a></div> <div class="Body_attr"><a name="195230">ConnectionRetryDelay (CRD)</a></div> <div class="gutter_text_right"><a name="232950">Description</a></div> <div class="Body"><a name="406117">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="406118">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="232955">Valid Values</a></div> <div class="Body"><a name="406122">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="406123">where </a><span class="EquationVariables">x</span> is a positive integer from 1 to 65535.</div> <div class="Body"><a name="406124">If set to 0, there is no delay between retries.</a></div> <div class="Body"><a name="406125">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="214209">Default</a></div> <div class="Body"><a name="214211">3</a></div> <div class="gutter_text_right"><a name="246602">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#259734', '');" name="246607">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="234098">Data Source Name</a></div> <div class="gutter_text_right"><a name="234099">Attribute</a></div> <div class="Body_attr"><a name="234101">DataSourceName (DSN)</a></div> <div class="gutter_text_right"><a name="234297">Description</a></div> <div class="Body"><a name="406129">The name of a data source in your Windows Registry or odbc.ini file.</a></div> <div class="gutter_text_right"><a name="234302">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="406133">string</a></span> </div> <div class="Body"><a name="406134">where </a><span class="EquationVariables">string</span> is the name of a data source.</div> <div class="gutter_text_right"><a name="234110">Default</a></div> <div class="Body"><a name="234112">None</a></div> <div class="gutter_text_right"><a name="234113">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#231375', '');" name="234118">General tab</a></span></div> <div class="head_2_no_TOC"><a name="108924">Database Name</a></div> <div class="gutter_text_right"><a name="108925">Attribute</a></div> <div class="Body_attr"><a name="108926">Database (DB)</a></div> <div class="gutter_text_right"><a name="160804">Description</a></div> <div class="Body"><a name="406138">The name of the database to which you want to connect.</a></div> <div class="gutter_text_right"><a name="160806">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="406142">database_name</a></span> </div> <div class="Body"><a name="406143">where </a><span class="EquationVariables">database_name</span> is the name of a valid database.</div> <div class="gutter_text_right"><a name="150930">Default</a></div> <div class="Body"><a name="150932">None</a></div> <div class="gutter_text_right"><a name="247100">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#231375', '');" name="247105">General tab</a></span></div> <div class="head_2_no_TOC"><a name="189881">Description</a></div> <div class="gutter_text_right"><a name="189882">Attribute</a></div> <div class="Body_attr"><a name="189884">Description (n/a)</a></div> <div class="gutter_text_right"><a name="234344">Description</a></div> <div class="Body"><a name="406147">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="234349">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="406151">string</a></span> </div> <div class="Body"><a name="406152">where </a><span class="EquationVariables">string</span> is a description of a data source.</div> <div class="gutter_text_right"><a name="234355">Default</a></div> <div class="Body"><a name="234356">None</a></div> <div class="gutter_text_right"><a name="247129">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#231375', '');" name="247134">General tab</a></span></div> <div class="head_2_no_TOC"><a name="110499">Enable Keyset Cursors</a></div> <div class="gutter_text_right"><a name="110500">Attribute</a></div> <div class="Body_attr"><a name="143132">EnableKeysetCursors (EKC)</a></div> <div class="gutter_text_right"><a name="160734">Description</a></div> <div class="Body"><a name="288908">Determines whether the driver emulates keyset cursors to provide scrollable keyset cursors </a>to an ODBC application. </div> <div class="gutter_text_right"><a name="234391">Valid Values</a></div> <div class="Body"><a name="234392">0 | 1</a></div> <div class="Body"><a name="393497">If set to 1 (Enabled), the driver emulates keyset cursors. </a></div> <div class="Body"><a name="234394">If set to 0 (Disabled), the driver does not emulate keyset cursors. If an application requests </a>a keyset cursor and this option is set to 0, the driver uses a static cursor and returns a message that a different value was used.</div> <div class="gutter_text_right"><a name="234395">Default</a></div> <div class="table_text"><a name="339201">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="246708">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="246713">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="393099">Enable SQLDescribeParam</a></div> <div class="gutter_text_right"><a name="393100">Attribute</a></div> <div class="Body_attr"><a name="393102">EnableDescribeParam (EDP)</a></div> <div class="gutter_text_right"><a name="393103">Description</a></div> <div class="Body"><a name="406436">Determines whether SQLDescribeParam returns the Datatype, ParameterSize, </a>DecimalDigits, and Nullable information for parameters in a prepared statement.</div> <div class="gutter_text_right"><a name="393108">Valid Values</a></div> <div class="Body"><a name="393110">0 | 1</a></div> <div class="Body"><a name="393112">If set to 1 (Enabled), SQLDescribeParam returns the Datatype, ParameterSize, </a>DecimalDigits, and Nullable information for parameters in a prepared statement.</div> <div class="Body"><a name="393113">If set to 0 (Disabled), the driver does not support SQLDescribeParam and returns the </a>message: <span class="Syntax">Driver does not support this function</span>.</div> <div class="gutter_text_right"><a name="393114">Default</a></div> <div class="table_text"><a name="393116">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="393117">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="393122">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="144369">Extended Column Metadata</a></div> <div class="gutter_text_right"><a name="145232">Attribute</a></div> <div class="Body_attr"><a name="146017">ExtendedColumnMetaData (ECMD)</a></div> <div class="gutter_text_right"><a name="336841">Description</a></div> <div class="Body"><a name="405930">Determines how the driver returns column metadata when using SQLDescribeCol and </a>SQLColAttribute.</div> <div class="gutter_text_right"><a name="336846">Valid Values</a></div> <div class="Body"><a name="406410">0 | 1</a></div> <div class="Body"><a name="406411">If set to 1 (Enabled), SQLDescribeCol returns the actual values for Data Type, Column Size, </a>Decimal Digits, and Nullable. SQLColAttribute returns the actual values for:</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="406412">SQL_DESC_CATALOG_NAME: </a><span class="EquationVariables">catalog_name</span></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="406413">SQL_DESC_TABLE_NAME: </a><span class="EquationVariables">table_name</span></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="406414">SQL_DESC_BASE_COLUMN_NAME: </a><span class="EquationVariables">base_column_name</span></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="406415">SQL_DESC_LOCAL_TYPE_NAME: </a><span class="EquationVariables">local_type_name</span></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="406416">SQL_DESC_NULLABLE: </a><span class="EquationVariables">nullable</span></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="406417">SQL_DESC_AUTO_UNIQUE_VALUE: </a><span class="EquationVariables">auto_unique_value</span></div> </td> </tr> </table> </div> <div class="Body"><a name="406418">If set to 0 (Disabled), SQLDescribeCol returns the Data Type, Column Size, and Decimal </a>Digits for the column. The value SQL_NULLABLE_UNKNOWN is returned for Nullable. SQLColAttribute returns the following attribute values:</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="406419">SQL_DESC_CATALOG_NAME: empty 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="406420">SQL_DESC_TABLE_NAME: empty 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="406421">SQL_DESC_BASE_COLUMN_NAME: empty 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="406422">SQL_DESC_LOCAL_TYPE_NAME: empty 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="406423">SQL_DESC_NULLABLE: SQL_NULLABLE_UNKNOWN</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="406424">SQL_DESC_AUTO_UNIQUE_VALUE: SQL_FALSE</a></div> </td> </tr> </table> </div> <div class="gutter_text_right"><a name="151907">Default</a></div> <div class="Body"><a name="151909">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="246725">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="246730">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="198881">Failover Granularity</a></div> <div class="gutter_text_right"><a name="198882">Attribute</a></div> <div class="Body_attr"><a name="198884">FailoverGranularity (FG)</a></div> <div class="gutter_text_right"><a name="234810">Description</a></div> <div class="Body"><a name="406161">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="406162">This option applies only when Failover Mode is set to 1 (Extended Connection) or 2 </a>(Select). </div> <div class="Body"><a name="406163">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="234817">Valid Values</a></div> <div class="Body"><a name="406167">0 | 1 | 2 | 3</a></div> <div class="Body"><a name="406168">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="406169">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="406170">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="406171">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="217298">Default</a></div> <div class="Body"><a name="217300">0 (Non-Atomic)</a></div> <div class="gutter_text_right"><a name="246631">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#259734', '');" name="246636">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="198912">Failover Mode</a></div> <div class="gutter_text_right"><a name="198913">Attribute</a></div> <div class="Body_attr"><a name="198915">FailoverMode (FM)</a></div> <div class="gutter_text_right"><a name="235283">Description</a></div> <div class="Body"><a name="406175">Specifies the type of failover method the driver uses. </a></div> <div class="Body"><a name="406176">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="235289">Valid Values</a></div> <div class="Body"><a name="406180">0 | 1 | 2</a></div> <div class="Body"><a name="406181">If set to 0 (Connection), the driver provides failover protection for new connections only. </a></div> <div class="Body"><a name="406182">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="406183">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="217555">Default</a></div> <div class="Body"><a name="217557">0 (Connection)</a></div> <div class="gutter_text_right"><a name="246652">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#259734', '');" name="246657">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="198941">Failover Preconnect</a></div> <div class="gutter_text_right"><a name="198942">Attribute</a></div> <div class="Body_attr"><a name="198944">FailoverPreconnect (FP)</a></div> <div class="gutter_text_right"><a name="235326">Description</a></div> <div class="Body"><a name="406187">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="406188">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="406189">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="235333">Valid Values</a></div> <div class="Body"><a name="406193">0 | 1</a></div> <div class="Body"><a name="406194">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="406195">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="198955">Default</a></div> <div class="Body"><a name="198957">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="246667">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#259734', '');" name="246672">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="124905">Fetch RefCursors</a></div> <div class="gutter_text_right"><a name="124906">Attribute</a></div> <div class="Body_attr"><a name="124908">FetchRefCursors (FRC)</a></div> <div class="gutter_text_right"><a name="168855">Description</a></div> <div class="Body"><a name="169017">Determines whether the driver returns refcursors from stored procedures as results sets.</a></div> <div class="gutter_text_right"><a name="168857">Valid Values</a></div> <div class="Body"><a name="160659">0 | 1</a></div> <div class="Body"><a name="217822">If set to 1 (Enabled), the driver returns refcursors from stored procedures as result sets. The </a>driver fetches all the data from the refcursor and then closes the refcursor. If a stored procedure returns multiple refcursors, the driver generates multiple result sets, one for each refcursor returned.</div> <div class="Body"><a name="217823">If set to 0 (Disabled), the driver returns the cursor name for refcursors. The application must </a>fetch the actual data from the refcursor using the cursor name and must close the cursor before additional processing can be done on the statement. The application must close the cursor regardless of whether it actually fetches data from the cursor.</div> <div class="gutter_text_right"><a name="151937">Default</a></div> <div class="Body"><a name="151939">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="246756">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="246761">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="110534">Fetch TSWTZ as Timestamp</a></div> <div class="gutter_text_right"><a name="110535">Attribute</a></div> <div class="Body_attr"><a name="110619">FetchTSWTZasTimestamp (FTSWTZAT)</a></div> <div class="gutter_text_right"><a name="160575">Description</a></div> <div class="Body"><a name="406199">Determines whether the driver returns column values with the timestamp with time zone </a>data type as the ODBC data type SQL_TYPE_TIMESTAMP or SQL_VARCHAR.</div> <div class="gutter_text_right"><a name="245492">Valid Values</a></div> <div class="Body"><a name="406203">0 | 1</a></div> <div class="Body"><a name="406204">If set to 1 (Enabled), the driver returns column values with the timestamp with time zone </a>data type as the ODBC type SQL_TYPE_TIMESTAMP. The time zone information in the fetched value is truncated. Use this value if your application needs to process values the same way as TIMESTAMP columns.</div> <div class="Body"><a name="406205">If set to 0 (Disabled), the driver returns column values with the timestamp with time zone </a>data type as the ODBC data type SQL_VARCHAR. Use this value if your application requires the time zone information in the fetched value.</div> <div class="gutter_text_right"><a name="151991">Default</a></div> <div class="Body"><a name="151993">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="246779">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="246784">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="169116">Fetch TWFS as Time</a></div> <div class="gutter_text_right"><a name="110550">Attribute</a></div> <div class="Body_attr"><a name="110551">FetchTWFSasTime (FTWFSAT)</a></div> <div class="gutter_text_right"><a name="160379">Description</a></div> <div class="Body"><a name="406209">Determines whether the driver returns column values with the time data type as the ODBC </a>data type SQL_TYPE_TIME or SQL_TYPE_TIMESTAMP.</div> <div class="gutter_text_right"><a name="246319">Valid Values</a></div> <div class="Body"><a name="406213">0 | 1</a></div> <div class="Body"><a name="406214">If set to 1 (Enabled), the driver returns column values with the time data type as the ODBC </a>data type SQL_TYPE_TIME. The fractional seconds portion of the value is truncated.</div> <div class="Body"><a name="406215">If set to 0 (Disabled), the driver returns column values with the time data type as the ODBC </a>data type SQL_TYPE_TIMESTAMP. The fractional seconds portion of the value is preserved. Time columns are not searchable when they are described and fetched as timestamp</div> <div class="Body"><a name="406216">NOTE: When returning time with fractional seconds data as SQL_TYPE_TIMESTAMP, the </a>Year, Month and Day parts of the timestamp must be set to zero.</div> <div class="gutter_text_right"><a name="152172">Default</a></div> <div class="Body"><a name="152174">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="246802">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="246807">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="197143">Host Name</a></div> <div class="gutter_text_right"><a name="197144">Attribute</a></div> <div class="Body_attr"><a name="197146">HostName (HOST)</a></div> <div class="gutter_text_right"><a name="197147">Description</a></div> <div class="Body"><a name="406220">The name or the IP address of the server to which you want to connect.</a></div> <div class="gutter_text_right"><a name="197153">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="406224">server_name</a></span> | <span class="EquationVariables">IP_address</span></div> <div class="Body"><a name="406225">where:</a></div> <div class="Body"><span class="EquationVariables"><a name="406226">server_name</a></span> is the name of the server to which you want to connect.</div> <div class="Body"><span class="EquationVariables"><a name="406227">IP_address</a></span> is the IP address of the server to which you want to connect.</div> <div class="Body"><a name="315683">The IP address must be in IPv4 format.</a></div> <div class="gutter_text_right"><a name="235362">Default</a></div> <div class="Body"><a name="197164">None</a></div> <div class="gutter_text_right"><a name="247146">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#231375', '');" name="247151">General tab</a></span></div> <div class="head_2_no_TOC"><a name="385388">IANAAppCodePage</a></div> <div class="gutter_text_right"><a name="385389">Attribute</a></div> <div class="Body_attr"><a name="192329">IANAAppCodePage (IACP)</a></div> <div class="gutter_text_right"><a name="235501">Description</a></div> <div class="Body"><a name="406231">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="406239">The driver uses the specified IANA code page to convert "W" (wide) functions to ANSI.</a></div> <div class="Body"><a name="406240">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="406241">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="406242">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="406243">In the ODBC section of the system information file (odbc.ini)</a></div> </td> </tr> </table> </div> <div class="Body"><a name="406244">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="235520">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="406248">IANA_code_page</a></span> </div> <div class="Body"><a name="406250">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="192358">Default</a></div> <div class="Body"><a name="221323">4 (ISO 8559-1 Latin-1)</a></div> <div class="gutter_text_right"><a name="246821">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="246826">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="192372">Initialization String</a></div> <div class="gutter_text_right"><a name="192373">Attribute</a></div> <div class="Body_attr"><a name="192375">InitializationString (IS)</a></div> <div class="gutter_text_right"><a name="192376">Description</a></div> <div class="Body"><a name="406257">A SQL command that is issued immediately after connecting to the database to manage </a>session settings. </div> <div class="Body"><a name="406258">NOTE: If the statement fails to execute, the connection fails and the driver reports the error </a>returned from the server.</div> <div class="gutter_text_right"><a name="406262">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="406263">SQL_command</a></span></div> <div class="Body"><a name="406264">where </a><span class="EquationVariables">SQL_command</span> is a valid SQL command that is supported by the database.</div> <div class="gutter_text_right"><a name="317399">Example</a></div> <div class="Body"><a name="268861">To set the date format on every connection, specify:</a></div> <div class="syntax_first"><a name="268862">Set DateStyle='ISO, MDY'</a></div> <div class="gutter_text_right"><a name="268838">Default</a></div> <div class="Body"><a name="268718">None</a></div> <div class="gutter_text_right"><a name="246850">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="246855">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="393965">Keyset Cursor Options</a></div> <div class="gutter_text_right"><a name="393966">Attribute</a></div> <div class="Body_attr"><a name="393968">KeysetCursorOptions (KCO) </a></div> <div class="gutter_text_right"><a name="393969">Description</a></div> <div class="Body"><a name="394056">Determines which columns are used to comprise the keyset that the driver uses to create </a>the initial keyset on which cursor operations are based. Greenplum does not offer a true row identifier column; the driver instead uses two hidden system columns provided by the Greenplum database, ctid and gp_segment_id. Because the database might reassign these IDs following a Vacuum operation, the driver can be configured to also include other columns to help ensure that data integrity is maintained.</div> <div class="Body"><a name="397204">NOTE: This option has no effect unless the </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.04.html#110499', '');">Enable Keyset Cursors</a></span> connection option is enabled.</div> <div class="gutter_text_right"><a name="393971">Valid Values</a></div> <div class="Body"><a name="393973">0 | 1</a></div> <div class="Body"><a name="394189">If set to 1 - RowID and Searchable Columns (Enabled), the driver uses a combination of </a>every non-LOB column in the Select list and the ctid and gp_segment_id hidden columns to build the keyset. By adding other Select list fields to the keyset, the driver is able to indicate the row cannot be found if the IDs change following a Vacuum operation. </div> <div class="Body"><a name="394152">If set to 0 - RowID Columns (Disabled), the driver uses the ctid and gp_segment_id hidden </a>system columns.</div> <div class="gutter_text_right"><a name="393977">Default</a></div> <div class="table_text"><a name="393979">0</a></div> <div class="gutter_text_right"><a name="393980">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="393985">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="186714">Load Balance Timeout</a></div> <div class="gutter_text_right"><a name="186715">Attribute</a></div> <div class="Body_attr"><a name="186717">LoadBalanceTimeout (LBT)</a></div> <div class="gutter_text_right"><a name="186718">Description</a></div> <div class="Body"><a name="406268">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="406269">NOTE: The Min Pool Size option may cause some connections to ignore this value.</a></div> <div class="Body"><a name="291777">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.05.html#125858', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="236403">Valid Values</a></div> <div class="Body"><a name="406273">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="406274">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="406275">If set to 0, inactive connections are kept open.</a></div> <div class="Body"><a name="406276">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="186725">Default</a></div> <div class="Body"><a name="186727">0</a></div> <div class="gutter_text_right"><a name="247046">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#231823', '');" name="247052">P</a></span><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#231823', '');">ooling tab</a></span> </div> <div class="head_2_no_TOC"><a name="223120">Load Balancing</a></div> <div class="gutter_text_right"><a name="223121">Attribute</a></div> <div class="Body_attr"><a name="223123">LoadBalancing (LB)</a></div> <div class="gutter_text_right"><a name="223124">Description</a></div> <div class="Body"><a name="406280">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="236475">Valid Values</a></div> <div class="Body"><a name="406284">0 | 1</a></div> <div class="Body"><a name="406285">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="406286">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="406287">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="223133">Default</a></div> <div class="Body"><a name="223135">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="246682">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#259734', '');" name="246687">Failover tab</a></span></div> <div class="head_2_no_TOC"><a name="223143">Login Timeout</a></div> <div class="gutter_text_right"><a name="222389">Attribute</a></div> <div class="Body_attr"><a name="222391">LoginTimeout (LT)</a></div> <div class="gutter_text_right"><a name="222392">Description</a></div> <div class="Body"><a name="406291">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="236490">Valid Values</a></div> <div class="Body"><a name="406295">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="406296">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="406297">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="406298">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="406299">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="222403">Default</a></div> <div class="Body"><a name="222405">15</a></div> <div class="gutter_text_right"><a name="246879">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="377990">Advanced tab</a></span> </div> <div class="Body"><a name="405916">Specifies how often, in seconds, the driver checks the maintenance thread. A single </a>maintenance thread is used to enforce minimum and maximum pool sizes in the connection pool. This option is not used as a runtime connection option, but does appear in the ODBC.INI section of the Registry and in the odbc.ini file.</div> <div class="head_2_no_TOC"><a name="377994">Max Long Varchar Size</a></div> <div class="gutter_text_right"><a name="377995">Attribute</a></div> <div class="Body_attr"><a name="349343">MaxLongVarcharSize (MLVS)</a></div> <div class="gutter_text_right"><a name="349344">Description</a></div> <div class="Body"><a name="352052">Specifies the maximum size of columns of type SQL_LONGVARCHAR that the driver </a>describes through result set descriptions and catalog functions. </div> <div class="gutter_text_right"><a name="352053">Valid Values</a> </div> <div class="Body"><a name="352054">A positive integer from 255 to </a><span class="Emphasis">x</span> </div> <div class="Body"><a name="352055">where </a><span class="Emphasis">x</span> is maximum size of the SQL_LONGVARCHAR data type. </div> <div class="gutter_text_right"><a name="352056">Default</a></div> <div class="Body"><a name="352057">None. The actual size of the columns from the database is persisted to the application.</a></div> <div class="gutter_text_right"><a name="349570">GUI Tab</a></div> <div class="Body"><a name="349576">Advanced</a></div> <div class="head_2_no_TOC"><a name="121087">Max Pool Size</a></div> <div class="gutter_text_right"><a name="121088">Attribute</a></div> <div class="Body_attr"><a name="121089">MaxPoolSize (MXPS)</a></div> <div class="gutter_text_right"><a name="236561">Description</a></div> <div class="Body"><a name="406303">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="291787">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.05.html#125858', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="236566">Valid Values</a></div> <div class="Body"><a name="406307">An integer from 1 to 65535</a></div> <div class="Body"><a name="406308">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="236553">Default</a></div> <div class="Body"><a name="154160">100</a></div> <div class="gutter_text_right"><a name="247068">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#231823', '');" name="247074">P</a></span><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#231823', '');">ooling tab</a></span> </div> <div class="head_2_no_TOC"><a name="349672">Max Varchar Size</a></div> <div class="gutter_text_right"><a name="349673">Attribute</a></div> <div class="Body_attr"><a name="349674">MaxVarcharSize (MVS)</a></div> <div class="gutter_text_right"><a name="349675">Description</a></div> <div class="Body"><a name="349676">Specifies the maximum size of columns of type SQL_VARCHAR that the driver describes </a>through result set descriptions and catalog functions. </div> <div class="gutter_text_right"><a name="349677">Valid Values</a> </div> <div class="Body"><a name="349678">A positive integer from 255 to </a><span class="Emphasis">x</span> </div> <div class="Body"><a name="351737">where </a><span class="Emphasis">x</span> is maximum size of the SQL_VARCHAR data type. </div> <div class="gutter_text_right"><a name="349679">Default</a></div> <div class="Body"><a name="349680">None. The actual size of the columns from the database is persisted to the application.</a></div> <div class="gutter_text_right"><a name="349681">GUI Tab</a></div> <div class="Body"><a name="349682">Advanced </a></div> <div class="head_2_no_TOC"><a name="121136">Min Pool Size</a></div> <div class="gutter_text_right"><a name="121137">Attribute</a></div> <div class="Body_attr"><a name="121138">MinPoolSize (MNPS)</a></div> <div class="gutter_text_right"><a name="159326">Description</a></div> <div class="Body"><a name="406312">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="291794">This connection option can affect performance. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.05.html#125858', '');">â??Performance Considerationsâ??</a></span> for details.</div> <div class="gutter_text_right"><a name="236580">Valid Values</a></div> <div class="Body"><a name="406316">0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="406317">where </a><span class="EquationVariables">x</span> is an integer from 1 to 65535.</div> <div class="Body"><a name="406318">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="406319">If set to 0, no connections are opened in addition to the current existing connection.</a></div> <div class="gutter_text_right"><a name="154191">Default</a></div> <div class="Body"><a name="154193">0</a></div> <div class="gutter_text_right"><a name="247078">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#231823', '');" name="247084">P</a></span><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#231823', '');">ooling tab</a></span> </div> <div class="head_2_no_TOC"><a name="209705">Password</a></div> <div class="gutter_text_right"><a name="209706">Attribute</a></div> <div class="Body_attr"><a name="209708">Password (PWD)</a></div> <div class="gutter_text_right"><a name="209709">Description</a></div> <div class="Body"><a name="406323">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="236809">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="406327">pwd</a></span> </div> <div class="Body"><a name="406328">where </a><span class="EquationVariables">pwd</span> is a valid password.</div> <div class="gutter_text_right"><a name="294274">Default</a></div> <div class="Body"><a name="294276">None</a></div> <div class="gutter_text_right"><a name="294330">GUI Tab</a></div> <div class="Body"><a name="294399">n/a</a></div> <div class="head_2_no_TOC"><a name="294279">Port Number</a></div> <div class="gutter_text_right"><a name="199816">Attribute</a></div> <div class="Body_attr"><a name="199818">PortNumber (PORT)</a></div> <div class="gutter_text_right"><a name="199819">Description</a></div> <div class="Body"><a name="406332">The port number of the server listener.</a></div> <div class="gutter_text_right"><a name="236824">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="406336">port_name</a></span> </div> <div class="Body"><a name="406337">where the </a><span class="EquationVariables">port_name</span> is the port number of the server listener. Check with your database administrator for the correct number.</div> <div class="gutter_text_right"><a name="199823">Default</a></div> <div class="Body"><a name="199825">5432</a></div> <div class="gutter_text_right"><a name="247180">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#231375', '');" name="247185">General tab</a></span></div> <div class="head_2_no_TOC"><a name="199837">Query Timeout</a></div> <div class="gutter_text_right"><a name="199838">Attribute</a></div> <div class="Body_attr"><a name="199840">QueryTimeout (QT)</a></div> <div class="gutter_text_right"><a name="199841">Description</a></div> <div class="Body"><a name="406341">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="gutter_text_right"><a name="236932">Valid Values</a></div> <div class="Body"><a name="406345">-1 | 0 | </a><span class="EquationVariables">x</span></div> <div class="Body"><a name="406346">where </a><span class="EquationVariables">x</span> is a positive integer that specifies a number of seconds.</div> <div class="Body"><a name="406347">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="406348">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="406349">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="202192">Default</a></div> <div class="Body"><a name="199852">0</a></div> <div class="gutter_text_right"><a name="246888">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="246893">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="199864">Report Codepage Conversion Errors</a></div> <div class="gutter_text_right"><a name="199865">Attribute</a></div> <div class="Body_attr"><a name="199867">ReportCodepageConversionErrors (RCCE)</a></div> <div class="gutter_text_right"><a name="199868">Description</a></div> <div class="Body"><a name="406353">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="406354">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="236967">Valid Values</a></div> <div class="Body"><a name="406358">0 | 1 | 2</a></div> <div class="Body"><a name="406359">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="406360">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="406361">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="199879">Default</a></div> <div class="Body"><a name="199881">0 (Ignore Errors)</a></div> <div class="gutter_text_right"><a name="246897">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="246902">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="185609">Transaction Error Behavior</a></div> <div class="gutter_text_right"><a name="185610">Attribute</a></div> <div class="Body_attr"><a name="185612">TransactionErrorBehavior (TEB)</a></div> <div class="gutter_text_right"><a name="185613">Description</a></div> <div class="Body"><a name="185614">Determines how the driver handles errors that occur within a transaction. When an error </a>occurs in a transaction, the Greenplum server does not allow any operations on the connection except for rolling back the transaction.</div> <div class="gutter_text_right"><a name="185618">Valid Values</a></div> <div class="Body"><a name="185619">0 | 1</a></div> <div class="Body"><a name="223909">If set to 0 (None), the driver does not roll back the transaction when an error occurs. The </a>application must handle the error and roll back the transaction. Any operation on the statement other than a rollback results in an error.</div> <div class="Body"><a name="223910">If set to 1 (Rollback Transaction), the driver rolls back the transaction when an error occurs. </a>In addition to the original error message, the driver posts an error message indicating that the transaction has been rolled back.</div> <div class="gutter_text_right"><a name="185620">Default</a></div> <div class="Body"><a name="185622">1 (Rollback Transaction)</a></div> <div class="gutter_text_right"><a name="246906">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="246911">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="183510">User Name</a></div> <div class="gutter_text_right"><a name="183511">Attribute</a></div> <div class="Body_attr"><a name="183513">LogonID (UID)</a></div> <div class="gutter_text_right"><a name="183514">Description</a></div> <div class="Body"><a name="406365">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="237035">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="406369">userid</a></span></div> <div class="Body"><a name="406370">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="183521">Default</a></div> <div class="Body"><a name="183522">None</a></div> <div class="gutter_text_right"><a name="246968">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="246973">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="183534">XML Describe Type</a></div> <div class="gutter_text_right"><a name="183535">Attribute</a></div> <div class="Body_attr"><a name="183537">XMLDescribeType (XDT)</a></div> <div class="gutter_text_right"><a name="183538">Description</a></div> <div class="Body"><a name="406374">The SQL data type that is returned by SQLGetTypeInfo for the XML data type.</a></div> <div class="Body"><a name="237068">See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.06.html#97183', '');">â??Using the XML Data Typeâ??</a></span> for further information about the XML data type.</div> <div class="gutter_text_right"><a name="237069">Valid Values</a></div> <div class="Body"><a name="406378"> </a> -4 | -10</div> <div class="Body"><a name="406379">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="406380">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="346148">Default</a></div> <div class="Body"><a name="203489">-10</a></div> <div class="gutter_text_right"><a name="246993">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'greenplum.26.03.html#333323', '');" name="246998">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