Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\text.23.07.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 Windows</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#109226">18 The Text Driver</a> : Defining Table Structure on Windows</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="109226">Defining Table Structure on Windows</a></div> <div class="Body"><a name="109231">Because text files do not all have the same structure, the driver provides the option of </a>defining the structure of an existing file. Although defining the structure is not mandatory (the driver can attempt to guess the names and types of the columns), this feature is extremely useful.</div> <div class="hanging_label_head"><a name="109232">To define the structure of a 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="109233">Display the ODBC Text Driver Setup dialog box through the ODBC Administrator. Click </a>the <span class="Action_bold">Advanced</span> tab; then, click <span class="Action_bold">Define</span> to display the Define File dialog box.</div> </td> </tr> </table> </div> <div class="picture"><a name="152598"><img class="procedure" src="images/txtdeff.gif" width="563" height="412" style="display: block; float: none; left: 0.0; top: 0.0;" alt="The ODBC Text Driver Define File dialog box" /></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">2 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="109242">Select the correct file and click </a><span class="Action_bold">Open</span> to display the Define Table dialog box.</div> </td> </tr> </table> </div> <div class="picture"><a name="152611"><img class="procedure" src="images/txtdeft.gif" width="533" height="376" style="display: block; float: none; left: 0.0; top: 0.0;" alt="The ODBC Text Driver Define File dialog box" /></a></div> <div class="Body_Indent"><span class="Action_bold"><a name="109251">Database Name:</a></span> This field displays the name of the database directory that you selected in the Define File dialog box.</div> <div class="Body_Indent"><span class="Action_bold"><a name="109252">File:</a></span> This field displays the name of the file that you selected in the Define File dialog box.</div> <div class="Body_Indent"><span class="Action_bold"><a name="109253">Table:</a></span> Type a table name in the Table field. This name specifies the table name associated with the text file you selected earlier. The name can be a maximum of 32 characters and must be unique. This name is returned by SQLTables. By default, it is the file name without its extension (for example, Trc_read).</div> <div class="Body_Indent"><span class="Action_bold"><a name="109254">Column Names in First Line: </a></span>Select this check box if the first line of the file contains column names; otherwise, do not select this box.</div> <div class="Body_Indent"><span class="Action_bold"><a name="109255">Table Type:</a></span> Select the type of text file, either comma, tab, fixed, character, or stream.</div> <div class="Body_Indent"><span class="Action_bold"><a name="109256">Delimiter Character:</a></span> If the table type is Character, type the delimiter used in character-separated files. The value can be any printable character except single and double quotes.</div> <div class="Body_Indent"><span class="Action_bold"><a name="109257">Decimal Symbol:</a></span> Type the decimal separator used when data is stored. Valid values are a comma or a period. The international decimal symbol (.) must be used in DML statements and parameter buffers.</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="109258">If you specified a comma-separated, tab-separated, or character-separated type in the </a>Table Type field, the Guess/Parse button displays Guess. Click <span class="Action_bold">Guess</span> to have the driver guess at the column names and display them in the list box of the Column Information pane.</div> </td> </tr> </table> </div> <div class="Body_Indent"><a name="109260">If you specified a fixed-length or stream type in the Table Type field, the Guess/Parse </a>button displays Parse. Click <span class="Action_bold">Parse</span> to have the driver display the Parse Table dialog box and define the table columns.</div> <div class="picture"><a name="152624"><img class="procedure" src="images/txtpars.gif" width="512" height="137" style="display: block; float: none; left: 0.0; top: 0.0;" alt="The ODBC Text Driver Parse Table dialog box" /></a></div> <div class="Body_Indent"><a name="109269">This dialog box displays the first line of the file. You must mark where </a><span style="font-style: italic;">each</span> field begins and ends by enclosing it in square brackets [ ]. These brackets indicate the position and length of each field value in the record. Click <span class="Action_bold">OK</span> to close the Parse Table dialog box. The driver will suggest column names in the list box of the Column Information pane.</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="109270">If you do not want the driver to guess or parse, enter values in the following fields to </a>define each column. Click <span class="Action_bold">Add</span> to add the column name to the Column Information box.</div> </td> </tr> </table> </div> <div class="Body_Indent"><span class="Action_bold"><a name="109271">Name:</a></span> Type the name of the column.</div> <div class="Body_Indent"><span class="Action_bold"><a name="109272">Type:</a></span> Select the data type of the column. If the field type is Date, the Mask field is enabled and you must select a date mask or type one in. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.09.html#109337', '');">â??Date Masksâ??</a></span> for more information.</div> <div class="Body_Indent"><span class="Action_bold"><a name="109276">Mask:</a></span> Select a date mask. If you selected Date for the Type field, you must select a date mask for the field or type one in. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'text.23.09.html#109337', '');">â??Date Masksâ??</a></span> for more information.</div> <div class="Body_Indent"><span class="Action_bold"><a name="109280">Precision:</a></span> Type the precision of the column. The precision of numeric data types is defined as the maximum number of digits used by the data type of the column. For character types, this is the length in characters of the data. Note that the precision and scale values determine how numeric data is to be returned.</div> <div class="Body_Indent"><span class="Action_bold"><a name="109281">Scale:</a></span> Type the scale of the column. The scale of numeric data types is defined as the maximum number of digits to the right of the decimal point. Note that the precision and scale values determine how numeric data is to be returned.</div> <div class="Body_Indent"><span class="Action_bold"><a name="109282">Length:</a></span> If you specified a fixed-length table type, type the length, which is the number of bytes the data takes up in storage.</div> <div class="Body_Indent"><span class="Action_bold"><a name="109283">Offset:</a></span> If you specified a fixed-length table type, type the offset, which is the number of bytes from the start of the table to the start of the field.</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">5 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="109284">To modify an existing column definition, select the column name in the Column </a>Information box. Modify the values for that column name; then, click <span class="Action_bold">Modify</span>.</div> </td> </tr> </table> </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">6 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="109285">To delete an existing column definition, select a column name in the Column </a>Information box and click <span class="Action_bold">Remove</span>.</div> </td> </tr> </table> </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">7 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="109286">Click </a><span class="Action_bold">OK</span> to define the table.</div> </td> </tr> </table> </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