Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\text.23.08.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>Defining Table Structure on UNIX and Linux</title> <link rel="StyleSheet" href="css/text.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="text.23.01.html#109290">18 The Text Driver</a> : Defining Table Structure on UNIX and Linux </div> <hr align="left" /> <blockquote> <div class="head_1"><a name="109290">Defining Table Structure on UNIX and Linux </a></div> <div class="Body"><a name="109294">Because text files do not all have the same structure, the driver provides the option to define </a>the structure of an existing file. Although defining the structure is not mandatory, because the driver can attempt to guess the names and types of the columns, this feature is extremely useful.</div> <div class="Body"><a name="109295">To define the structure of a text file, you create a QETXT.INI file using any plain text editor, </a>such as vi. The file name must be in uppercase. All of the tables you want to define are specified in the QETXT.INI file. When you specify table attributes in QETXT.INI, you override the attributes specified in the system information file (odbc.ini) or in the connection string.</div> <div class="hanging_label_head"><a name="109296">To define the QETXT.INI file:</a></div> <div class="list_procedure_first_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_first_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">1 </span> </div> </td> <td width="100%"> <div class="list_procedure_first_inner"><a name="109297">Create a [Defined Tables] section and list all of the tables you are defining. Specify the </a>text file name (in either upper or lowercase, depending on the file) followed by the name you want to give the table, for example:</div> </td> </tr> </table> </div> <div class="syntax_embed_first"><a name="109298">emptext.txt=EMP </a></div> <div class="Body_Indent"><a name="109299">Table names can be up to 32 characters in length and cannot be the same as another </a>defined table in the database. This name is returned by SQLTables. By default, it is the file name without its extension.</div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">2 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="109300">For each table listed in the [Defined Tables] section, you must specify the text file </a>(FILE=), the table type (TT=), whether the first line of the file contains column names (FLN=), and the delimiter character (DC=).</div> </td> </tr> </table> </div> <div class="list_bulleted_proc_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_proc_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_proc_inner"><a name="109301">Specify the text file name. For example:</a></div> </td> </tr> </table> </div> <div class="syntax_embed_sub_first"><a name="109302">FILE=emptext.txt </a></div> <div class="list_bulleted_proc_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_proc_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_proc_inner"><a name="109303">To define the table type, specify how the fields are separated (comma, tab, fixed, or </a>character). For example: </div> </td> </tr> </table> </div> <div class="syntax_embed_sub_first"><a name="109304">TT=COMMA </a></div> <div class="list_bulleted_proc_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_proc_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_proc_inner"><a name="109305">If the table type is CHARACTER, specify the delimiter character. The value can be </a>any printable character except single and double quotes. For example, if the fields are separated by comma:</div> </td> </tr> </table> </div> <div class="syntax_embed_sub_first"><a name="109306">DC=,</a></div> <div class="list_bulleted_proc_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_proc_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_proc_inner"><a name="109307">Specify whether the first line of the file contains column names, using 1 for yes and </a>0 for no. For example: </div> </td> </tr> </table> </div> <div class="syntax_embed_sub_first"><a name="109308">FLN=0</a></div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">3 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="109309">Define the fields in the table, beginning with FIELD1. For each field, specify the field </a>name, field type, precision, scale, length, offset (for fixed tables), and date/time mask. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.09.html#109337', '');">â??Date Masksâ??</a></span> for information about masks. </div> </td> </tr> </table> </div> <div class="Body_Indent"><a name="109313">Separate the values with commas. For example, to define two fields:</a></div> <div class="syntax_embed_first"><a name="109314">FIELD1=EMP_ID,VARCHAR,6,0,6,0,</a></div> <div class="syntax_embed"><a name="109315">FIELD2=HIRE_DATE,DATE,10,0,10,0,m/d/yy</a></div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">4 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="109316">Save the file as QETXT.INI. The driver looks for this file in the directory specified by the </a>Database attribute in odbc.ini, or in the current directory.</div> </td> </tr> </table> </div> <div class="head_2_no_TOC"><a name="109317">Example of QETXT.INI</a></div> <div class="Body"><a name="109318">The following is an example of a QETXT.INI file. This file defines the structure of the </a>emptext.txt file, which is a sample data file shipped with the DataDirect ODBC Text file. </div> <div class="syntax_first"><a name="109319">[Defined Tables]</a></div> <div class="syntax"><a name="109320">emptext.txt=EMP</a></div> <div class="syntax"><a name="109321"> </a></div> <div class="syntax"><a name="109322">[EMP]</a></div> <div class="syntax"><a name="109323">FILE=emptext.txt</a></div> <div class="syntax"><a name="109324">FLN=1</a></div> <div class="syntax"><a name="109325">TT=Comma</a></div> <div class="syntax"><a name="109326">FIELD1=FIRST_NAME,VARCHAR,10,0,10,0,</a></div> <div class="syntax"><a name="109327">FIELD2=LAST_NAME,VARCHAR,9,0,9,0,</a></div> <div class="syntax"><a name="109328">FIELD3=EMP_ID,VARCHAR,6,0,6,0,</a></div> <div class="syntax"><a name="109329">FIELD4=HIRE_DATE,DATE,10,0,10,0,m/d/yy</a></div> <div class="syntax"><a name="109330">FIELD5=SALARY,NUMERIC,8,2,8,0,</a></div> <div class="syntax"><a name="109331">FIELD6=DEPT,VARCHAR,4,0,4,0,</a></div> <div class="syntax"><a name="109332">FIELD7=EXEMPT,VARCHAR,6,0,6,0,</a></div> <div class="syntax"><a name="109333">FIELD8=INTERESTS,VARCHAR,136,0,136,0,</a></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