<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="../../Templates/DocTemp.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Database Platforms - SQL Server - Create an Environment Source File</title>
<!-- InstanceEndEditable --> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../../docs.css" rel="stylesheet" type="text/css">
<script language="JavaScript1.2" src="../../docs.js"></script>
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
</head>

<body>
<table width="100%" class="lightblue" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><a href="http://www.omnidex.com"><img src="../../images/flatlogo.gif" width="95" height="25" hspace="3" vspace="3" border="0"></a></td>
    <td><img src="../../images/omnidex.gif" width="109" height="25" hspace="3" vspace="3"></td>
    <td align="right" valign="top"><p class="banner"><a href="../../Contents.htm">Contents</a> 
        | <a href="../../Quick%20Links.htm">Quick Links</a></p></td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td width="175" class="bar"><p class="banner">&nbsp;</p></td>
    <td align="right" class="bar"> <!-- InstanceBeginEditable name="Section Title" --> 
      <h1>Getting Started with SQL Server</h1>
      <!-- InstanceEndEditable --></td>
  </tr>
  <tr> 
    <td width="175" class="left1 lightblue"><img src="../../images/blank.gif" width="10" height="20"> 
    </td>
    <td valign="top" class="left1 lightblue">&nbsp; </td>
  </tr>
  <tr> 
    <td width="175" valign="top" class="left"><!-- InstanceBeginEditable name="leftnav" --> 
      <p><a href="#src">Use OAHELPER to Generate the Environment Source File</a></p>
      <p><a href="#verify">Verify The Environment Source Contents</a></p>
      <p><a href="#compile">Compile the Source File</a></p>
      <p><a href="#sample">Sample Source File</a></p>
      <p class="line">&nbsp;</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <!-- InstanceEndEditable --></td>
    <td valign="top" class="content"> <!-- InstanceBeginEditable name="Content" --> 
      <h2>Create an Environment Catalog</h2>
      <p>After creating and testing the ODBC data source, you must create the 
        <a href="../../Environment%20Catalog/Environment%20Catalog.htm">Omnidex 
        Environment Catalog</a>. The easiest way to accomplish this is to use 
        <a href="../../Utilities/OAHELPER/OAHELPER.htm">OAHELPER</a> to generate 
        the source file, verify the contents, and then compile the source file 
        into the environment catalog.</p>
      <p>The source file can also be manually created using any text editor, but 
        this method is more time consuming and lends itself to more errors, typographical 
        and otherwise.</p>
      <p class="line">&nbsp;</p>
      <h3><a name="src"></a>Use OAHELPER to Generate the Environment Source File</h3>
      <p>Run <a href="../../Utilities/OAHELPER/OAHELPER.htm">OAHELPER</a> to generate 
        an Omnidex Environment Source file for the SQL Server database. OAHELPER 
        is a console based program.</p>
      <p class="indent"><img src="../../images/arrow.gif" width="10" height="10">Open 
        a console window (DOS).</p>
      <p class="indent">&nbsp;</p>
      <p class="indent"><img src="../../images/arrow.gif" width="10" height="10">Run 
        OAHLEPER. Type oahelper at the DOS prompt.</p>
      <p class="ex">&gt;oahelper</p>
      <p class="indent">&nbsp;</p>
      <p class="indent"><img src="../../images/arrow.gif" width="10" height="10">Select 
        option number 1 from the OAHELPER menu.</p>
      <p class="ex">OAHELPER Menu:</p>
      <p class="ex">1) Generate Environment Source file from a database.<br>
        2) Generate DBINSTAL Indexing/Build script from existing installation.<br>
        3) Generate Environment Source file from existing installation.<br>
        4) Generate Migration scripts from existing installation.</p>
      <p class="ex">E to Exit oahelper.</p>
      <p class="ex">Enter menu number, ? for help, or 'E' to Exit: <font color="#FF0000">1</font></p>
      <p class="indent">&nbsp;</p>
      <p class="indent"><img src="../../images/arrow.gif" width="10" height="10">Select 
        option number 5 from the list of database types.</p>
      <p class="ex">Generate an environment file for:</p>
      <p class="ex">1. Oracle<br>
        2. Sybase<br>
        3. Image<br>
        4. Informix<br>
        5. ODBC<br>
        6. DB2<br>
        7. SQLServer</p>
      <p class="ex"> Enter choice or ? for help: <font color="#FF0000">7</font></p>
      <p class="indent">&nbsp;</p>
      <p class="indent"><img src="../../images/arrow.gif" width="10" height="10">Enter 
        the database logical name.</p>
      <p class="ex">Database logical name: <font color="#FF0000">ORDERS_DB</font></p>
      <p class="indent"><img src="../../images/blank.gif" width="10" height="10">This 
        is the name of the database as it will be defined in the Environment file. 
        It MUST begin with a letter a -z (case insensitive). It can be up to 32 
        characters long and can contain letters, numbers and <a href="../../Omnidex%20Concepts/Indexing%20Options/Special%20Characters.htm#allowed">allowed 
        special characters</a>. This name does not have to correspond to any name 
        defined in SQL Server.</p>
      <p class="indent">&nbsp;</p>
      <p class="indent"><img src="../../images/arrow.gif" width="10" height="10">Enter 
        the table names, as defined in SQL Server, to be included in the environment 
        file.</p>
      <p class="ex">Table list (table, owner.table, or *): <font color="#FF0000">*</font></p>
      <p class="indent"><img src="../../images/blank.gif" width="10" height="10">Enter 
        * (asterisk) to include all tables or a comma separated list of table 
        names to include only specified tables.</p>
      <p class="indent">&nbsp;</p>
      <p class="indent"> <img src="../../images/arrow.gif" width="10" height="10">Enter 
        the environment logical name.</p>
      <p class="ex">Environment logical name [ORDERS_DB_ENV]: </p>
      <p class="indent"><img src="../../images/blank.gif" width="10" height="10">This 
        is the name of the environment as it will be defined in the Environment 
        file. It MUST begin with a letter a -z (case insensitive). It can be up 
        to 32 characters long and can contain letters, numbers and <a href="../../Omnidex%20Concepts/Indexing%20Options/Special%20Characters.htm#allowed">allowed 
        special characters</a>. This name does not have to correspond to any name 
        defined in SQL Server. It does not have to match the name of the environment 
        source file name. Leave blank to accept the default suggested environment 
        name in square brackets [PUBS_DB_ENV] in this example.</p>
      <p class="indent">&nbsp;</p>
      <p class="indent"><img src="../../images/arrow.gif" width="10" height="10">Select 
        the ODBC Data Source type. This is the ODBC datasource created to connect 
        directly to the SQL Server database in the previous step.</p>
      <p class="ex">ODBC datasource type? (S)ystem/(U)ser, (F)ile: <font color="#FF0000">S</font> 
      </p>
      <p class="indent">&nbsp;</p>
      <p class="indent"><img src="../../images/arrow.gif" width="10" height="10">Enter 
        the data source name.</p>
      <p class="ex">Datasource name [ORDERS_DB]: <font color="#FF0000">ORDERS_DB</font></p>
      <p class="indent">&nbsp;</p>
      <p class="indent"><img src="../../images/arrow.gif" width="10" height="10">If 
        the data source type is a User or System data source, the above entry 
        is appropriate, where ORDERS_DB is the data source name.<br>
        If the data source type is a File data source, the entry will be the physical 
        path and filename of the data source.</p>
      <p class="ex">Datasource name [ORDERS_DB]: <font color="#FF0000">c:\test\orders\dsn\ORDERS_FILE_DB.dsn</font></p>
      <p class="indent">&nbsp;</p>
      <p class="indent"><img src="../../images/arrow.gif" width="10" height="10">Enter 
        the index prefix.</p>
      <p class="ex">Index prefix [orders_db]: <font color="#FF0000">c:\test\idx\orders\ORDERS</font></p>
      <p class="indent">&nbsp;</p>
      <p class="indent"><img src="../../images/arrow.gif" width="10" height="10">Enter 
        the default user name, if required.<br>
        Enter the default password, if required.</p>
      <p class="ex">Default User name: </p>
      <p class="ex">Default Password: </p>
      <p class="indent"><img src="../../images/blank.gif" width="10" height="10">These 
        settings will be used by all connections through this environment file. 
        Leave blank if a user name and password are not required.</p>
      <p class="indent">&nbsp;</p>
      <p class="indent"><img src="../../images/arrow.gif" width="10" height="10">Enter 
        the SQL Server version number.</p>
      <p class="ex">Database Version: <font color="#FF0000">8</font></p>
      <p class="indent">&nbsp;</p>
      <p class="indent"><img src="../../images/arrow.gif" width="10" height="10">Enter 
        the environment source file name to be generated.</p>
      <p class="ex">Environment source to generate [orders_db.src] (or / for screen 
        output): <font color="#FF0000">c:\test\orders\src\ORDERS_DB.src</font></p>
      <p class="indent"><img src="../../images/blank.gif" width="10" height="10">This 
        can include a path to specify where the environment source file should 
        be placed. The source file should have a .src file extension.</p>
      <p class="indent">&nbsp;</p>
      <p class="indent"><img src="../../images/arrow.gif" width="10" height="10">If 
        the specified file already exists, OAHELPER will display a message similar 
        to the following:</p>
      <p class="ex">c:\test\orders\src\ORDERS_DB.src exists. Overwrite? [N]: <font color="#FF0000">Y</font></p>
      <p class="indent"><img src="../../images/blank.gif" width="10" height="10">Enter 
        Y to overwrite the existing source file or N to change the source file 
        name.</p>
      <p class="indent"><img src="../../images/blank.gif" width="10" height="10">OAHELPER 
        connects to SQL Server using the information provided.</p>
      <p class="ex">Generating...</p>
      <p class="ex">Finished.</p>
      <p class="ex">The environment schema file: c:\test\orders\src\ORDERS_DB.src 
        has been created.</p>
      <p class="line">&nbsp;</p>
      <h3><a name="verify"></a>Verify The Environment Source Contents</h3>
      <p>The environment source file generated by <a href="../../Utilities/OAHELPER/OAHELPER.htm">OAHELPER</a> 
        against the ORDERS sample database in SQL Server is listed below. </p>
      <p>Some minor adjustments may have to be made prior to compiling the source 
        file. Specifically:</p>
      <ul>
        <li>the unique key of the parent tables must be defined with USAGE ROWID 
          or USAGE AUTO ROWID, depending on how it is set up in the database. 
        </li>
        <li>verify that the datatypes are correct.</li>
        <li>verify that the parent table primary keys are defined with a native 
          index. These should be listed at the bottom of the source.</li>
        <li>remove any table that you don't want accessible from this application.</li>
      </ul>
      <p class="line">&nbsp;</p>
      <h3><a name="compile"></a>Compile the Source File</h3>
      <p>The environment source file must now be compiled into the environment 
        catalog using <a href="../../Utilities/OACOMP/OACOMP.htm">OACOMP</a>. 
      </p>
      <p class="ex">c:\omnidex\demo&gt;oacomp orders<br>
        Omnidex registry (C:\omnidex\odxreg) expires in 5 day(s)!DS73010 2.7.02 
        OmniAccess Environment Compiler Fri Mar 26 14:49:35 2004<br>
        (c) Dynamic Information Systems Corp. 1981-2004<br>
        LICENSEE: ** Trial Copy **</p>
      <p class="ex">Parsed; Validated; Compiled; Done<br>
        ** Environment Compiled Successfully! **</p>
      <p>&nbsp;</p>
      <p class="line">&nbsp;</p>
      <h3><a name="sample"></a>Sample Source File</h3>
      <p>The following is the environment source generated by OAHELPER.</p>
      <p class="ex">/* Generated by oahelper on Fri Mar 26 10:07:46 2004 */</p>
      <p class="ex">ENVIRONMENT &quot;ORDERS_DB_ENV&quot;</p>
      <p class="ex">DATABASE &nbsp; &nbsp;&quot;ORDERS_DB&quot;<br>
        TYPE &nbsp; &nbsp; &nbsp; &nbsp; ODBC<br>
        PHYSICAL &nbsp; &nbsp;&quot;Orders&quot;<br>
        USERCLASS &nbsp; &quot;DEFAULT&quot; USER &quot;&quot; PASSWORD &quot;&quot;<br>
        INDEXPREFIX &quot;ordersssv&quot;</p>
      <p class="ex"><br>
        TABLE &nbsp; &nbsp;&quot;ACTIVITY&quot;<br>
        TYPE &nbsp; &nbsp; &nbspRELATIONAL<br>
        PHYSICAL &quot;ORDERS.dbo.ACTIVITY&quot;<br>
        FOREIGN KEY &quot;CUSTOMER_NO&quot; REFERENCES &quot;CUSTOMERS&quot;(&quot;CUSTOMER_NO&quot;)</p>
      <p class="ex"> COLUMN &quot;CUSTOMER_NO&quot; &nbsp;PHYSICAL &quot;CUSTOMER_NO&quot; 
        &nbsp;DATATYPE INTEGER<br>
        COLUMN &quot;DATE_TICKLER&quot; PHYSICAL &quot;DATE_TICKLER&quot; DATATYPE 
        ODBC DATETIME<br>
        COLUMN &quot;TICKLER&quot; &nbsp; &nbsp; &nbsp;PHYSICAL &quot;TICKLER&quot; 
        &nbsp; &nbsp; &nbsp;DATATYPE C STRING(2)<br>
        COLUMN &quot;INITIALS&quot; &nbsp; &nbsp; PHYSICAL &quot;INITIALS&quot; 
        &nbsp; &nbsp; DATATYPE C STRING(4)<br>
        COLUMN &quot;ACTION_INFO&quot; &nbsp;PHYSICAL &quot;ACTION_INFO&quot; 
        &nbsp;DATATYPE C STRING(60)<br>
        COLUMN &quot;ACTIVITYID&quot; &nbsp; PHYSICAL &quot;ACTIVITYID&quot; &nbsp; 
        DATATYPE INTEGER<br>
        USAGE AUTO ROWID</p>
      <p class="ex"><br>
        TABLE &nbsp; &nbsp;&quot;CUST_NOTES&quot;<br>
        TYPE &nbsp; &nbsp;&nbsp; RELATIONAL<br>
        PHYSICAL &quot;ORDERS.dbo.CUST_NOTES&quot;<br>
        FOREIGN KEY &quot;CUSTOMER_NO&quot; REFERENCES &quot;CUSTOMERS&quot;(&quot;CUSTOMER_NO&quot;)</p>
      <p class="ex"> COLUMN &quot;CUSTOMER_NO&quot; &nbsp;PHYSICAL &quot;CUSTOMER_NO&quot; 
        &nbsp;DATATYPE INTEGER<br>
        COLUMN &quot;DATE_ENTERED&quot; PHYSICAL &quot;DATE_ENTERED&quot; DATATYPE 
        ODBC DATETIME<br>
        COLUMN &quot;ENTERED_BY&quot; &nbsp; PHYSICAL &quot;ENTERED_BY&quot; &nbsp; 
        DATATYPE C STRING(4)<br>
        COLUMN &quot;DESC_LINES1&quot; &nbsp;PHYSICAL &quot;DESC_LINES1&quot; 
        &nbsp;DATATYPE C STRING(60)<br>
        COLUMN &quot;DESC_LINES2&quot; &nbsp;PHYSICAL &quot;DESC_LINES2&quot; 
        &nbsp;DATATYPE C STRING(60)<br>
        COLUMN &quot;DESC_LINES3&quot; &nbsp;PHYSICAL &quot;DESC_LINES3&quot; 
        &nbsp;DATATYPE C STRING(60)<br>
        COLUMN &quot;DESC_LINES4&quot; &nbsp;PHYSICAL &quot;DESC_LINES4&quot; 
        &nbsp;DATATYPE C STRING(60)<br>
        COLUMN &quot;DESC_LINES5&quot; &nbsp;PHYSICAL &quot;DESC_LINES5&quot; 
        &nbsp;DATATYPE C STRING(60)<br>
        COLUMN &quot;CUSTNOTESID&quot; &nbsp;PHYSICAL &quot;CUSTNOTESID&quot; 
        &nbsp;DATATYPE INTEGER<br>
        USAGE AUTO ROWID</p>
      <p class="ex"><br>
        TABLE &nbsp; &nbsp;&quot;CUSTOMERS&quot;<br>
        TYPE &nbsp; &nbsp; &nbsp;RELATIONAL<br>
        PHYSICAL &quot;ORDERS.dbo.CUSTOMERS&quot;<br>
        PRIMARY KEY &quot;CUSTOMER_NO&quot;</p>
      <p class="ex"> COLUMN &quot;CUSTOMER_NO&quot; PHYSICAL &quot;CUSTOMER_NO&quot; 
        DATATYPE INTEGER<br>
        USAGE ROWID<br>
        COLUMN &quot;COMPANY&quot; &nbsp; &nbsp; PHYSICAL &quot;COMPANY&quot; 
        &nbsp; &nbsp; DATATYPE C STRING(40)<br>
        COLUMN &quot;CONTACT&quot; &nbsp; &nbsp; PHYSICAL &quot;CONTACT&quot; 
        &nbsp; &nbsp; DATATYPE C STRING(24)<br>
        COLUMN &quot;TITLE&quot; &nbsp; &nbsp; &nbsp; PHYSICAL &quot;TITLE&quot; 
        &nbsp; &nbsp; &nbsp; DATATYPE C STRING(30)<br>
        COLUMN &quot;SALUTATION&quot; &nbsp;PHYSICAL &quot;SALUTATION&quot; &nbsp;DATATYPE 
        C STRING(24)<br>
        COLUMN &quot;ADDRESS1&quot; &nbsp; &nbsp;PHYSICAL &quot;ADDRESS1&quot; 
        &nbsp; &nbsp;DATATYPE C STRING(30)<br>
        COLUMN &quot;ADDRESS2&quot; &nbsp; &nbsp;PHYSICAL &quot;ADDRESS2&quot; 
        &nbsp; &nbsp;DATATYPE C STRING(30)<br>
        COLUMN &quot;CITY&quot; &nbsp; &nbsp; &nbsp; &nbsp;PHYSICAL &quot;CITY&quot; 
        &nbsp; &nbsp; &nbsp; &nbsp;DATATYPE C STRING(20)<br>
        COLUMN &quot;STATE&quot; &nbsp; &nbsp; &nbsp; PHYSICAL &quot;STATE&quot; 
        &nbsp; &nbsp; &nbsp; DATATYPE C STRING(2)<br>
        COLUMN &quot;POSTAL_CODE&quot; PHYSICAL &quot;POSTAL_CODE&quot; DATATYPE 
        C STRING(10)<br>
        COLUMN &quot;COUNTRY&quot; &nbsp; &nbsp; PHYSICAL &quot;COUNTRY&quot; 
        &nbsp; &nbsp; DATATYPE C STRING(20)<br>
        COLUMN &quot;PHONE_NO&quot; &nbsp; &nbsp;PHYSICAL &quot;PHONE_NO&quot; 
        &nbsp; &nbsp;DATATYPE C STRING(18)<br>
        COLUMN &quot;FAX_NO&quot; &nbsp; &nbsp; &nbsp;PHYSICAL &quot;FAX_NO&quot; 
        &nbsp; &nbsp; &nbsp;DATATYPE C STRING(20)<br>
        COLUMN &quot;AKA_COMPANY&quot; PHYSICAL &quot;AKA_COMPANY&quot; DATATYPE 
        C STRING(20)<br>
        COLUMN &quot;COMMENTS&quot; &nbsp; &nbsp;PHYSICAL &quot;COMMENTS&quot; 
        &nbsp; &nbsp;DATATYPE C STRING(60)<br>
        COLUMN &quot;LICENSEE&quot; &nbsp; &nbsp;PHYSICAL &quot;LICENSEE&quot; 
        &nbsp; &nbsp;DATATYPE INTEGER</p>
      <p class="ex"><br>
        TABLE &nbsp; &nbsp;&quot;INVENTORY&quot;<br>
        TYPE &nbsp; &nbsp; &nbsp;RELATIONAL<br>
        PHYSICAL &quot;ORDERS.dbo.INVENTORY&quot;</p>
      <p class="ex"> COLUMN &quot;PRODUCT_NO&quot; PHYSICAL &quot;PRODUCT_NO&quot; 
        DATATYPE C STRING(12)<br>
        COLUMN &quot;INV_DATE&quot; &nbsp; PHYSICAL &quot;INV_DATE&quot; &nbsp; 
        DATATYPE ODBC DATETIME<br>
        COLUMN &quot;INV_QTY&quot; &nbsp; &nbsp;PHYSICAL &quot;INV_QTY&quot; &nbsp; 
        &nbsp;DATATYPE INTEGER<br>
        COLUMN &quot;INV_COST&quot; &nbsp; PHYSICAL &quot;INV_COST&quot; &nbsp;&nbsp;DATATYPE 
        INTEGER<br>
        COLUMN &quot;INV_LOC&quot; &nbsp; &nbsp;PHYSICAL &quot;INV_LOC&quot; &nbsp; 
        &nbsp;DATATYPE C STRING(16)<br>
        COLUMN &quot;INVID&quot; &nbsp; &nbsp; &nbsp;PHYSICAL &quot;INVID&quot; 
        &nbsp; &nbsp;&nbsp; DATATYPE INTEGER<br>
        USAGE AUTO ROWID</p>
      <p class="ex"><br>
        TABLE &nbsp; &nbsp;&quot;ORDERS&quot;<br>
        TYPE &nbsp; &nbsp; &nbsp;RELATIONAL<br>
        PHYSICAL &quot;ORDERS.dbo.ORDERS&quot;<br>
        FOREIGN KEY &quot;CUSTOMER_NO&quot; REFERENCES &quot;CUSTOMERS&quot;(&quot;CUSTOMER_NO&quot;)</p>
      <p class="ex"> COLUMN &quot;CUSTOMER_NO&quot; PHYSICAL &quot;CUSTOMER_NO&quot; 
        DATATYPE INTEGER<br>
        COLUMN &quot;PRODUCT_NO&quot; &nbsp;PHYSICAL &quot;PRODUCT_NO&quot; &nbsp;DATATYPE 
        C STRING(12)<br>
        COLUMN &quot;ORDER_DATE&quot; &nbsp;PHYSICAL &quot;ORDER_DATE&quot; &nbsp;DATATYPE 
        ODBC DATETIME<br>
        COLUMN &quot;STATUS&quot; &nbsp; &nbsp; &nbsp;PHYSICAL &quot;STATUS&quot; 
        &nbsp; &nbsp; &nbsp;DATATYPE C STRING(4)<br>
        COLUMN &quot;QUANTITY&quot; &nbsp; &nbsp;PHYSICAL &quot;QUANTITY&quot; 
        &nbsp; &nbsp;DATATYPE INTEGER<br>
        COLUMN &quot;AMOUNT&quot; &nbsp; &nbsp; &nbsp;PHYSICAL &quot;AMOUNT&quot; 
        &nbsp; &nbsp; &nbsp;DATATYPE INTEGER<br>
        COLUMN &quot;ORDERID&quot; &nbsp; &nbsp; PHYSICAL &quot;ORDERID&quot; 
        &nbsp; &nbsp; DATATYPE INTEGER<br>
        USAGE AUTO ROWID</p>
      <p class="ex"><br>
        TABLE &nbsp; &nbsp;&quot;PRODUCTS&quot;<br>
        TYPE &nbsp; &nbsp; &nbsp;RELATIONAL<br>
        PHYSICAL &quot;ORDERS.dbo.PRODUCTS&quot;<br>
        PRIMARY KEY &quot;PRODUCT_NO&quot;</p>
      <p class="ex"> COLUMN &quot;PRODUCT_NO&quot; &nbsp; &nbsp;PHYSICAL &quot;PRODUCT_NO&quot; 
        &nbsp; &nbsp;DATATYPE C STRING(12)<br>
        USAGE ROWID<br>
        COLUMN &quot;PRODUCT_CLASS&quot; PHYSICAL &quot;PRODUCT_CLASS&quot; DATATYPE 
        C STRING(20)<br>
        COLUMN &quot;PRODUCT_NAME&quot; &nbsp;PHYSICAL &quot;PRODUCT_NAME&quot; 
        &nbsp;DATATYPE C STRING(40)<br>
        COLUMN &quot;SALES_PRICE&quot; &nbsp; PHYSICAL &quot;SALES_PRICE&quot; 
        &nbsp; DATATYPE INTEGER<br>
        COLUMN &quot;PRODUCT_COST&quot; &nbsp;PHYSICAL &quot;PRODUCT_COST&quot; 
        &nbsp;DATATYPE INTEGER</p>
      <p class="ex"><br>
        INDEX &quot;PKCUSTOMERNO&quot;<br>
        TYPE &nbsp; NATIVE SORTED<br>
        AS &nbsp; &nbsp;&quot;CUSTOMERS.CUSTOMER_NO&quot;<br>
        UNIQUE</p>
      <p class="ex">INDEX &quot;PKPRODUCTNO&quot;<br>
        TYPE &nbsp; NATIVE SORTED<br>
        AS &nbsp; &nbsp;&quot;PRODUCTS.PRODUCT_NO&quot;<br>
        UNIQUE</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <!-- InstanceEndEditable --><P align="right"><a href="#">Top</a> </P>
	  </td>
  </tr>
  <tr>
    <td width="175" class="bbar">
<p>&nbsp;</p></td>
    <td align="right" valign="middle" class="bbar"> <p class="banner">Omnidex 
        Version 4.1 Build 1 - E10.04 - Dynamic Information Systems Corporation 
        - Copyright &copy; 2004</p></td>
  </tr>
</table>
<div class="menu0" id="m1" onMouseOver="changeClass('menu1','m1'); changeVisibility('visible','s1');" onMouseOut="changeClass('menu0','m1'); changeVisibility('hidden','s1');"> 
  <a href="../../index.htm">Home</a></div>      
<div class="menu0" id="m2" onMouseOver="changeClass('menu1','m2'); changeVisibility('visible','s2');" onMouseOut="changeClass('menu0','m2'); changeVisibility('hidden','s2');"> 
  <a href="../../Omnidex%20Concepts/Omnidex%20Overview.htm">Omnidex</a></div>      
<div class="menu0" id="m3" onMouseOver="changeClass('menu1','m3'); changeVisibility('visible','s3');" onMouseOut="changeClass('menu0','m3'); changeVisibility('hidden','s3');"> 
  <a href="../../Getting%20Started/Getting%20Started.htm">Getting Started </a></div>      
<div class="menu0" id="m4" onMouseOver="changeClass('menu1','m4'); changeVisibility('visible','s4');" onMouseOut="changeClass('menu0','m4'); changeVisibility('hidden','s4');"> 
  <a href="../../Development/Development.htm">Development</a></div>      
<div class="menu0" id="m5" onMouseOver="changeClass('menu1','m5'); changeVisibility('visible','s5');" onMouseOut="changeClass('menu0','m5'); changeVisibility('hidden','s5');"> 
  <a href="../../Utilities/Utilities.htm">Utilities</a></div>      
<div class="menu0" id="m6" onMouseOver="changeClass('menu1','m6'); changeVisibility('visible','s6');" onMouseOut="changeClass('menu0','m6'); changeVisibility('hidden','s6');"> 
  <a href="../../Appendix/Appendix.htm">Appendix</a></div>
    <td>&nbsp;</td>
  </tr>
</table> 
<table id="s1" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m1'); changeVisibility('visible','s1');" onMouseOut="changeClass('menu0','m1'); changeVisibility('hidden','s1');">
  <tr> 
    <td id="s11" class="menu1" onMouseOver="changeClass('menu0','s11');" onMouseOut="changeClass('menu1','s11');"><a href="../../Whats%20New.htm">What's 
      New!</a></td>
  </tr>
  <tr> 
    <td id="s12" class="menu1" onMouseOver="changeClass('menu0','s12');" onMouseOut="changeClass('menu1','s12');"><a href="../../Quick%20Links.htm">Quick 
      Links</a></td>
  </tr>
  <tr> 
    <td id="s13" class="menu1" onMouseOver="changeClass('menu0','s13');" onMouseOut="changeClass('menu1','s13');"><a href="../../Contents.htm">Contents</a></td>
  </tr>
</table>
<table id="s2" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m2'); changeVisibility('visible','s2');" onMouseOut="changeClass('menu0','m2'); changeVisibility('hidden','s2');">
  <tr> 
    <td id="s21" class="menu1" onMouseOver="changeClass('menu0','s21');" onMouseOut="changeClass('menu1','s21');"><a href="../../Omnidex%20Concepts/Features/Features.htm">Features</a></td>
  </tr>
  <tr> 
    <td id="s22" class="menu1" onMouseOver="changeClass('menu0','s22');" onMouseOut="changeClass('menu1','s22');"><a href="../../Omnidex%20Concepts/Indexing%20Strategies/Indexing%20Strategies.htm">Indexing 
      Strategies</a></td>
  </tr>
  <tr> 
    <td id="s23" class="menu1" onMouseOver="changeClass('menu0','s23');" onMouseOut="changeClass('menu1','s23');"><a href="../../Omnidex%20Concepts/Indexing%20Options/Indexing%20Options.htm">Indexing 
      Options </a></td>
  </tr>
  <tr> 
    <td id="s24" class="menu1" onMouseOver="changeClass('menu0','s24');" onMouseOut="changeClass('menu1','s24');"><a href="../../Omnidex%20Concepts/Index%20Maintenance/Index%20Maintenance.htm">Index 
      Maintenance </a></td>
  </tr>
  <tr> 
    <td id="s25" class="menu1" onMouseOver="changeClass('menu0','s25');" onMouseOut="changeClass('menu1','s25');"><a href="../../Omnidex%20Concepts/Partitioning/Partitioning.htm">Optimization</a></td>
  </tr>
  <tr> 
    <td id="s26" class="menu1" onMouseOver="changeClass('menu0','s26');" onMouseOut="changeClass('menu1','s26');"><a href="../../Omnidex%20Concepts/Index%20Maintenance/Index%20Maintenance.htm">Partitioning</a></td>
  </tr>
  <tr> 
    <td id="s27" class="menu1" onMouseOver="changeClass('menu0','s27');" onMouseOut="changeClass('menu1','s27');"><a href="../../Omnidex%20Concepts/Text/Omnidex%20Text.htm">Omnidex Text</a></td>
  </tr>
</table>
<table id="s3" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m3'); changeVisibility('visible','s3');" onMouseOut="changeClass('menu0','m3'); changeVisibility('hidden','s3');">
  <tr> 
    <td id="s31" class="menu1" onMouseOver="changeClass('menu0','s31');" onMouseOut="changeClass('menu1','s31');"><a href="../../Getting%20Started/1%20-%20Installation%20and%20Setup.htm">Server 
      Setup Guides</a></td>
  </tr>
  <tr> 
    <td id="s32" class="menu1" onMouseOver="changeClass('menu0','s32');" onMouseOut="changeClass('menu1','s32');"><a href="../../Getting%20Started/Omnidex%20Client/Windows%20Client.htm">Windows 
      Client</a></td>
  </tr>
  <tr> 
    <td id="s33" class="menu1" onMouseOver="changeClass('menu0','s33');" onMouseOut="changeClass('menu1','s33');"><a href="../../Database%20Platforms/Supported%20Database%20Platforms.htm">Database 
      Platforms </a></td>
  </tr>
  <tr> 
    <td id="s34" class="menu1" onMouseOver="changeClass('menu0','s34');" onMouseOut="changeClass('menu1','s34');"><a href="../../Environment%20Catalog/Environment%20Catalog.htm">Environment 
      Catalog</a> </td>
  </tr>
</table>
<table id="s4" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m4'); changeVisibility('visible','s4');" onMouseOut="changeClass('menu0','m4'); changeVisibility('hidden','s4');">
  <tr> 
    <td id="s41" class="menu1" onMouseOver="changeClass('menu0','s41');" onMouseOut="changeClass('menu1','s41');"><a href="../../SQL%20Reference/SQL%20Reference.htm">SQL 
      Reference</a> </td>
  </tr>
  <tr> 
    <td id="s42" class="menu1" onMouseOver="changeClass('menu0','s42');" onMouseOut="changeClass('menu1','s42');"><a href="../../Development/ODBC/ODBC.htm">ODBC</a></td>
  </tr>
  <tr> 
    <td id="s43" class="menu1" onMouseOver="changeClass('menu0','s43');" onMouseOut="changeClass('menu1','s43');"><a href="../../Development/JDBC/JDBC.htm">JDBC</a></td>
  </tr>
  <tr> 
    <td id="s44" class="menu1" onMouseOver="changeClass('menu0','s44');" onMouseOut="changeClass('menu1','s44');"><a href="../../Development/OmniAccess%20API/OmniAccess%20API.htm">OmniAccess 
      API</a></td>
  </tr>
  <tr> 
    <td id="s45" class="menu1" onMouseOver="changeClass('menu0','s45');" onMouseOut="changeClass('menu1','s45');"><a href="../../Development/Debugging/OMNIDEX_DEBUG.htm">Debugging</a></td>
  </tr>
</table>
<table id="s5" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m5'); changeVisibility('visible','s5');" onMouseOut="changeClass('menu0','m5'); changeVisibility('hidden','s5');">
  <tr> 
    <td id="s51" class="menu1" onMouseOver="changeClass('menu0','s51');" onMouseOut="changeClass('menu1','s51');"><A href="../../Utilities/DBINSTAL/DBINSTAL.htm">DBINSTAL</A></td>
  </tr>
  <tr> 
    <td id="s52" class="menu1" onMouseOver="changeClass('menu0','s52');" onMouseOut="changeClass('menu1','s52');"><a href="../../Utilities/DSEDIT/DSEDIT.htm">DSEDIT</a></td>
  </tr>
  <tr> 
    <td id="s53" class="menu1" onMouseOver="changeClass('menu0','s53');" onMouseOut="changeClass('menu1','s53');"><a href="../../Utilities/NSADMIN/NSADMIN.htm">NSADMIN</a></td>
  </tr>
  <tr> 
    <td id="s54" class="menu1" onMouseOver="changeClass('menu0','s54');" onMouseOut="changeClass('menu1','s54');"><a href="../../Utilities/OACOMP/OACOMP.htm">OACOMP</a></td>
  </tr>
  <tr> 
    <td id="s55" class="menu1" onMouseOver="changeClass('menu0','s55');" onMouseOut="changeClass('menu1','s55');"><a href="../../Utilities/OADECOMP/OADECOMP.htm">OADECOMP</a></td>
  </tr>
  <tr> 
    <td id="s56" class="menu1" onMouseOver="changeClass('menu0','s56');" onMouseOut="changeClass('menu1','s56');"><a href="../../Utilities/OAHELPER/OAHELPER.htm">OAHELPER</a></td>
  </tr>
  <tr> 
    <td id="s57" class="menu1" onMouseOver="changeClass('menu0','s57');" onMouseOut="changeClass('menu1','s57');"><A href="../../Utilities/ODXAIM/ODXAIM.htm">ODXAIM</A></td>
  </tr>
  <tr> 
    <td id="s58" class="menu1" onMouseOver="changeClass('menu0','s58');" onMouseOut="changeClass('menu1','s58');"><a href="../../Utilities/ODXMAKE/ODXMAKE.htm">ODXMAKE</a></td>
  </tr>
  <tr> 
    <td id="s59" class="menu1" onMouseOver="changeClass('menu0','s59');" onMouseOut="changeClass('menu1','s59');"><a href="../../Utilities/ODXNET/ODXNET.htm">ODXNET</a></td>
  </tr>
  <tr> 
    <td id="s510" class="menu1" onMouseOver="changeClass('menu0','s510');" onMouseOut="changeClass('menu1','s510');"><A href="../../Utilities/ODXQUERY/ODXQUERY.htm">ODXQUERY</A></td>
  </tr>
  <tr> 
    <td id="s511" class="menu1" onMouseOver="changeClass('menu0','s511');" onMouseOut="changeClass('menu1','s511');"><a href="../../Utilities/ODXSQL/ODXSQL.htm">ODXSQL</a></td>
  </tr>
  <tr> 
    <td id="s512" class="menu1" onMouseOver="changeClass('menu0','s512');" onMouseOut="changeClass('menu1','s512');"><a href="../../Utilities/REGMAINT/REGMAINT.htm">REGMAINT</a></td>
  </tr>
  <tr> 
    <td id="s513" class="menu1" onMouseOver="changeClass('menu0','s513');" onMouseOut="changeClass('menu1','s513');"><A href="../../Utilities/REGTEST/REGTEST.htm">REGTEST</A></td>
  </tr>
  <tr> 
    <td id="s514" class="menu1" onMouseOver="changeClass('menu0','s514');" onMouseOut="changeClass('menu1','s514');"><a href="../../Utilities/SNOWGEN/SNOWGEN.htm">SNOWGEN</a></td>
  </tr>
  <tr> 
    <td id="s515" class="menu1" onMouseOver="changeClass('menu0','s515');" onMouseOut="changeClass('menu1','s515');"><a href="../../Utilities/SYSINFO/SYSINFO.htm">SYSINFO</a></td>
  </tr>
  <tr> 
    <td id="s516" class="menu1" onMouseOver="changeClass('menu0','s516');" onMouseOut="changeClass('menu1','s516');"><a href="../../Utilities/VERSIONS/VERSIONS.htm">VERSIONS</a></td>
  </tr>
  <tr> 
    <td id="s517" class="menu1" onMouseOver="changeClass('menu0','s517');" onMouseOut="changeClass('menu1','s517');"><a href="../../Utilities/VIEWGEN/VIEWGEN.htm">VIEWGEN</a></td>
  </tr>
</table>
<table id="s6" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m6'); changeVisibility('visible','s6');" onMouseOut="changeClass('menu0','m6'); changeVisibility('hidden','s6');">
  <tr> 
    <td id="s61" class="menu1" onMouseOver="changeClass('menu0','s61');" onMouseOut="changeClass('menu1','s61');"><a href="../../Appendix/Cardinality.htm">Cardinality</a></td>
  </tr>
  <tr> 
    <td id="s62" class="menu1" onMouseOver="changeClass('menu0','s62');" onMouseOut="changeClass('menu1','s62');"><a href="../../Appendix/Date%20Formats.htm">Date 
      Formats </a></td>
  </tr>
  <tr> 
    <td id="s63" class="menu1" onMouseOver="changeClass('menu0','s63');" onMouseOut="changeClass('menu1','s63');"><a href="../../Appendix/Environment%20Variables.htm">Environment 
      Variables </a></td>
  </tr>
  <tr> 
    <td id="s64" class="menu1" onMouseOver="changeClass('menu0','s64');" onMouseOut="changeClass('menu1','s64');"><a href="../../Appendix/File%20Name%20Handling.htm">File 
      Name Handling</a></td>
  </tr>
  <tr> 
    <td id="s65" class="menu1" onMouseOver="changeClass('menu0','s65');" onMouseOut="changeClass('menu1','s65');"><a href="../../Appendix/Glossary%20A.htm">Glossary</a></td>
  </tr>
  <tr> 
    <td id="s66" class="menu1" onMouseOver="changeClass('menu0','s66');" onMouseOut="changeClass('menu1','s66');"><a href="../../Appendix/Null.htm">Null</a></td>
  </tr>
  <tr> 
    <td id="s67" class="menu1" onMouseOver="changeClass('menu0','s67');" onMouseOut="changeClass('menu1','s67');"><a href="../../Appendix/OAGLOBAL.htm">OAGLOBAL</a></td>
  </tr>
  <tr> 
    <td id="s68" class="menu1" onMouseOver="changeClass('menu0','s68');" onMouseOut="changeClass('menu1','s68');"><a href="../../Appendix/Operating%20Limits.htm">Operating 
      Limits</a></td>
  </tr>
  <tr> 
    <td id="s69" class="menu1" onMouseOver="changeClass('menu0','s69');" onMouseOut="changeClass('menu1','s69');"><a href="../../Appendix/Provided%20Managed%20Synonym%20Lists.htm">Managed 
      Synonym Lists</a></td>
  </tr>
  <tr> 
    <td id="s70" class="menu1" onMouseOver="changeClass('menu0','s70');" onMouseOut="changeClass('menu1','s70');"><a href="../../Appendix/Reserved%20Words.htm">Reserved 
      Words</a></td>
  </tr>
  <tr> 
    <td id="s71" class="menu1" onMouseOver="changeClass('menu0','s71');" onMouseOut="changeClass('menu1','s71');"><a href="../../Appendix/Supported%20Datatypes.htm">Supported 
      Data Types</a></td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
<!-- InstanceEnd --></html>
