Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\dbasfox.21.06.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 Index Attributes on UNIX and Linux</title> <link rel="StyleSheet" href="css/dbasfox.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="dbasfox.21.01.html#119183">16 The dBASE Driver</a> : Defining Index Attributes on UNIX and Linux</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="119183">Defining Index Attributes on UNIX and Linux</a></div> <div class="Body"><a name="119187">Index files for dBASE contain index tags for each index that exists for a database file. These </a>index tags can be marked as unique, that is, the driver will ensure that no duplicate values exist for the columns that define the index tag. The unique attribute is not natively supported by the dBASE or FoxPro products. The enforcement and recognition of the unique attribute is an extension of the dBASE driver. The driver must be notified that index tags are unique. No configuration is needed for unique indexes that were created using the DataDirect Connect <span class="forbody">for</span> <span class="APIbody">ODBC</span> dBASE driver. When using files that were not created with the dBASE driver, you must define unique index tags as outlined in the following procedure.</div> <div class="Body"><a name="119188">In the directory where the database and index files are located, use any text editor, such as </a>vi, to define or edit the QEDBF.INI as follows:</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="119189">Create a </a><span class="Syntax">[</span><span class="EquationVariables">filename</span><span class="Syntax">]</span> section where <span class="EquationVariables">filename</span> is the name of the database file. This entry is case-sensitive and the file extension must be included, for example, <span class="Syntax">[accts.dbf]</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">2 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="119190">In the </a><span class="Syntax">[</span><span class="EquationVariables">filename</span><span class="Syntax">]</span> section, specify the number of unique indexes on the file (<span class="Syntax">NUMUNIQUE=</span>) and the index specifications (<span class="Syntax">UNIQUE#=</span><span class="EquationVariables">index_filename</span><span class="Syntax">,</span><span class="EquationVariables">index_tag</span>). The <span class="EquationVariables">index_tag</span> can be determined by calling the ODBC function SQLStatistics and examining the INDEX_NAME result column.</div> </td> </tr> </table> </div> <div class="Body"><a name="119191">For example, to define two unique indexes on the accts.dbf database file, the QEDBF.INI </a>would be defined as:</div> <div class="syntax_first"><a name="119192">[accts.dbf]</a></div> <div class="syntax"><a name="119193">NUMUNIQUE=2</a></div> <div class="syntax"><a name="119194">UNIQUE0=accts.mdx,ACCT_NAME</a></div> <div class="syntax"><a name="119195">UNIQUE1=accts.mdx,ACCT_ID</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