Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\teradata.29.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/teradata.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="teradata.29.01.html#168572">23 The Driver for the Teradata Database</a> : Connection Option Descriptions</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="168572">Connection Option Descriptions</a></div> <div class="Body"><a name="179143">The following connection option descriptions are listed alphabetically by the GUI name that </a>appears on the driver Setup dialog box. The connection string attribute name, along with its short name, is listed immediately underneath the GUI name. For example:</div> <div class="hanging_label_head"><a name="179144">Application Using Threads</a></div> <div class="gutter_text_right"><a name="179145">Attribute</a></div> <div class="Body"><a name="179147">ApplicationUsingThreads (AUT)</a></div> <div class="Body"><a name="179148">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="179149">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', 'teradata.29.04.html#168585', '');" name="168576">Table 23-1</a></span> lists the connection string attributes supported by the driver.</div> <table class="Format_E" cellspacing="0" summary=""> <caption> <div class="table_title_wide">Table 23-1. <a name="168585">Teradata 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="168589">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="168591">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', 'teradata.29.04.html#106865', '');" name="168596">AccountString (AS)</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="168598">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', 'teradata.29.04.html#107373', '');" name="168603">AuthenticationDomain (AD)</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="168605">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', 'teradata.29.04.html#106883', '');" name="168610">AuthenticationPassword (AP)</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="168612">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', 'teradata.29.04.html#106901', '');" name="168617">AuthenticationUserId (AUI)</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="168619">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', 'teradata.29.04.html#107486', '');" name="168624">CharacterSet (CS)</a></span></div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="168626">ASCII</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', 'teradata.29.04.html#106993', '');" name="168631">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="168633">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', 'teradata.29.04.html#128714', '');" name="168638">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="168640">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', 'teradata.29.04.html#106964', '');" name="168645">DBCName (DBCN)</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="168647">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', 'teradata.29.04.html#106943', '');" name="168652">DBCName List</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="168654">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', 'teradata.29.04.html#107036', '');" name="168659">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="168661">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', 'teradata.29.04.html#107061', '');" name="168666">EnableDataEncryption (EDE)</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="168668">No (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', 'teradata.29.04.html#107082', '');" name="168673">EnableExtendedStmtInfo (EESI)</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="168675">No (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', 'teradata.29.04.html#107102', '');" name="168680">EnableLOBs (EL)</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="168682">Yes (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', 'teradata.29.04.html#107127', '');" name="168687">EnableReconnect (ER)</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="168689">No (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', 'teradata.29.04.html#107150', '');" name="168694">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="168696">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', 'teradata.29.04.html#107193', '');" name="168701">IntegratedSecurity (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="168703">No (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', 'teradata.29.04.html#107213', '');" name="168708">LoginTimeout (LTO)</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="168710">20</a></div> </td> </tr> <tr style="vertical-align: top;"> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.04.html#107233', '');" name="168715">MapCallEscapeToExec (MCETE)</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="168717">No (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', 'teradata.29.04.html#107253', '');" name="168722">MaxRespSize (MRS)</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="168724">8192</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', 'teradata.29.04.html#107271', '');" name="168729">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="168731">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', 'teradata.29.04.html#107290', '');" name="168736">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="168738">1025</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', 'teradata.29.04.html#107315', '');" name="168743">PrintOption (PO)</a></span> </div> </td> <td style="border-bottom-color: Black; border-bottom-style: solid; border-bottom-width: thin; border-left-color: Black; border-left-style: solid; border-left-width: thin; border-right-color: Black; border-right-style: solid; border-right-width: thin; border-top-color: Black; border-top-style: solid; border-top-width: thin; padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="168745">N (No)</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', 'teradata.29.04.html#107335', '');" name="168750">ProcedureWithSPLSource (PWSS)</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="168752">Y (Yes)</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', 'teradata.29.04.html#146717', '');" name="168757">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="168759">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', 'teradata.29.04.html#107419', '');" name="168764">SecurityMechanism (SECM)</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="168766">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', 'teradata.29.04.html#107467', '');" name="168771">SecurityParameter (SP)</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="168773">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', 'teradata.29.04.html#107505', '');" name="168778">ShowSelectableTables (SST)</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="168780">Yes (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', 'teradata.29.04.html#107355', '');" name="168785">TDProfile (TDP)</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="168787">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', 'teradata.29.04.html#107018', '');" name="168792">TDRole (TDR)</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="168794">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', 'teradata.29.04.html#107524', '');" name="168799">TDUserName (TDUN)</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="168801">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', 'teradata.29.04.html#107542', '');" name="168806">UserID (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="168808">None</a></div> </td> </tr> </table> <div class="head_2_no_TOC"><a name="120221">Account String</a></div> <div class="gutter_text_right"><a name="120222">Attribute</a></div> <div class="Body_attr"><a name="106865">AccountString (AS)</a></div> <div class="gutter_text_right"><a name="106866">Description</a></div> <div class="Body"><a name="106867">An account string. For a complete description of account strings, refer to the </a><span class="Emphasis">Teradata </span><span class="Emphasis">Database Administration Guide</span>.</div> <div class="gutter_text_right"><a name="106868">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="106869">string</a></span></div> <div class="Body"><a name="106870">where </a><span class="EquationVariables">string</span> is an account string.</div> <div class="gutter_text_right"><a name="106871">Default</a></div> <div class="Body"><a name="106872">None</a></div> <div class="gutter_text_right"><a name="113419">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106316', '');" name="113424">General tab</a></span></div> <div class="head_2_no_TOC"><a name="113425">Authentication Password</a></div> <div class="gutter_text_right"><a name="106880">Attribute</a></div> <div class="Body_attr"><a name="106883">AuthenticationPassword (AP)</a></div> <div class="gutter_text_right"><a name="106884">Description</a></div> <div class="Body"><a name="106885">The password for the Kerberos, LDAP, NTLM, and TD authentication mechanisms. The </a>Authentication Password option 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="106886">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="106887">pwd</a></span></div> <div class="Body"><a name="106888">where </a><span class="EquationVariables">pwd</span> is a valid password.</div> <div class="gutter_text_right"><a name="106889">Default</a></div> <div class="Body"><a name="106890">None</a></div> <div class="gutter_text_right"><a name="116202">GUI Tab</a></div> <div class="Body"><a name="116206">n/a</a></div> <div class="head_2_no_TOC"><a name="116215">Authentication UserID</a></div> <div class="gutter_text_right"><a name="106899">Attribute</a></div> <div class="Body_attr"><a name="106901">AuthenticationUserId (AUI)</a></div> <div class="gutter_text_right"><a name="106902">Description</a></div> <div class="Body"><a name="106903">The user ID for the Kerberos, LDAP, NTLM, and TD authentication mechanisms.</a></div> <div class="gutter_text_right"><a name="106904">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="106905">userid</a></span></div> <div class="Body"><a name="106906">where </a><span class="EquationVariables">userid</span> is a valid user ID.</div> <div class="gutter_text_right"><a name="106907">Default</a></div> <div class="Body"><a name="106908">None</a></div> <div class="gutter_text_right"><a name="106909">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106316', '');" name="106914">General tab</a></span></div> <div class="head_2_no_TOC"><a name="106943">DBCName List</a></div> <div class="gutter_text_right"><a name="106944">Attribute</a></div> <div class="Body_attr"><a name="106945">n/a</a></div> <div class="gutter_text_right"><a name="106946">Description</a></div> <div class="Body"><a name="106947">A list of IP addresses or aliases to appear in the drop-down list of the Logon dialog box (see </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106583', '');">â??Using a Logon Dialog Boxâ??</a></span> for a description). The DBCName List option is not used as a runtime connection attribute.</div> <div class="gutter_text_right"><a name="106951">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="106952">ip_address | alias </a></span>[,<span class="EquationVariables">ip_address | alias</span>][...]</div> <div class="Body"><a name="106953">where </a></div> <div class="Body"><span class="EquationVariables"><a name="106954">ip_address</a></span> is an IP address to appear in the drop-down list of the Logon dialog box.</div> <div class="Body"><span class="EquationVariables"><a name="106955">alias</a></span> is an alias to appear in the drop-down list of the Logon dialog box.</div> <div class="Body"><a name="106956">Separate multiple IP</a> addresses or aliases with commas. The same restrictions apply as described for the DBCName or Alias option.</div> <div class="gutter_text_right"><a name="106957">Default</a></div> <div class="Body"><a name="106958">None</a></div> <div class="gutter_text_right"><a name="116235">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106316', '');" name="121488">General tab</a></span> </div> <div class="head_2_no_TOC"><a name="106961">DBCName or Alias </a></div> <div class="gutter_text_right"><a name="106962">Attribute</a></div> <div class="Body_attr"><a name="106964">DBCName (DBCN)</a></div> <div class="gutter_text_right"><a name="106965">Description</a></div> <div class="Body"><a name="106966">The IP address or alias of the Teradata server. </a></div> <div class="gutter_text_right"><a name="106967">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="106968">IP_address</a></span> | <span class="EquationVariables">alias</span></div> <div class="Body"><a name="106969">where </a></div> <div class="Body"><span class="EquationVariables"><a name="106970">IP_address</a></span> is the IP address of the Teradata server. </div> <div class="Body"><span class="EquationVariables"><a name="106971">alias</a></span> is the alias of the Teradata server.</div> <div class="Body"><a name="106972">If set to </a><span class="EquationVariables">IP_address</span>, the time the driver waits for connections to be established is faster. The disadvantage is that if the server designated by that IP address is unavailable, the connection fails and the driver does not attempt to fail over to another IP address.</div> <div class="Body"><a name="106973">If set to </a><span class="EquationVariables">alias</span>, the time the driver waits for connections to be established is slower because the driver must search a local hosts file to resolve the alias to an IP address. The advantage is that the driver fails over the connection to an alternate IP address if the first address fails.</div> <div class="Body"><a name="106974">To use aliases, a local hosts file that maps aliases to IP</a> addresses is required. Aliases cannot be more than eight characters. In the hosts file, you must specify the aliases and map each of them to an IP address in the order that you want the driver to attempt the connections. For example:</div> <div class="syntax_first"><a name="106975">167.56.78.1 (NCR5100COP1)</a></div> <div class="syntax"><a name="106976">167.56.78.2 (NCR5100COP2)</a></div> <div class="syntax"><a name="106977">167.56.78.3 (NCR5100COP3)</a></div> <div class="Body"><a name="106978">where </a><span class="Syntax">NCR5100</span> is an alias and <span class="Syntax">COP</span><span class="EquationVariables">n</span> (where <span class="EquationVariables">n</span> = 1, 2, 3, ..., 128) is a suffix that sets the order of failover connection attempts. The eight-character limit on the alias does not include the suffix. You can enter a maximum of 128 COP (communications processor) entries per host.</div> <div class="Body"><a name="106979">NOTE: Although you must add a COP suffix to the alias in the hosts file, do </a><span class="Emphasis">not</span> specify the suffix when entering the alias in the DBCName or Alias field of the Setup dialog box. Only specify the alias.</div> <div class="gutter_text_right"><a name="106980">Default</a></div> <div class="Body"><a name="106981">None</a></div> <div class="gutter_text_right"><a name="106982">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106316', '');" name="106987">General tab</a></span> </div> <div class="head_2_no_TOC"><a name="106990">Default Database</a></div> <div class="gutter_text_right"><a name="106991">Attribute</a></div> <div class="Body_attr"><a name="106993">Database (DB)</a></div> <div class="gutter_text_right"><a name="106994">Description</a></div> <div class="Body"><a name="179162">The name of the database to which you want to connect.</a></div> <div class="gutter_text_right"><a name="169069">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="179166">database_directory</a></span></div> <div class="Body"><a name="179167">where </a><span class="EquationVariables">database_directory</span> is the full path name of the directory in which the data files are stored. If no directory is specified, the current working directory is used.</div> <div class="gutter_text_right"><a name="169075">Default</a></div> <div class="Body"><a name="169076">None</a></div> <div class="gutter_text_right"><a name="107007">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106316', '');" name="107012">General tab</a></span> </div> <div class="head_2_no_TOC"><a name="107014">Default Role</a></div> <div class="gutter_text_right"><a name="107015">Attribute</a></div> <div class="Body_attr"><a name="107018">TDRole (TDR)</a></div> <div class="gutter_text_right"><a name="107019">Description</a></div> <div class="table_text"><a name="107020">Specifies the Teradata role for the LDAP authentication mechanism.</a></div> <div class="gutter_text_right"><a name="107021">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="107022">string</a></span></div> <div class="Body"><a name="107023">where </a><span class="EquationVariables">string</span> is a valid role.</div> <div class="gutter_text_right"><a name="107024">Default</a></div> <div class="Body"><a name="107025">None</a></div> <div class="gutter_text_right"><a name="107026">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106316', '');" name="107031">General tab</a></span></div> <div class="head_2_no_TOC"><a name="107033">Description</a></div> <div class="gutter_text_right"><a name="107034">Attribute</a></div> <div class="Body_attr"><a name="107036">Description (n/a)</a></div> <div class="gutter_text_right"><a name="107037">Description</a></div> <div class="Body"><a name="179171">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="107042">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="179175">string</a></span> </div> <div class="Body"><a name="179176">where </a><span class="EquationVariables">string</span> is a description of a data source.</div> <div class="gutter_text_right"><a name="107048">Default</a></div> <div class="Body"><a name="107049">None</a></div> <div class="gutter_text_right"><a name="107050">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106316', '');" name="107055">General tab</a></span></div> <div class="head_2_no_TOC"><a name="107058">Enable Data Encryption</a></div> <div class="gutter_text_right"><a name="107059">Attribute</a></div> <div class="Body_attr"><a name="107061">EnableDataEncryption (EDE)</a></div> <div class="gutter_text_right"><a name="107062">Description</a></div> <div class="Body"><a name="107063">Determines whether the driver uses data encryption.</a></div> <div class="gutter_text_right"><a name="107064">Valid Values</a></div> <div class="Body"><a name="107065">1 | 0</a></div> <div class="Body"><a name="107066">If set to 1 (Enabled), the driver encrypts data and communicates with the Teradata gateway </a>using encryption.</div> <div class="Body"><a name="107067">NOTE: Before you use this value, verify that the server is encryption capable. Data </a>encryption may adversely affect performance because of the additional overhead (mainly CPU usage) required to encrypt and decrypt data.</div> <div class="Body"><a name="107068">If set to 0 (Disabled), the driver does not encrypt data except for logon information.</a></div> <div class="gutter_text_right"><a name="107069">Default</a></div> <div class="Body"><a name="107070">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="107071">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106414', '');" name="107076">Options tab</a></span></div> <div class="head_2_no_TOC"><a name="107078">Enable Extended Statement Information </a></div> <div class="gutter_text_right"><a name="107080">Attribute</a></div> <div class="Body_attr"><a name="107082">EnableExtendedStmtInfo (EESI)</a></div> <div class="gutter_text_right"><a name="107083">Description</a></div> <div class="Body"><a name="107084">Determines whether the driver supports extended statement information.</a></div> <div class="gutter_text_right"><a name="107085">Valid Values</a></div> <div class="Body"><a name="107086">1 | 0</a></div> <div class="Body"><a name="107087">If set to 1 (Enabled), the driver queries the server to see if it supports the Statement </a>Information parcel. If the server supports the Statement Information parcel, the driver requests the Statement Information parcel and enables auto-generated key retrieval and SQLDescribeParam support. Use this value if you want to enable the Return Generated Keys option.</div> <div class="Body"><a name="107088">If set to 0 (Disabled), the driver does not attempt to expose auto-generated key retrieval or </a>SQLDescribeParam.</div> <div class="gutter_text_right"><a name="107089">Default</a></div> <div class="Body"><a name="107090">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="107091">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106414', '');" name="107096">Options tab</a></span> </div> <div class="head_2_no_TOC"><a name="107099">Enable LOBs</a></div> <div class="gutter_text_right"><a name="107100">Attribute</a></div> <div class="Body_attr"><a name="107102">EnableLOBs (EL)</a></div> <div class="gutter_text_right"><a name="107103">Description</a></div> <div class="Body"><a name="107104">Determines whether the driver enforces native LOB data type mapping. </a></div> <div class="gutter_text_right"><a name="107105">Valid Values</a></div> <div class="Body"><a name="107106">1 | 0</a></div> <div class="Body"><a name="107107">If set to 1 (Enabled), the driver enforces native LOB data type mapping as described:</a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="107108">ODBC data type SQL_LONGVARBINARY is mapped to the Teradata BLOB feature.</a></div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="107109">ODBC data type SQL_LONGVARCHAR is mapped to the Teradata CLOB feature.</a></div> </td> </tr> </table> </div> <div class="Body"><a name="107110">If set to 0 (Disabled), the driver provides backward compatibility for applications without </a>LOB support that are using a version of Teradata Database prior to V2R5.1. The mappings are:</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="107111">ODBC data type SQL_LONGVARBINARY is mapped to the Teradata VARBYTE(32000) </a>feature.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="107112">ODBC data type SQL_LONGVARCHAR is mapped to the Teradata LONG VARCHAR </a>feature.</div> </td> </tr> </table> </div> <div class="Body"><a name="107113">This value can improve performance if your application does not send data to, or retrieve it </a>from, LOB columns. You may receive an error if you disable this option and try to retrieve data from a LOB column.</div> <div class="gutter_text_right"><a name="107114">Default</a></div> <div class="Body"><a name="107115">1 (Enabled)</a></div> <div class="gutter_text_right"><a name="107116">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106414', '');" name="107121">Options tab</a></span> </div> <div class="head_2_no_TOC"><a name="107124">Enable Reconnect</a></div> <div class="gutter_text_right"><a name="107125">Attribute</a></div> <div class="Body_attr"><a name="107127">EnableReconnect (ER)</a></div> <div class="gutter_text_right"><a name="107128">Description</a></div> <div class="Body"><a name="107129">Determines whether the driver will reconnect after a system crash or reset is detected. </a></div> <div class="gutter_text_right"><a name="107130">Valid Values</a></div> <div class="Body"><a name="107131">1 | 0</a></div> <div class="Body"><a name="107132">If set to 1 (Enabled), the driver attempts to reconnect to the saved sessions; however, </a>sessions cannot be reconnected until the Teradata system is available. After a session has been reconnected, applications can expect to receive error messages describing why the ODBC function failed, as well as a status report describing the post-recovery state. </div> <div class="Body"><a name="107133">If set to 0 (Disabled), the driver does not attempt to reconnect to the saved sessions.</a></div> <div class="gutter_text_right"><a name="107134">Default</a></div> <div class="Body"><a name="107135">0 (Disabled)</a></div> <div class="gutter_text_right"><a name="107136">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106414', '');" name="107141">Options tab</a></span> </div> <div class="head_2_no_TOC"><a name="107147">IANAAppCodePage</a></div> <div class="gutter_text_right"><a name="107148">Attribute</a></div> <div class="Body_attr"><a name="107150">IANAAppCodePage (IACP)</a></div> <div class="gutter_text_right"><a name="107151">Description</a></div> <div class="Body"><a name="179180">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="179188">The driver uses the specified IANA code page to convert "W" (wide) functions to ANSI.</a></div> <div class="Body"><a name="179189">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="179190">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="179191">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="179192">In the ODBC section of the system information file (odbc.ini)</a></div> </td> </tr> </table> </div> <div class="Body"><a name="179193">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="107169">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="179197">IANA_code_page</a></span> </div> <div class="Body"><a name="179199">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="107179">Default</a></div> <div class="Body"><a name="107181">4 (ISO 8559-1 Latin-1)</a></div> <div class="gutter_text_right"><a name="107182">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106482', '');" name="107187">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="107190">Integrated Security</a></div> <div class="gutter_text_right"><a name="107191">Attribute</a></div> <div class="Body_attr"><a name="107193">IntegratedSecurity (IS)</a></div> <div class="gutter_text_right"><a name="107194">Description</a></div> <div class="Body"><a name="107195">Determines whether the driver allows the user to connect to the database using Single Sign </a>On (SSO) through an authentication mechanism that supports SSO. </div> <div class="gutter_text_right"><a name="107196">Valid Values</a></div> <div class="Body"><a name="107197">Yes | No</a></div> <div class="Body"><a name="107198">If set to Yes (Enabled), SSO is allowed. The driver uses the operating system user ID and </a>password.</div> <div class="Body"><a name="107199">If set to No (Disabled), you must specify a value for the UserID option.</a></div> <div class="gutter_text_right"><a name="107200">Default</a></div> <div class="Body"><a name="107201">No (Disabled)</a></div> <div class="gutter_text_right"><a name="107202">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106316', '');" name="107207">General tab</a></span> </div> <div class="head_2_no_TOC"><a name="107210">Login Timeout</a></div> <div class="gutter_text_right"><a name="107211">Attribute</a></div> <div class="Body_attr"><a name="107213">LoginTimeout (LTO)</a></div> <div class="gutter_text_right"><a name="107214">Description</a></div> <div class="Body"><a name="107215">The number of seconds to wait when establishing a virtual circuit with Teradata for login.</a></div> <div class="gutter_text_right"><a name="107216">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="107217">x</a></span></div> <div class="Body"><a name="107218">where </a><span class="EquationVariables">x</span> is a positive integer.</div> <div class="Body"><a name="107219">If set to </a><span class="EquationVariables">x</span>, the driver waits the specified number of seconds.</div> <div class="gutter_text_right"><a name="107220">Default</a></div> <div class="Body"><a name="107221">20</a></div> <div class="gutter_text_right"><a name="107222">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106482', '');" name="107227">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="107230">Map Call Escape to Exec</a></div> <div class="gutter_text_right"><a name="107231">Attribute</a></div> <div class="Body_attr"><a name="107233">MapCallEscapeToExec (MCETE)</a></div> <div class="gutter_text_right"><a name="107234">Description</a></div> <div class="Body"><a name="107235">Determines whether the driver converts the </a><span class="Syntax">{CALL <name>(...)}</span> statement to <span class="Syntax">EXEC </span><span class="EquationVariables">name</span><span class="Syntax">(...)</span>.</div> <div class="gutter_text_right"><a name="107236">Valid Values</a></div> <div class="Body"><a name="107237">Yes | No</a></div> <div class="Body"><a name="107238">If set to Yes (Enabled), the driver considers the </a><span class="Syntax">{CALL <name>(...)}</span> statement as the SQL for MACRO execution and converts it to <span class="Syntax">EXEC </span><span class="EquationVariables">name</span><span class="Syntax">(...)</span>.</div> <div class="Body"><a name="107239">If set to No (Disabled), the driver does not convert </a><span class="Syntax">{CALL </span><span class="EquationVariables">name</span><span class="Syntax">(...)}</span> statements to <span class="Syntax">EXEC </span><span class="EquationVariables">name</span><span class="Syntax">(...)</span>, and considers them as CALL statements for Stored Procedure Execution.</div> <div class="gutter_text_right"><a name="107240">Default</a></div> <div class="Body"><a name="107241">No (Disabled)</a></div> <div class="gutter_text_right"><a name="107242">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106414', '');" name="107247">Options tab</a></span> </div> <div class="head_2_no_TOC"><a name="107250">Maximum Response Buffer Size</a></div> <div class="gutter_text_right"><a name="107251">Attribute</a></div> <div class="Body_attr"><a name="107253">MaxRespSize (MRS)</a></div> <div class="gutter_text_right"><a name="107254">Description</a></div> <div class="Body"><a name="107255">The size of the Teradata response buffer used for SQL requests. This value may be </a>adjusted dynamically if Teradata cannot send a result within the defined size.</div> <div class="gutter_text_right"><a name="107256">Valid Values</a></div> <div class="Body"><a name="107257">A positive integer from 1 to 65477</a></div> <div class="Body"><a name="107258">If using a slow TCP/IP interface, such as PPP or SLIP, enter a smaller value. If you expect </a>to retrieve large result sets in a LAN environment, set a larger value.</div> <div class="gutter_text_right"><a name="107259">Default</a></div> <div class="Body"><a name="107260">8192</a></div> <div class="gutter_text_right"><a name="107261">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106482', '');" name="107266">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="128711">Name</a></div> <div class="gutter_text_right"><a name="128712">Attribute</a></div> <div class="Body_attr"><a name="128714">DataSourceName (DSN)</a></div> <div class="gutter_text_right"><a name="128715">Description</a></div> <div class="Body"><a name="179153">The name of a data source in your Windows Registry or odbc.ini file.</a></div> <div class="gutter_text_right"><a name="128720">Valid Values</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="179157">string</a></span> </div> <div class="Body"><a name="179158">where </a><span class="EquationVariables">string</span> is the name of a data source.</div> <div class="gutter_text_right"><a name="128726">Default</a></div> <div class="Body"><a name="128728">None</a></div> <div class="gutter_text_right"><a name="128729">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106316', '');" name="128734">General tab</a></span></div> <div class="head_2_no_TOC"><a name="107268">Password</a></div> <div class="gutter_text_right"><a name="107269">Attribute</a></div> <div class="Body_attr"><a name="107271">Password (PWD)</a></div> <div class="gutter_text_right"><a name="107272">Description</a></div> <div class="Body"><a name="179206">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="107277">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="179210">pwd</a></span> </div> <div class="Body"><a name="179211">where </a><span class="EquationVariables">pwd</span> is a valid password.</div> <div class="gutter_text_right"><a name="107283">Default</a></div> <div class="Body"><a name="107284">None</a></div> <div class="gutter_text_right"><a name="115785">GUI Tab</a></div> <div class="Body"><a name="116158">n/a</a></div> <div class="head_2_no_TOC"><a name="107287">Port Number</a></div> <div class="gutter_text_right"><a name="107288">Attribute</a></div> <div class="Body_attr"><a name="107290">PortNumber (PORT)</a></div> <div class="gutter_text_right"><a name="107291">Description</a></div> <div class="Body"><a name="179215">The port number of the server listener.</a></div> <div class="gutter_text_right"><a name="107296">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="179219">port_name</a></span> </div> <div class="Body"><a name="179220">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="107302">Default</a></div> <div class="Body"><a name="107303">1025</a></div> <div class="gutter_text_right"><a name="107304">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106482', '');" name="107309">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="107312">ProcedureWithPrintStmt</a></div> <div class="gutter_text_right"><a name="107313">Attribute</a></div> <div class="Body_attr"><a name="107315">PrintOption (PO)</a></div> <div class="gutter_text_right"><a name="107316">Description</a></div> <div class="Body"><a name="107317">Determines whether the driver activates the print option when creating stored procedures.</a></div> <div class="gutter_text_right"><a name="107318">Valid Values</a></div> <div class="Body"><a name="107319">P | N</a></div> <div class="Body"><a name="107320">If set to P (Print), the driver activates the print option.</a></div> <div class="Body"><a name="107321">If set to N (No), the driver does not activate the print option.</a></div> <div class="gutter_text_right"><a name="107322">Default</a></div> <div class="Body"><a name="107323">N (No)</a></div> <div class="gutter_text_right"><a name="107324">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106482', '');" name="107329">Advanced tab</a></span> </div> <div class="head_2_no_TOC"><a name="107332">ProcedureWithSPLSource</a></div> <div class="gutter_text_right"><a name="107333">Attribute</a></div> <div class="Body_attr"><a name="107335">ProcedureWithSPLSource (PWSS)</a></div> <div class="gutter_text_right"><a name="107336">Description</a></div> <div class="Body"><a name="107337">Determines whether the drive specifies SPL text when creating stored procedures.</a></div> <div class="gutter_text_right"><a name="107338">Valid Values</a></div> <div class="Body"><a name="107339">Y | N</a></div> <div class="Body"><a name="107340">If set to Y (Yes), the driver specifies SPL text.</a></div> <div class="Body"><a name="107341">If set to N (No), the driver does not specify SPL text.</a></div> <div class="gutter_text_right"><a name="107342">Default</a></div> <div class="Body"><a name="107343">Y (Yes)</a></div> <div class="gutter_text_right"><a name="107344">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106482', '');" name="107349">Advanced tab</a></span></div> <div class="head_2_no_TOC"><a name="107351">Profile</a></div> <div class="gutter_text_right"><a name="107352">Attribute</a></div> <div class="Body_attr"><a name="107355">TDProfile (TDP)</a></div> <div class="gutter_text_right"><a name="107356">Description</a></div> <div class="Body"><a name="107357">Specifies the Teradata profile for the LDAP authentication mechanism.</a></div> <div class="gutter_text_right"><a name="107358">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="107359">string</a></span></div> <div class="Body"><a name="107360">where </a><span class="EquationVariables">string</span> is a valid profile.</div> <div class="gutter_text_right"><a name="107361">Default</a></div> <div class="Body"><a name="107362">None</a></div> <div class="gutter_text_right"><a name="107363">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106316', '');" name="107368">General tab</a></span></div> <div class="head_2_no_TOC"><a name="107370">Realm</a></div> <div class="gutter_text_right"><a name="107371">Attribute</a></div> <div class="Body_attr"><a name="107373">AuthenticationDomain (AD)</a></div> <div class="gutter_text_right"><a name="107374">Description</a></div> <div class="Body"><a name="107375">Specifies the domain appropriate to the selected authentication mechanism</a></div> <div class="gutter_text_right"><a name="107376">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="107377">string</a></span></div> <div class="Body"><a name="107378">where </a><span class="EquationVariables">string</span> is a valid domain.</div> <div class="gutter_text_right"><a name="107379">Default</a></div> <div class="Body"><a name="107380">None</a></div> <div class="gutter_text_right"><a name="107381">GUI Tab</a></div> <div class="Body"><a name="107382">None</a></div> <div class="head_2_no_TOC"><a name="107385">Report Codepage Conversion Errors</a></div> <div class="gutter_text_right"><a name="146715">Attribute</a></div> <div class="Body_attr"><a name="146717">ReportCodepageConversionErrors (RCCE)</a></div> <div class="gutter_text_right"><a name="146718">Description</a></div> <div class="Body"><a name="179224">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="179225">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="107396">Valid Values</a></div> <div class="Body"><a name="179229">0 | 1 | 2</a></div> <div class="Body"><a name="179230">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="179231">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="179232">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="107404">Default</a></div> <div class="Body"><a name="107406">0 (Ignore Errors)</a></div> <div class="gutter_text_right"><a name="107407">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106414', '');" name="107412">Options tab</a></span></div> <div class="head_2_no_TOC"><a name="107416">Security Mechanism</a></div> <div class="gutter_text_right"><a name="107417">Attribute</a></div> <div class="Body_attr"><a name="107419">SecurityMechanism (SECM)</a></div> <div class="gutter_text_right"><a name="107420">Description</a></div> <div class="Body"><a name="107421">The authentication method to be used by the driver for connections to the database.</a></div> <div class="gutter_text_right"><a name="107422">Valid Values</a></div> <div class="Body"><a name="107423">TD1 | TD2 | ldap | KRB5 | KRB5C | NTLM | NTLMC</a></div> <div class="Body"><a name="107424">If set to TD1, the driver uses Teradata 1. </a></div> <div class="Body"><a name="107425">If set to TD2, the driver uses Teradata 2.</a></div> <div class="Body"><a name="107426">If set to ldap, the driver uses LDAP. </a></div> <div class="Body"><a name="107427">If set to KRB5, the driver uses Kerberos on Windows clients working with Windows servers </a>if the server is V2R6.0.</div> <div class="Body"><a name="107428">If set to KRB5C, the driver uses Kerberos Compatibility on Windows clients working with </a>Windows servers if the server is pre-V2R6.0.</div> <div class="Body"><a name="107429">If set to NTLM, the driver uses NTLM on Windows clients working with Windows servers if </a>the server is V2R6.0.</div> <div class="Body"><a name="107430">If set to NTLMC, the driver uses NTLM Compatibility on Windows clients working with </a>Windows servers if the server is pre-V2R6.0.</div> <div class="Body"><a name="123385">NOTE: Kerberos and NTLM are enabled through the Teradata client. See your Teradata </a>documentation for requirements.</div> <div class="Body"><a name="107431">The following options may appear, based on the selected method:</a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;vertical-align: baseline;"> <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;color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none;"><span class="Emphasis"><a name="107432">No mechanism selected</a></span></div> </td> </tr> </table> </div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><span class="Action_bold"><a name="107433">User name</a></span>: A user name for the default Teradata database. If TeraSSO allows fully qualified user names, the user name may contain a domain or realm, for example, {judy@linedata}. Values containing a character like @ must be enclosed in braces.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><span class="Emphasis" style="color: #000000; font-size: 10pt; font-weight: normal;"><a name="107435">KRB5 and KRB5C</a></span></div> </td> </tr> </table> </div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><span class="Action_bold"><a name="107436">Authentication UserID</a></span>: The Kerberos user ID.</div> </td> </tr> </table> </div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><span class="Action_bold"><a name="107438">Realm</a></span>: The Kerberos domain. (The equivalent connection string attribute is AuthenticationDomain.)</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;vertical-align: baseline;"> <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;color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none;"><span class="Emphasis"><a name="107439">LDAP</a></span></div> </td> </tr> </table> </div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><span class="Action_bold"><a name="107440">Authentication UserID</a></span>: The LDAP user ID.</div> </td> </tr> </table> </div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><span class="Action_bold"><a name="107442">Realm</a></span>: The LDAP domain. (The equivalent connection string attribute is AuthenticationDomain.)</div> </td> </tr> </table> </div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><span class="Action_bold"><a name="107443">TD User name</a></span>: The Teradata user name.</div> </td> </tr> </table> </div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><span class="Action_bold"><a name="107444">Profile</a></span>: The Teradata Profile. (The equivalent connection string attribute is TDProfile.)</div> </td> </tr> </table> </div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><span class="Action_bold"><a name="107445">Default Role</a></span>: The Teradata Role. (The equivalent connection string attribute is TDRole.)</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;vertical-align: baseline;"> <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;color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none;"><span class="Emphasis"><a name="107446">NTLM and NTLMC</a></span></div> </td> </tr> </table> </div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><span class="Action_bold"><a name="107447">Authentication UserID</a></span>: The NTLM user ID.</div> </td> </tr> </table> </div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><span class="Action_bold"><a name="107449">Realm</a></span>: The NTLM domain. (The equivalent connection string attribute is AuthenticationDomain.)</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;vertical-align: baseline;"> <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;color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner" style="color: #000000; font-style: italic; font-variant: normal; font-weight: normal; text-transform: none;"><span class="Emphasis"><a name="107450">TD1 and TD2</a></span></div> </td> </tr> </table> </div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><span class="Action_bold"><a name="107451">Authentication UserID</a></span>: The TD1 or TD2 user ID.</div> </td> </tr> </table> </div> <div class="Body"><a name="107453">Other parameters for the authentication mechanism can be entered in the Security </a>Parameter field.</div> <div class="gutter_text_right"><a name="107454">Default</a></div> <div class="Body"><a name="107455">None</a></div> <div class="gutter_text_right"><a name="107456">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106316', '');" name="107461">General tab</a></span> </div> <div class="head_2_no_TOC"><a name="107464">Security Parameter</a></div> <div class="gutter_text_right"><a name="107465">Attribute</a></div> <div class="Body_attr"><a name="107467">SecurityParameter (SP)</a></div> <div class="gutter_text_right"><a name="107468">Description</a></div> <div class="Body"><a name="107469">A string that is passed as a parameter to the authentication method. The string is ignored by </a>the ODBC driver and is passed to the TeraSSO function that is called to set the authentication method. </div> <div class="gutter_text_right"><a name="107470">Valid Values</a></div> <div class="Body"><span class="EquationVariables"><a name="107471">string</a></span> </div> <div class="Body"><a name="107472">where </a><span class="EquationVariables">string</span> is a string of characters. The characters [] {} () , ; ? * = ! @ must be enclosed in curly braces.</div> <div class="gutter_text_right"><a name="107473">Default</a></div> <div class="Body"><a name="107474">None</a></div> <div class="gutter_text_right"><a name="107475">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106316', '');" name="107480">General tab</a></span> </div> <div class="head_2_no_TOC"><a name="107483">Session Character Set</a></div> <div class="gutter_text_right"><a name="107484">Attribute</a></div> <div class="Body_attr"><a name="107486">CharacterSet (CS)</a></div> <div class="gutter_text_right"><a name="107487">Description</a></div> <div class="Body"><a name="107488">A character set used to override the Teradata character set.</a></div> <div class="gutter_text_right"><a name="107489">Valid Values</a></div> <div class="Body"><a name="107490">ASCII | UTF16 (valid only for V2R6.</a><span class="Emphasis">x</span> servers) | LATIN1252_0A | LATIN9_0A | LATIN1_0A | Shift-JIS | EUC | BIG5 | GB | NetworkKorean</div> <div class="Body"><a name="107491">The specified character set must be installed on the database.</a></div> <div class="gutter_text_right"><a name="107492">Default</a></div> <div class="Body"><a name="107493">ASCII</a></div> <div class="gutter_text_right"><a name="107494">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106316', '');" name="107499">General tab</a></span> </div> <div class="head_2_no_TOC"><a name="107502">Show Selectable Tables</a></div> <div class="gutter_text_right"><a name="107503">Attribute</a></div> <div class="Body_attr"><a name="107505">ShowSelectableTables (SST)</a></div> <div class="gutter_text_right"><a name="107506">Description</a></div> <div class="Body"><a name="107507">Determines whether the driver supports X views. </a></div> <div class="gutter_text_right"><a name="107508">Valid Values</a></div> <div class="Body"><a name="107509">Yes | No</a></div> <div class="Body"><a name="107510">If set to Yes (Enabled), SQLTables() and SQLProcedures() use dbc.tablesX and </a>dbc.databasesX instead of dbc.tables and dbc.databases. Also, SQLColumns() and SQLProcedureColumns() use dbc.columnsX instead of dbc.columns. SqlStatistics() uses dbc.tablesizeX instead of dbc.tablesize. The X tables only contain information that the user has permission to access. These tables are optional for Teradata, so verify that they exist.</div> <div class="Body"><a name="107511">If set to No (Disabled), SQLTables() and SQLProcedures() use dbc.tables and </a>dbc.databases. Also, SQLColumns() and SQLProcedureColumns() use dbc.columns. SqlStatistics() uses dbc.tablesize.</div> <div class="gutter_text_right"><a name="107512">Default</a></div> <div class="Body"><a name="107513">Yes (Enabled)</a></div> <div class="gutter_text_right"><a name="107514">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106414', '');" name="107519">Options tab</a></span> </div> <div class="head_2_no_TOC"><a name="107521">TDUserName</a></div> <div class="gutter_text_right"><a name="107522">Attribute</a></div> <div class="Body_attr"><a name="107524">TDUserName (TDUN)</a></div> <div class="gutter_text_right"><a name="107525">Description</a></div> <div class="Body"><a name="107526">Specifies the Teradata user name for the LDAP authentication mechanism. </a></div> <div class="gutter_text_right"><a name="107527">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="107528">user_name</a></span></div> <div class="Body"><a name="107529">where </a><span class="EquationVariables">user_name</span> is a valid user name.</div> <div class="gutter_text_right"><a name="107530">Default</a></div> <div class="Body"><a name="107531">None</a></div> <div class="gutter_text_right"><a name="107532">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106316', '');" name="107537">General tab</a></span> </div> <div class="head_2_no_TOC"><a name="107539">UserID</a></div> <div class="gutter_text_right"><a name="107540">Attribute</a></div> <div class="Body_attr"><a name="107542">UserID (UID)</a></div> <div class="gutter_text_right"><a name="107543">Description</a></div> <div class="Body"><a name="179236">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="170398">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="179240">userid</a></span></div> <div class="Body"><a name="179241">where </a><span class="EquationVariables">userid</span> is a valid user ID with permissions to access the database.</div> <div class="Body"><a name="170404">The user name is interpreted in the context of the authentication mechanism. If, for </a>example, the authentication mechanism is NTLM, the user name is assumed to be a Windows user name.</div> <div class="Body"><a name="107555">If TeraSSO allows fully qualified user names, the user name may contain a domain or realm, </a>for example, {judy@linedata}. Values containing a character such as @ must be enclosed in curly braces.</div> <div class="Body"><a name="107556">SSO is indicated by the absence of a UserID.</a></div> <div class="gutter_text_right"><a name="107557">Default</a></div> <div class="Body"><a name="107558">None</a></div> <div class="gutter_text_right"><a name="107559">GUI Tab</a></div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'teradata.29.03.html#106316', '');" name="107564">General 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