<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="../../../Templates/DocTemp.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>ODXSQL - Commands - EXTRACT</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>ODXSQL - Commands</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="#syntax">Syntax</a></p>
      <p><a href="#options">Options</a></p>
      <p><a href="#example">Example</a></p>
      <p class="line">&nbsp;</p>
      <p><a href="../ODXSQL.htm">ODXSQL</a></p>
      <p><a href="../ODXSQL.htm#characters">Special Characters</a></p>
      <p><a href="../ODXSQL.htm#system">System Commands</a></p>
      <p><a href="../ODXSQL.htm#help">Getting Help</a></p>
      <p><a href="../Commands.htm">Commands</a></p>
      <!-- InstanceEndEditable --></td>
    <td valign="top" class="content"> <!-- InstanceBeginEditable name="Content" --> 
      <h2>EXTRACT</h2>
      <p>The EXTRACT command in OdxSQL is used to transform data in a database 
        into SQL statements. INSERT, UPDATE and DELETE statements are generated 
        from existing data for each row and output to a file. </p>
      <p>The purpose of this command is to allow a database to be restored to 
        its original state after temporary changes have been made to the data, 
        without actually making a physical copy of the entire database.</p>
      <p>The output file can be executed in ODXSQL as a USE file to restore the 
        data to its original state.</p>
      <p>The default output file is extract.sql.</p>
      <p> <img src="../../../images/note.gif" width="12" height="15" align="left">The 
        ODXSQL EXTRACT command is not the same as the <a href="../../../SQL%20Reference/Functions/EXTRACT.htm">EXTRACT 
        SQL function</a>.</p>
      <p> </p>
      <p>The SQL statement is limited to a maximum of 65536 characters; therefore, 
        this statement can only be applied against result sets that fit within 
        this limit. For example, flat file row ids are usually integers, which 
        would allow about 10000 entries in this statement. However, Oracle row 
        ids are considerably larger and therefore, limited to considerably fewer 
        entries. An error will occur if all of the qualified rowids will not fit.</p>
      <p class="line">&nbsp;</p>
      <h3><a name="syntax"></a>Syntax</h3>
      <p class="ex">EXTRACT sql_statement_type FROM table(s) [WHERE criteria] 
        [TO filename] [ON [INSTANCE] instancenumber] [WITH options]</p>
      <p class="indent">EXTRACT<br>
        Required.</p>
      <p class="indent">sql_statement_type<br>
        Type of statements to extract. See <a href="#types">Statement Types</a> 
        (below) for more information.</p>
      <p class="indent">FROM table(s)<br>
        Required. table(s) is a comma separated list of table names, as defined 
        in the Omnidex Environment file. The FROM keyword is required.</p>
      <p class="indent">WHERE criteria<br>
        Optional. Limit the extract to a specific set of records. Criteria is 
        any supported SQL where clause criteria. The WHERE keyword is required 
        if a WHERE clause is used.</p>
      <p class="indent">TO filename<br>
        Optional. Filename is the output filespec, fully qualified or relative. 
        If omitted, the default, extract.sql, will be created in the current working 
        directory. The TO keyword is required if the output file is specified.</p>
      <p class="indent">ON INSTANCE instancenumber<br>
        Optional. Specify the instance on which to perform the extract. instancenumber 
        is the integer instance number created when the connection to the Environment 
        file was opened. If omitted, the current instance contained in the instance 
        element of the Status array will be used. The INSTANCE keyword is optional. 
        The ON keyword is required if the instance is specified.</p>
      <p class="indent">WITH options<br>
        Optional. A comma separated list of options to apply to this command. 
      </p>
      <p class="line">&nbsp;</p>
      <h3><a name="types"></a>Statement Types</h3>
      <p>The OdxSQL EXTRACT command can extract three different types of SQL statements: 
        INSERTS, UPDATES, and DELETES.</p>
      <p class="indent"><strong>INSERTS</strong> causes an SQL INSERT statement 
        to be generated for each row as determined by the criteria. An SQL INSERT 
        statement is generated for every row in the table that matches the criteria. 
        This statement can be used to populate an empty copy of the database, 
        or restore the data if the rows were deleted.</p>
      <p class="ex">EXTRACT INSERTS FROM CUSTOMERS</p>
      <p class="indent"><strong>UPDATES</strong> causes an SQL UPDATE statement 
        to be generated for each row as determined by the criteria. An SQL UPDATE 
        statement is generated for every row in the table that matches the criteria. 
        This statement can be used to restore rows to their original value.</p>
      <p class="ex">EXTRACT UPDATES FROM CUSTOMERS</p>
      <p class="indent"><strong>DELETES</strong> causes one delete statement to 
        be generated in the form:<br>
        DELETE FROM table WHERE NOT IN (rowid1, rowid2, ...)<br>
        The DELETE statement contains the rowid for every row that was in the 
        table prior to the changes and will delete any row that was added (rowid 
        not in the list) since the statement was generated.</p>
      <p class="ex">EXTRACT DELETES FROM CUSTOMERS</p>
      <p></p>
      <h3>&nbsp; </h3>
      <p class="line">&nbsp;</p>
      <h3><a name="options"></a>Options</h3>
      <p>&nbsp;</p>
      <p class="line">&nbsp;</p>
      <h3><a name="example"></a>Example</h3>
      <p>The following example extracts all three types of statements to the default 
        extract.sql, using criteria.</p>
      <p class="ex">&gt;extract inserts, updates, deletes from customers where 
        state='co' and company='systems'</p>
      <p class="ex">&gt;</p>
      <h6>Three records qualified for this statement. Following are the contents 
        of extract.sql which was created in the current working directory:</h6>
      <p class="ex">; ***************************************************************<br>
        ; SQL produced by ODXSQL's EXTRACT command on Tue Nov 06 09:26:28 2001<br>
        ; ***************************************************************</p>
      <p>A connect is included but commented out.</p>
      <p class="ex">; connect to C:\omnidex\Demodata\orders.env</p>
      <p>A single DELETE statement is created to delete every record except the 
        three qualified by the original extract criteria.</p>
      <p class="ex">delete from &quot;customers&quot; \<br>
        where not $ROWID in ('1', '341', '863')</p>
      <p>Three INSERT statements are created, one for each record qualified by 
        the original extract criteria, to allow the original records to be duplicated.</p>
      <p class="ex">insert into &quot;customers&quot; \<br>
        (&quot;CUSTOMER_NO&quot;, &quot;COMPANY&quot;, &quot;CONTACT&quot;, &quot;TITLE&quot;, 
        &quot;SALUTATION&quot;, \<br>
        &quot;ADDRESS1&quot;, &quot;ADDRESS2&quot;, &quot;CITY&quot;, &quot;STATE&quot;, 
        &quot;POSTAL_CODE&quot;, \<br>
        &quot;COUNTRY&quot;, &quot;PHONE_NO&quot;, &quot;FAX_NO&quot;, &quot;AKA_COMPANY&quot;, 
        &quot;COMMENTS&quot;, \<br>
        &quot;LICENSEE&quot;) \<br>
        values (1, 'Dynamic Information Systems Corporation', \<br>
        'Mark S. Trasko', 'President', 'Mr.', '5733 Central Avenue', \<br>
        '', 'Boulder', 'CO', '80301', 'USA', '303 444-4000 x1300', \<br>
        '303 444-2230', 'DISC MST', \<br>
        'Sample prospect record for entry and annotation', 1)</p>
      <p class="ex">insert into &quot;customers&quot; \<br>
        (&quot;CUSTOMER_NO&quot;, &quot;COMPANY&quot;, &quot;CONTACT&quot;, &quot;TITLE&quot;, 
        &quot;SALUTATION&quot;, \<br>
        &quot;ADDRESS1&quot;, &quot;ADDRESS2&quot;, &quot;CITY&quot;, &quot;STATE&quot;, 
        &quot;POSTAL_CODE&quot;, \<br>
        &quot;COUNTRY&quot;, &quot;PHONE_NO&quot;, &quot;FAX_NO&quot;, &quot;AKA_COMPANY&quot;, 
        &quot;COMMENTS&quot;, \<br>
        &quot;LICENSEE&quot;) \<br>
        values (343, 'Summit Information Systems', 'Mark Polando', \<br>
        'Sales Rep', 'Mr.', '4130 North 26th Street', '', 'Boulder', \<br>
        'CO', '80304', 'USA', '800 937-7500 (656)', '', '', \<br>
        'Develop HP3000 credit union application - Corp. in Corvallis',\<br>
        0)</p>
      <p class="ex">insert into &quot;customers&quot; \<br>
        (&quot;CUSTOMER_NO&quot;, &quot;COMPANY&quot;, &quot;CONTACT&quot;, &quot;TITLE&quot;, 
        &quot;SALUTATION&quot;, \<br>
        &quot;ADDRESS1&quot;, &quot;ADDRESS2&quot;, &quot;CITY&quot;, &quot;STATE&quot;, 
        &quot;POSTAL_CODE&quot;, \<br>
        &quot;COUNTRY&quot;, &quot;PHONE_NO&quot;, &quot;FAX_NO&quot;, &quot;AKA_COMPANY&quot;, 
        &quot;COMMENTS&quot;, \<br>
        &quot;LICENSEE&quot;) \<br>
        values (867, 'Mini-Computer Systems', 'Phil Norisez', '', 'Ms.', \<br>
        '2336 Canyon', 'Suite 201', 'Boulder', 'CO', '80302', 'USA', \<br>
        '303 443-3347', '', '', 'Macroscope', 0)</p>
      <p>Three UPDATE statements, one for each record qualified by the original 
        extract criteria, are created to allow these records to be restored to 
        their original state.</p>
      <p class="ex">update &quot;customers&quot; \<br>
        set &quot;CUSTOMER_NO&quot; = 1, &quot;COMPANY&quot; = \<br>
        'Dynamic Information Systems Corporation', &quot;CONTACT&quot; = \<br>
        'Mark S. Trasko', &quot;TITLE&quot; = 'President', &quot;SALUTATION&quot; 
        = 'Mr.', \<br>
        &quot;ADDRESS1&quot; = '5733 Central Avenue', &quot;ADDRESS2&quot; = '', 
        &quot;CITY&quot; = \<br>
        'Boulder', &quot;STATE&quot; = 'CO', &quot;POSTAL_CODE&quot; = '80301', 
        &quot;COUNTRY&quot; \<br>
        = 'USA', &quot;PHONE_NO&quot; = '303 444-4000 x1300', &quot;FAX_NO&quot; 
        = \<br>
        '303 444-2230', &quot;AKA_COMPANY&quot; = 'DISC MST', &quot;COMMENTS&quot; 
        = \<br>
        'Sample prospect record for entry and annotation', &quot;LICENSEE&quot; 
        \<br>
        = 1 \<br>
        where $ROWID = '1'</p>
      <p class="ex">update &quot;customers&quot; \<br>
        set &quot;CUSTOMER_NO&quot; = 343, &quot;COMPANY&quot; = 'Summit Information 
        Systems', \<br>
        &quot;CONTACT&quot; = 'Mark Polando', &quot;TITLE&quot; = 'Sales Rep', 
        \<br>
        &quot;SALUTATION&quot; = 'Mr.', &quot;ADDRESS1&quot; = '4130 North 26th 
        Street', \<br>
        &quot;ADDRESS2&quot; = '', &quot;CITY&quot; = 'Boulder', &quot;STATE&quot; 
        = 'CO', \<br>
        &quot;POSTAL_CODE&quot; = '80304', &quot;COUNTRY&quot; = 'USA', &quot;PHONE_NO&quot; 
        = \<br>
        '800 937-7500 (656)', &quot;FAX_NO&quot; = '', &quot;AKA_COMPANY&quot; 
        = '', \<br>
        &quot;COMMENTS&quot; = \<br>
        'Develop HP3000 credit union application - Corp. in Corvallis',\<br>
        &quot;LICENSEE&quot; = 0 \<br>
        where $ROWID = '341'</p>
      <p class="ex">update &quot;customers&quot; \<br>
        set &quot;CUSTOMER_NO&quot; = 867, &quot;COMPANY&quot; = 'Mini-Computer 
        Systems', \<br>
        &quot;CONTACT&quot; = 'Phil Norisez', &quot;TITLE&quot; = '', &quot;SALUTATION&quot; 
        = \<br>
        'Ms.', &quot;ADDRESS1&quot; = '2336 Canyon', &quot;ADDRESS2&quot; = 'Suite 
        201', \<br>
        &quot;CITY&quot; = 'Boulder', &quot;STATE&quot; = 'CO', &quot;POSTAL_CODE&quot; 
        = '80302', \<br>
        &quot;COUNTRY&quot; = 'USA', &quot;PHONE_NO&quot; = '303 443-3347', &quot;FAX_NO&quot; 
        = '', \<br>
        &quot;AKA_COMPANY&quot; = '', &quot;COMMENTS&quot; = 'Macroscope', &quot;LICENSEE&quot; 
        = 0 \<br>
        where $ROWID = '863'</p>
      <p>A disconnect statement is included but is also commented out.</p>
      <p class="ex">; disconnect</p>
      <p></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.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="../../DBINSTAL/DBINSTAL.htm">DBINSTAL</A></td>
  </tr>
  <tr> 
    <td id="s52" class="menu1" onMouseOver="changeClass('menu0','s52');" onMouseOut="changeClass('menu1','s52');"><a href="../../DSEDIT/DSEDIT.htm">DSEDIT</a></td>
  </tr>
  <tr> 
    <td id="s53" class="menu1" onMouseOver="changeClass('menu0','s53');" onMouseOut="changeClass('menu1','s53');"><a href="../../NSADMIN/NSADMIN.htm">NSADMIN</a></td>
  </tr>
  <tr> 
    <td id="s54" class="menu1" onMouseOver="changeClass('menu0','s54');" onMouseOut="changeClass('menu1','s54');"><a href="../../OACOMP/OACOMP.htm">OACOMP</a></td>
  </tr>
  <tr> 
    <td id="s55" class="menu1" onMouseOver="changeClass('menu0','s55');" onMouseOut="changeClass('menu1','s55');"><a href="../../OADECOMP/OADECOMP.htm">OADECOMP</a></td>
  </tr>
  <tr> 
    <td id="s56" class="menu1" onMouseOver="changeClass('menu0','s56');" onMouseOut="changeClass('menu1','s56');"><a href="../../OAHELPER/OAHELPER.htm">OAHELPER</a></td>
  </tr>
  <tr> 
    <td id="s57" class="menu1" onMouseOver="changeClass('menu0','s57');" onMouseOut="changeClass('menu1','s57');"><A href="../../ODXAIM/ODXAIM.htm">ODXAIM</A></td>
  </tr>
  <tr> 
    <td id="s58" class="menu1" onMouseOver="changeClass('menu0','s58');" onMouseOut="changeClass('menu1','s58');"><a href="../../ODXMAKE/ODXMAKE.htm">ODXMAKE</a></td>
  </tr>
  <tr> 
    <td id="s59" class="menu1" onMouseOver="changeClass('menu0','s59');" onMouseOut="changeClass('menu1','s59');"><a href="../../ODXNET/ODXNET.htm">ODXNET</a></td>
  </tr>
  <tr> 
    <td id="s510" class="menu1" onMouseOver="changeClass('menu0','s510');" onMouseOut="changeClass('menu1','s510');"><A href="../../ODXQUERY/ODXQUERY.htm">ODXQUERY</A></td>
  </tr>
  <tr> 
    <td id="s511" class="menu1" onMouseOver="changeClass('menu0','s511');" onMouseOut="changeClass('menu1','s511');"><a href="../ODXSQL.htm">ODXSQL</a></td>
  </tr>
  <tr> 
    <td id="s512" class="menu1" onMouseOver="changeClass('menu0','s512');" onMouseOut="changeClass('menu1','s512');"><a href="../../REGMAINT/REGMAINT.htm">REGMAINT</a></td>
  </tr>
  <tr> 
    <td id="s513" class="menu1" onMouseOver="changeClass('menu0','s513');" onMouseOut="changeClass('menu1','s513');"><A href="../../REGTEST/REGTEST.htm">REGTEST</A></td>
  </tr>
  <tr> 
    <td id="s514" class="menu1" onMouseOver="changeClass('menu0','s514');" onMouseOut="changeClass('menu1','s514');"><a href="../../SNOWGEN/SNOWGEN.htm">SNOWGEN</a></td>
  </tr>
  <tr> 
    <td id="s515" class="menu1" onMouseOver="changeClass('menu0','s515');" onMouseOut="changeClass('menu1','s515');"><a href="../../SYSINFO/SYSINFO.htm">SYSINFO</a></td>
  </tr>
  <tr> 
    <td id="s516" class="menu1" onMouseOver="changeClass('menu0','s516');" onMouseOut="changeClass('menu1','s516');"><a href="../../VERSIONS/VERSIONS.htm">VERSIONS</a></td>
  </tr>
  <tr> 
    <td id="s517" class="menu1" onMouseOver="changeClass('menu0','s517');" onMouseOut="changeClass('menu1','s517');"><a href="../../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>
