<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="../../Templates/DocTemp.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>OmniAccess API - Managing Data</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>OmniAccess API</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="#largelist">Managing Large Lists of Rows</a></p>
      <p><a href="#cursors">Managing Data Across Several Cursors</a></p>
      <p><a href="#convert">Convert Data Types Through oaselect_list</a></p>
      <p><a href="#oaselectlist">oaselect_list</a></p>
      <p><a href="#criteria">Undetermined Criteria</a></p>
      <p class="line">&nbsp;</p>
      <p><a href="OmniAccess%20API.htm">OmniAccess API</a></p>
      <p><a href="Programming%20Basics.htm">Programming Basics</a></p>
      <p>Managing Data</p>
      <p><a href="Functions.htm">Functions</a></p>
      <p>&nbsp;</p>
      <!-- InstanceEndEditable --></td>
    <td valign="top" class="content"> <!-- InstanceBeginEditable name="Content" --> 
      <h2>Managing Data</h2>
      <ul>
        <li><a href="#largelist">Managing Large Lists of Rows</a></li>
        <li><a href="#cursors">Managing Data Across Several Cursors</a></li>
        <li><a href="#convert">Convert Data Types Through oaselect_list</a></li>
        <li><a href="#oaselectlist">oaselect_list</a></li>
        <li><a href="#criteria">Undetermined Criteria</a></li>
      </ul>
      <p class="line">&nbsp;</p>
      <h3><a name="largelist"></a>Managing Large Lists of Rows</h3>
      <p>oaassignvalues provides the mechanism to pass any number of search values 
        in repeated executions of an oafetch loop. This mechanism can be used 
        to effectively break down one oversized array of search values into several 
        smaller, manageable arrays. oafetch can also be incorporated into the 
        loop to support forward and backward reads through a list of qualified 
        rows.</p>
      <p>The data parameter of oaassignvalues contains the actual data to pass 
        to the $VALUES buffer. Each value contained in data is assumed to be of 
        the defined type and length of the column on the left side of the $VALUES 
        expression in oaselect&#8217;s criteria parameter. For example, if the 
        criteria parameter contains the expression CUSTOMER_NO IN $VALUES, and 
        CUSTOMER_NO is defined as TYPE INTEGER LENGTH 2 in the environment catalog, 
        oaselect assumes that the values in the data parameter of oaassignvalues 
        are also TYPE INTEGER LENGTH 2 (two-byte signed integers).</p>
      <p>The num_values parameter tells oaassignvalues how many elements (values) 
        data contains. Based on this information, as well as the number provided 
        in the oaselect $VALUES declaration, oafetch can use the criteria to retrieve 
        rows.</p>
      <p>The labels parameter tells oaassignvalues which $VALUES token to use 
        if there are several $VALUES tokens on the oaselect criteria expression. 
        When using more than one $VALUES token in a call to oaselect, a different 
        $VALUES label must first be assigned for each $VALUES token. oaassignvalues 
        must be called once for each $VALUES token in the oaselect expression 
        before calling oafetch.</p>
      <p class="line">&nbsp;</p>
      <h3><a name="cursors"></a>Managing Data Across Several Cursors</h3>
      <p>Sometimes it is necessary to transfer data across cursors to complete 
        a search. </p>
      <p>For example, a separate environment catalog may be maintained for each 
        department in an organization. </p>
      <p>Account information may be managed in one environment catalog, while 
        customer order information is managed in another.</p>
      <p>So, to place a hold on all deliveries to customers with delinquent accounts, 
        the accounting environment catalog (ACCTEC) would be searched first, for 
        all customers who are three months in arrears. </p>
      <p>Then the order entry environment catalog (CUSTEC) would be searched for 
        customer rows using the account numbers qualified in the ACCTEC environment.</p>
      <p class="line">&nbsp;</p>
      <h3><a name="convert"></a>Convert Data Types Through oaselect_list</h3>
      <p>To declare a select item as a different type than its default or defined 
        type in the Omnidex environment catalog, you must pass its new type through 
        the <a href="#oaselectlist">oaselect_list</a> parameter of oabind. </p>
      <p>The datatype element contains an integer value representing the default 
        data type. To convert the data into a different data type, specify an 
        integer value representing the data type you want in the req_datatype 
        element. </p>
      <p>&nbsp;</p>
      <p class="line">&nbsp;</p>
      <h3><a name="oaselectlist"></a>oaselect_list</h3>
      <p>oaselect_list is a type declaration for the OmniAccess select list control 
        blocks. These control blocks are used exclusively by the oadescribe and 
        oabind functions.</p>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td colspan="2"><p class="ex">typedef struct oaselect_list<br>
              { </p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">int</p></td>
          <td><p class="ex">type;</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">int</p></td>
          <td><p class="ex">subtype;</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">union<br>
              <img src="../../images/blank.gif" width="20" height="10">{ </p></td>
          <td><p class="ex">&nbsp;</p></td>
        </tr>
        <tr> 
          <td> <p class="ex"><img src="../../images/blank.gif" width="40" height="10">char</p></td>
          <td><p class="ex">expression[132];</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="40" height="10">char</p></td>
          <td><p class="ex">literal[132];</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="40" height="10">char</p></td>
          <td><p class="ex">numeric[36];</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="40" height="10">struct<br>
              <img src="../../images/blank.gif" width="40" height="10">{ </p></td>
          <td><p class="ex">&nbsp;</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="60" height="10">char</p></td>
          <td><p class="ex">environment[33];</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="60" height="10">char</p></td>
          <td><p class="ex">database[33];</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="60" height="10">char</p></td>
          <td><p class="ex">table[33];</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="60" height="10">char</p></td>
          <td><p class="ex">column[33];</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="40" height="10">} 
              column; </p></td>
          <td><p class="ex">&nbsp;</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">} 
              select_item;</p></td>
          <td><p class="ex">&nbsp;</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">char</p></td>
          <td><p class="ex">alias[36];</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">int</p></td>
          <td><p class="ex">datatype;</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">int</p></td>
          <td><p class="ex">length;</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">int</p></td>
          <td><p class="ex">usage;</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">int</p></td>
          <td><p class="ex">occurrences;</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">int</p></td>
          <td><p class="ex">offset;</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">char</p></td>
          <td><p class="ex">options[64];</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">int</p></td>
          <td><p class="ex">req_datatype;</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">int</p></td>
          <td><p class="ex">req_length;</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">int</p></td>
          <td><p class="ex">req_usage;</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">int</p></td>
          <td><p class="ex">req_offset;</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">char</p></td>
          <td><p class="ex">req_options[64];</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">char</p></td>
          <td><p class="ex">*data;</p></td>
        </tr>
        <tr> 
          <td><p class="ex"><img src="../../images/blank.gif" width="20" height="10">int</p></td>
          <td><p class="ex">*null_indicator;</p></td>
        </tr>
        <tr> 
          <td><P class="ex">} oaselect_list_t;</p></td>
          <td><p>&nbsp;</p></td>
        </tr>
      </table>
      <p class="line">&nbsp;</p>
      <h3><a name="criteria"></a>Undetermined Criteria</h3>
      <p>oaassignvalues can be used to apply criteria that is not previously known. 
      </p>
      <p>For example, the criteria for a query (query2) may actually be the results 
        of another query (query1). </p>
      <p>Query1 may select the customer numbers from the Orders table, for all 
        canceled orders.</p>
      <p>Query2 then selects the company name, contact, and phone number from 
        the Customers table for the customer numbers that were returned from query1. 
      </p>
      <p>In this case, the results of query1 are placed in the $VALUES buffer 
        and used in the WHERE clause of query 2, WHERE customer_no in $VALUES.</p>
      <p>Another example would be an online application that allows the user to 
        specify multiple criteria. The criteria is not known until the user makes 
        their choices. The criteria choices are placed into the $VALUES buffer 
        and applied to the query in the WHERE clause.</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.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="../ODBC/ODBC.htm">ODBC</a></td>
  </tr>
  <tr> 
    <td id="s43" class="menu1" onMouseOver="changeClass('menu0','s43');" onMouseOut="changeClass('menu1','s43');"><a href="../JDBC/JDBC.htm">JDBC</a></td>
  </tr>
  <tr> 
    <td id="s44" class="menu1" onMouseOver="changeClass('menu0','s44');" onMouseOut="changeClass('menu1','s44');"><a href="../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="../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>
