<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="../../Templates/DocTemp.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Partitioning - ODXSQL Examples</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>Partitioning</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="Example1.htm#column">By Column </a></p>
      <p><a href="Example1.htm#equal">Into Equal Partitions</a></p>
      <p><a href="Example1.htm#equalcolumn">By Column into Equal Partitions</a></p>
      <p><a href="Example2.htm#validation">Using a Validation Column</a></p>
      <p><a href="Example2.htm#expressions">Using Expressions</a></p>
      <p><a href="Example3.htm">Generate Environment File Entry</a></p>
      <p><a href="Example4.htm">Indexes</a></p>
      <p class="line">&nbsp;</p>
      <p><a href="Partitioning.htm">Partitioning</a></p>
      <p><a href="Partitioning.htm#limits"><img src="../../images/blank.gif" width="15" height="10" border="0">Limitations</a></p>
      <p><a href="Partitioning.htm#updates"><img src="../../images/blank.gif" width="15" height="10" border="0">Data 
        Updates</a></p>
      <p><a href="Analysis.htm">1. Analysis</a></p>
      <p><a href="Partition%20the%20Table.htm">2. Partition the Table</a></p>
      <p> <a href="Environment%20File.htm">3. Environment File Entry</a></p>
      <p><a href="Indexing.htm">4. Indexing</a></p>
      <p><a href="Example1.htm">Examples</a></p>
      <!-- InstanceEndEditable --></td>
    <td valign="top" class="content"> <!-- InstanceBeginEditable name="Content" --> 
      <h2 class="line">Example - Environment File</h2>
      <p><a href="Example1.htm"><img src="../../images/arrow2.gif" width="10" height="10" border="0">Other 
        Partitioning Examples</a></p>
      <p><a href="Environment%20File.htm"><img src="../../images/arrow2.gif" width="10" height="10" border="0">Environment 
        File</a></p>
      <p>The following example shows partitioning a table using the ODXSQL PARTITION 
        command and the <a href="#entry">environment file entry (below)</a> generated 
        for the partition using the ENVIRONMENTSNIPPET=filename WITH otpion.</p>
      <p> </p>
      <p class="ex">&gt;partition orders into 5 by product_no in dat with environmentsnippet=ordenv.src<br>
        Partitioned 200 rows into 5 partitions</p>
      <p class="ex">&gt;view partition.rpt</p>
      <p>&nbsp;</p>
      <table width="90%" border="0" cellspacing="0" cellpadding="0">
        <tr align="center"> 
          <td colspan="5"> <p class="ex">OmniAccess Partitioning Report<br>
            </p></td>
        </tr>
        <tr> 
          <td><p class="ex">Database:<br>
              Table:<br>
              Approach: </p></td>
          <td colspan="4"><p class="ex">Star:<br>
              Orders:<br>
              200 rows split by PRODUCT_NO into 5 equal partitions<br>
            </p></td>
        </tr>
        <tr> 
          <td><p class="ex">Partition Value<br>
              -----------------</p></td>
          <td align="right"> <p class="ex">Cardinality<br>
              -------------</p></td>
          <td align="right"> <p class="ex">Valid<br>
              -------</p></td>
          <td align="right"> <p class="ex">Total %<br>
              ---------</p></td>
          <td align="right"> <p class="ex">Valid %<br>
              ---------</p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS01<br>
              H672<br>
              H100<br>
              A940<br>
              HL6P<br>
              MPOP</p></td>
          <td align="right"> <p class="ex">40<br>
              9<br>
              9<br>
              8<br>
              8<br>
              6</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">20.000%<br>
              4.500%<br>
              4.500%<br>
              4.000%<br>
              4.000%<br>
              4.000%</p></td>
          <td align="right"> <p class="ex">20.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
            </p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS02<br>
              G523<br>
              DM20<br>
              P900<br>
              G520<br>
              IC9S<br>
              T750</p></td>
          <td align="right"> <p class="ex">39<br>
              7<br>
              7<br>
              7<br>
              7<br>
              6<br>
              5</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">19.500%<br>
              3.500%<br>
              3.500%<br>
              3.500%<br>
              3.500%<br>
              3.000%<br>
              2.500%</p></td>
          <td align="right"> <p class="ex">20.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
            </p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS03<br>
              B290<br>
              B390<br>
              B455<br>
              P225<br>
              HO30<br>
              H400<br>
              P224<br>
              B190<br>
              BRSP<br>
            </p></td>
          <td align="right"> <p class="ex">40<br>
              5<br>
              5<br>
              5<br>
              5<br>
              5<br>
              5<br>
              4<br>
              4<br>
              2<br>
            </p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">20.000%<br>
              2.500%<br>
              2.500%<br>
              2.500%<br>
              2.500%<br>
              2.500%<br>
              2.500%<br>
              2.000%<br>
              2.000%<br>
              1.000%<br>
            </p></td>
          <td align="right"> <p class="ex">20.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
            </p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS04<br>
              H736<br>
              N820<br>
              N972<br>
              PH65<br>
              S100<br>
              OSER<br>
              HPMP<br>
              EDMP<br>
              DM23<br>
              C478<br>
              3MTP<br>
              GEHE</p></td>
          <td align="right"> <p class="ex">40<br>
              4<br>
              4<br>
              4<br>
              4<br>
              4<br>
              3<br>
              3<br>
              3<br>
              3<br>
              3<br>
              3<br>
              2</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">20.000%<br>
              2.000%<br>
              2.000%<br>
              2.000%<br>
              2.000%<br>
              2.000%<br>
              1.500%<br>
              1.500%<br>
              1.500%<br>
              1.500%<br>
              1.500%<br>
              1.500%<br>
              1.000%</p></td>
          <td align="right"> <p class="ex">20.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%</p></td>
        </tr>
        <tr> 
          <td><p class="ex">ORDERS05<br>
              P160<br>
              L722<br>
              HLTC<br>
              L433<br>
              3SAD<br>
              MTAC<br>
              3DST<br>
              PBSP<br>
              SCFP<br>
              CGPP<br>
              BTCT<br>
              SSST<br>
              SWFL<br>
              AEWP<br>
              OSTC<br>
              AQPP<br>
              GTLC<br>
              3RGS<br>
              3P23<br>
              BMLF<br>
              PDMP<br>
              PGMP<br>
              BMED<br>
              XPCP<br>
              S25P<br>
              SCDR<br>
              ACPC<br>
              ADLB<br>
              AAWP<br>
              GUOC<br>
              MMRB</p></td>
          <td align="right"> <p class="ex">41<br>
              3<br>
              3<br>
              2<br>
              2<br>
              2<br>
              2<br>
              2<br>
              2<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1<br>
              1</p></td>
          <td align="right"> <p class="ex">&nbsp;</p></td>
          <td align="right"> <p class="ex">20.500%<br>
              1.500%<br>
              1.500%<br>
              1.000%<br>
              1.000%<br>
              1.000%<br>
              1.000%<br>
              1.000%<br>
              1.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%</p></td>
          <td align="right"> <p class="ex">20.500%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%<br>
              0.000%</p></td>
        </tr>
        <tr> 
          <td><p class="ex">-----------------<br>
              Total</p></td>
          <td align="right"> <p class="ex">-------------<br>
              200</p></td>
          <td align="right"> <p class="ex">-------</p></td>
          <td align="right"> <p class="ex">---------<br>
              100.00%</p></td>
          <td align="right"> <p class="ex">---------<br>
              100.00%</p></td>
        </tr>
        <tr> 
          <td colspan="2"><p class="ex">End of report</p></td>
          <td align="right"><p class="ex">&nbsp;</p></td>
          <td align="right"><p class="ex">&nbsp;</p></td>
          <td align="right"><p class="ex">&nbsp;</p></td>
        </tr>
        <tr align="center"> 
          <td colspan="5"><p class="ex">---------------- End of file --------------</p></td>
        </tr>
      </table>
      <p>&nbsp;</p>
      <p class="line">&nbsp;</p>
      <p class="ex"> <a name="entry" id="entry"></a>&gt; view ordenv.src</p>
      <p></p>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td> <p class="ex">table<br>
            </p></td>
          <td><p class="ex">&quot;ORDERS&quot;</p></td>
          <td><p>&nbsp;</p></td>
        </tr>
        <tr> 
          <td valign="top"> <p class="ex"><img src="../../images/blank.gif" width="10" height="10">as</p></td>
          <td colspan="2" valign="top"> <p class="ex">&quot;select * from ORDERS01 
              union all<br>
              <img src="../../images/blank.gif" width="8" height="10">select * 
              from ORDERS02 union all<br>
              <img src="../../images/blank.gif" width="8" height="10">select * 
              from ORDERS03 union all<br>
              <img src="../../images/blank.gif" width="8" height="10">select * 
              from ORDERS04 union all<br>
              <img src="../../images/blank.gif" width="8" height="10">select * 
              from ORDERS05&quot;</p></td>
        </tr>
        <tr> 
          <td valign="top"> <p class="ex">column &quot;ACCT&quot;<br>
              column &quot;PRODUCT_NO&quot;<br>
              column &quot;ORDER_DATE&quot;<br>
              column &quot;STATUS&quot;<br>
              column &quot;TAX_STATE&quot;<br>
              column &quot;SOURCE&quot; <br>
              column &quot;PMT_METHOD&quot;<br>
              column &quot;DISCOUNT&quot;<br>
              column &quot;QUANTITY&quot;<br>
              column &quot;SALES_TAX&quot;<br>
              column &quot;AMOUNT&quot;<br>
              column &quot;TOTAL&quot;</p></td>
          <td valign="top"> <p class="ex">datatype INTEGER<br>
              datatype CHARACTER<br>
              datatype OMNIDEX DATE<br>
              datatype CHARACTER<br>
              datatype CHARACTER<br>
              datatype INTEGER<br>
              datatype INTEGER<br>
              datatype INTEGER<br>
              datatype INTEGER<br>
              datatype FLOAT<br>
              datatype FLOAT<br>
              datatype FLOAT <br>
            </p></td>
          <td valign="top"> <p class="ex">length 4<br>
              length 4<br>
              length 4 format YYYYMMDD<br>
              length 2<br>
              length 2<br>
              length 1<br>
              length 1<br>
              length 1<br>
              length 1<br>
              length 4<br>
              length 4<br>
              length 4</p></td>
        </tr>
        <tr> 
          <td valign="top"> <p class="ex">table<br>
              physical</p>
            <p class="ex"> partition by<br>
            </p></td>
          <td colspan="2" valign="top"> <p class="ex">&quot;ORDERS01&quot;<br>
              &quot;dat\orders01.dat&quot;</p>
            <p class="ex">&quot;PRODUCT_NO in ('H672','H100','A940','HL6P','MPOP')&quot;</p></td>
        </tr>
        <tr> 
          <td valign="top"> <p class="ex">foreign &quot;ACCT&quot;<br>
              foreign &quot;PRODUCT_NO&quot;<br>
              foreign &quot;ORDER_DATE&quot;<br>
              foreign &quot;STATUS&quot;<br>
              foreign &quot;TAX_STATE&quot;<br>
              foreign &quot;SOURCE&quot; <br>
              foreign &quot;PMT_METHOD&quot;</p></td>
          <td colspan="2" valign="top"> <p class="ex">references &quot;PROSPECTS&quot; 
              (&quot;ACCT&quot;)<br>
              references &quot;PRODUCTS&quot; (&quot;PRODUCT_NO&quot;)<br>
              references &quot;DATES&quot; (&quot;DT&quot;)<br>
              references &quot;STATUSES&quot; (&quot;STATUS&quot;)<br>
              references &quot;STATES&quot; (&quot;STATE&quot;)<br>
              references &quot;SOURCES&quot; (&quot;SOURCE&quot;)<br>
              references &quot;PMT_METHODS&quot; (&quot;PMT_METHOD&quot;) </p></td>
        </tr>
        <tr> 
          <td valign="top"> <p class="ex">table<br>
              physical</p>
            <p class="ex"> partition by<br>
            </p></td>
          <td colspan="2" valign="top"> <p class="ex">&quot;ORDERS02&quot;<br>
              &quot;dat\orders02.dat&quot;</p>
            <p class="ex">&quot;PRODUCT_NO in ('G523','DM20','P900','G520','IC9S','T750')&quot;</p></td>
        </tr>
        <tr> 
          <td width="200" valign="top"> <p class="ex">foreign &quot;ACCT&quot;<br>
              foreign &quot;PRODUCT_NO&quot;<br>
              foreign &quot;ORDER_DATE&quot;<br>
              foreign &quot;STATUS&quot;<br>
              foreign &quot;TAX_STATE&quot;<br>
              foreign &quot;SOURCE&quot; <br>
              foreign &quot;PMT_METHOD&quot;</p></td>
          <td colspan="2" valign="top"> <p class="ex">references &quot;PROSPECTS&quot; 
              (&quot;ACCT&quot;)<br>
              references &quot;PRODUCTS&quot; (&quot;PRODUCT_NO&quot;)<br>
              references &quot;DATES&quot; (&quot;DT&quot;)<br>
              references &quot;STATUSES&quot; (&quot;STATUS&quot;)<br>
              references &quot;STATES&quot; (&quot;STATE&quot;)<br>
              references &quot;SOURCES&quot; (&quot;SOURCE&quot;)<br>
              references &quot;PMT_METHODS&quot; (&quot;PMT_METHOD&quot;) </p></td>
        </tr>
        <tr> 
          <td valign="top"> <p class="ex">table<br>
              physical</p>
            <p class="ex"> partition by<br>
            </p></td>
          <td colspan="2" valign="top"> <p class="ex">&quot;ORDERS03&quot;<br>
              &quot;dat\orders03.dat&quot;</p>
            <p class="ex">&quot;PRODUCT_NO in ('B290','B390','B455','P225', 'HO30','H400','P224','B190','BRSP')&quot;</p></td>
        </tr>
        <tr> 
          <td valign="top"> <p class="ex">foreign &quot;ACCT&quot;<br>
              foreign &quot;PRODUCT_NO&quot;<br>
              foreign &quot;ORDER_DATE&quot;<br>
              foreign &quot;STATUS&quot;<br>
              foreign &quot;TAX_STATE&quot;<br>
              foreign &quot;SOURCE&quot; <br>
              foreign &quot;PMT_METHOD&quot;</p></td>
          <td colspan="2" valign="top"> <p class="ex">references &quot;PROSPECTS&quot; 
              (&quot;ACCT&quot;)<br>
              references &quot;PRODUCTS&quot; (&quot;PRODUCT_NO&quot;)<br>
              references &quot;DATES&quot; (&quot;DT&quot;)<br>
              references &quot;STATUSES&quot; (&quot;STATUS&quot;)<br>
              references &quot;STATES&quot; (&quot;STATE&quot;)<br>
              references &quot;SOURCES&quot; (&quot;SOURCE&quot;)<br>
              references &quot;PMT_METHODS&quot; (&quot;PMT_METHOD&quot;) </p></td>
        </tr>
        <tr> 
          <td valign="top"> <p class="ex">table<br>
              physical</p>
            <p class="ex"> partition by<br>
            </p></td>
          <td colspan="2" valign="top"> <p class="ex">&quot;ORDERS04&quot;<br>
              &quot;dat\orders04.dat&quot;</p>
            <p class="ex">&quot;PRODUCT_NO in ('H736','N820','N972','PH65','S100','OSER', 
              'HPMP','EDMP','DM23','C478','3MTP','GEHE')&quot;</p></td>
        </tr>
        <tr> 
          <td valign="top"> <p class="ex">foreign &quot;ACCT&quot;<br>
              foreign &quot;PRODUCT_NO&quot;<br>
              foreign &quot;ORDER_DATE&quot;<br>
              foreign &quot;STATUS&quot;<br>
              foreign &quot;TAX_STATE&quot;<br>
              foreign &quot;SOURCE&quot; <br>
              foreign &quot;PMT_METHOD&quot;</p></td>
          <td colspan="2" valign="top"> <p class="ex">references &quot;PROSPECTS&quot; 
              (&quot;ACCT&quot;)<br>
              references &quot;PRODUCTS&quot; (&quot;PRODUCT_NO&quot;)<br>
              references &quot;DATES&quot; (&quot;DT&quot;)<br>
              references &quot;STATUSES&quot; (&quot;STATUS&quot;)<br>
              references &quot;STATES&quot; (&quot;STATE&quot;)<br>
              references &quot;SOURCES&quot; (&quot;SOURCE&quot;)<br>
              references &quot;PMT_METHODS&quot; (&quot;PMT_METHOD&quot;) </p></td>
        </tr>
        <tr> 
          <td valign="top"> <p class="ex">table<br>
              physical</p>
            <p class="ex"> partition by<br>
            </p></td>
          <td colspan="2" valign="top"> <p class="ex">&quot;ORDERS05&quot;<br>
              &quot;dat\orders05.dat&quot;</p>
            <p class="ex">&quot;PRODUCT_NO in ('P160','L722','HLTC','L433','3SAD','MTAC','3DST',<br>
              'PBSP','SCFP','CGPP','BTCT','SSST','SWFL','AEWP',<br>
              'OSTC','AQPP','GTLC', '3RGS','3P23','BMLF','PDMP',<br>
              'PGMP','BMED','XPCP','S25P','SCDR','ACPC','ADLB',<br>
              'AAWP','GUOC','MMRB')&quot;</p></td>
        </tr>
        <tr> 
          <td valign="top"> <p class="ex">foreign &quot;ACCT&quot;<br>
              foreign &quot;PRODUCT_NO&quot;<br>
              foreign &quot;ORDER_DATE&quot;<br>
              foreign &quot;STATUS&quot;<br>
              foreign &quot;TAX_STATE&quot;<br>
              foreign &quot;SOURCE&quot; <br>
              foreign &quot;PMT_METHOD&quot;</p></td>
          <td colspan="2" valign="top"> <p class="ex">references &quot;PROSPECTS&quot; 
              (&quot;ACCT&quot;)<br>
              references &quot;PRODUCTS&quot; (&quot;PRODUCT_NO&quot;)<br>
              references &quot;DATES&quot; (&quot;DT&quot;)<br>
              references &quot;STATUSES&quot; (&quot;STATUS&quot;)<br>
              references &quot;STATES&quot; (&quot;STATE&quot;)<br>
              references &quot;SOURCES&quot; (&quot;SOURCE&quot;)<br>
              references &quot;PMT_METHODS&quot; (&quot;PMT_METHOD&quot;) </p></td>
        </tr>
      </table>
      <p class="line">&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>
