<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="../Templates/DocTemp.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Untitled Document</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>SELECT Statement</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="#where">WHERE clause</a></p>
      <p><a href="#from">EXISTS clause</a> </p>
      <p><a href="#from">FROM clause</a></p>
      <p><a href="#having">HAVING clause</a></p>
      <p><a href="#selectitem">Select-item</a></p>
      <p><a href="#limits">Limitations</a></p>
      <p class="line">&nbsp;</p>
      <p><a href="SQL%20Reference.htm">SQL Reference</a></p>
      <p><a href="SELECT%20Statement/SELECT%20Statement.htm">SELECT Statement</a></p>
      <p><a href="Joins.htm">Joins</a></p>
      <p>Nested Queries</p>
      <p><a href="SET%20Operations.htm">Set Operations</a></p>
      <p><a href="ON%20CURSOR%20ON%20INSTANCE.htm">ON CURSOR | INSTANCE</a></p>
      <p><a href="WITH%20Options.htm">WITH Options</a></p>
      <p><a href="Commands.htm">Commands</a></p>
      <p><a href="Functions.htm">Functions</a></p>
      <!-- InstanceEndEditable --></td>
    <td valign="top" class="content"> <!-- InstanceBeginEditable name="Content" --> 
      <h2>Nested Queries</h2>
      <p>Nested queries are supported five different places within a SELECT statement: 
      </p>
      <ul>
        <li><a href="#where">WHERE clause</a></li>
        <li><a href="#from">EXISTS clause within a WHERE clause</a></li>
        <li><a href="#from">FROM clause</a></li>
        <li><a href="#having">HAVING clause</a></li>
        <li><a href="#selectitem">Select-item in the SQL SELECT item list</a></li>
        <li><a href="#limits">Limitations</a></li>
      </ul>
      <p>Omnidex may behave differently depending on the location of the nested 
        query. See <a href="../Omnidex%20Concepts/Optimization/Nested%20Queries.htm">Nested 
        Queries</a> in the <a href="../Omnidex%20Concepts/Optimization/Optimization.htm">Optimization</a> 
        section for more details on how Omnidex behaves in different scenarios.</p>
      <p class="line">&nbsp;</p>
      <h3><a name="where"></a>WHERE Clause</h3>
      <p>The most common nested query is found in the WHERE clause. The subquery 
        results are applied as the right operand in a WHERE clause predicate. 
      </p>
      <p>WHERE clause predicates that use subqueries that return a single value 
        can use comparison operators (=, &lt;, &gt;, &lt;=, &gt;=, &lt;&gt;, !=, 
        like).</p>
      <p class="ex">WHERE left_operand = subquery_result </p>
      <p>WHERE clause predicates that use subqueries that return one or more values 
        can use an IN clause. </p>
      <p class="ex">WHERE left_operand IN (subquery_results)</p>
      <h5>Example</h5>
      <p>WHERE clause allows aggregation to become criteria for the outer query.</p>
      <p class="ex">SELECT * FROM orders WHERE total &gt; (SELECT AVG(total) FROM 
        orders)</p>
      <p>Nested query prevents cartesian product between two child tables.</p>
      <p class="ex">SELECT p.acct, p.company, a.dt, a.tickler, a.initials FROM 
        prospects p, activity a<br>
        WHERE p.acct = a.acct AND <br>
        p.acct IN (SELECT DISTINCT acct FROM orders WHERE quantity &gt; 1)</p>
      <p class="line">&nbsp;</p>
      <h3><a name="exists"></a>EXISTS Clause Within a WHERE Clause</h3>
      <p>The result of an EXISTS clause as a WHERE clause predicate, is a boolean. 
        If the subquery returns any results, the EXISTS clause evaluates to TRUE, 
        otherwise it is FALSE. No data is returned by the subquery.</p>
      <p class="ex">WHERE EXIST(subquery)</p>
      <h5>Example</h5>
      <p>Return the product number only if there is at least one in inventory.</p>
      <p class="ex">SELECT PRODUCT_NO FROM PRODUCTS WHERE PRODUCT_NO = 'H672' 
        AND <br>
        EXISTS (SELECT PRODUCT_NO FROM INVENTORY WHERE PRODUCT_NO = 'H672')</p>
      <p> Return account and company name from prospects only if there is at least 
        one record in the orders table for that prospect.</p>
      <p class="ex">SELECT acct, company FROM prospects<br>
        WHERE acct = 1 and<br>
        EXISTS (SELECT acct FROM orders WHERE acct = 1)</p>
      <p class="line">&nbsp;</p>
      <h3><a name="from"></a>FROM Clause</h3>
      <p>A subquery in a FROM clause uses the results of a subquery as a table. 
        The results of the nested query will be output to an OST (Omnidex Stand-Alone 
        Table), then the outer query will be resolved using the OST.</p>
      <p class="ex">SELECT * FROM (subquery_results) ...</p>
      <p>Because OSTs are not indexed, criteria used in the outer query will not 
        be optimized and must be specified as such, ie. case sensitive. </p>
      <p>However, the inner query will be optimized as much as possible. This 
        can be useful for reducing the amount of data that will be used in certain 
        operations.</p>
      <h5>Example</h5>
      <p>The inner query totals the sales for products and groups them by customer 
        number and product number. This portion of the query is optimized because 
        of aggregation indexes installed on the orders table. The results are 
        output to an OST. </p>
      <p>The outer query displays the product number and performs the min and 
        max aggregations against the sales totals from the inner query, grouped 
        by the product number. Because indexes cannot be installed on an OST, 
        this portion of the query is not optimized. It is still fast, however, 
        because a large portion of the aggregation and sorting were performed 
        in the inner query using the aggregation indexes.</p>
      <p class="ex">SELECT b.product_no, max(b.order_amount), min(b.order_amount) 
        <br>
        FROM (SELECT product_no, sum(amount) order_amount <br>
        FROM orders GROUP BY customer_no, product_no) AS b <br>
        GROUP BY a.company</p>
      <p class="line">&nbsp;</p>
      <h3><a name="having"></a>HAVING Clause</h3>
      <p>A nested query can be in a HAVING clause. HAVING clause criteria is processed 
        after the outer query results have been returned. The nested query must 
        return a single column. Can use comparison operators if only a single 
        value will be returned or an IN clause if multiple values could be returned.</p>
      <p class="ex">HAVING left_operand &gt; subquery_result</p>
      <p class="ex">HAVING left_operand in (subquery_results)</p>
      <h5>Example</h5>
      <p>The inner query returns the average total from all orders in the orders 
        table. The outer query returns the account number and average total from 
        the orders table, grouped by the account number. The HAVING clause filters 
        the results of the outer query using the result from the inner query. 
        Both the inner and outer query are optimized.</p>
      <p class="ex">SELECT acct, AVG(total) FROM orders GROUP BY acct<br>
        HAVING AVG(total) &gt; (SELECT AVG(total) FROM orders)</p>
      <p class="line">&nbsp;</p>
      <h3><a name="selectitem"></a>Select-Item</h3>
      <p>A nested query can be used as a select-item. The nested query <strong>must 
        return a single column and a single row</strong>. </p>
      <p class="ex">SELECT select-item, (SELECT select-item FROM table WHERE criteria) 
        FROM table</p>
      <p>Omnidex will not attempt to verify that the nested query results pertain 
        to the outer query results. The queries should be constructed to assure 
        that the results of the subquery are meaningful to the outer query. For 
        example:</p>
      <p class="ex">SELECT status, order_no, <br>
        (SELECT company FROM customers WHERE customer_no = 1) <br>
        FROM orders <br>
        WHERE customer_no = 2.</p>
      <p>This statement is structurally valid but meaningless. The results of 
        the inner query have nothing to do with the outer query results, but the 
        statement will succeed.</p>
      <h5>Example</h5>
      <p>The inner query sums the total column from the orders table for the state 
        of Colorado. The result is converted to a literal and returned as a select 
        item in the outer query. Both queries are optimized.</p>
      <p class="ex">SELECT state, description, (SELECT SUM(total) FROM orders 
        WHERE tax_state = 'CO') FROM states WHERE state='CO'</p>
      <p class="line">&nbsp;</p>
      <h3><a name="limits"></a>Limitations</h3>
      <ul>
        <li> A nested query cannot contain an ORDER BY clause. This is the SQL 
          2 standard, not an Omnidex limitation.</li>
        <li>Correlated subqueries are not supported. A correlated subquery is 
          a nested query that depends on the results from the outer query to complete 
          the inner query. Although correlated subqueries are not supported, they 
          can often be rewritten as joins to achieve the same results.<br>
          Correlated Subquery (not supported),<br>
          <span class="ex">SELECT p.acct, p.company, p.last_order FROM prospects 
          p<br>
          WHERE p.last_order &lt;(SELECT MAX(order_date) FROM orders o WHERE o.acct=p.acct)</span><br>
          can be rewritten as a join.<br>
          <span class="ex">SELECT p.acct, p.company, p.last_order FROM prospects 
          p, orders o<br>
          WHERE p.acct = o.acct<br>
          GROUP BY p.acct, p.company, p.last_order<br>
          HAVING p.last_order &lt; MAX(o.order_date)</span><br>
          Omnidex supports the second statement but not the first.</li>
        <li>Nested queries cannot contain set operations. A set operation is a 
          UNION, INTERSECT, EXCEPT. Support for this ability is planned for a 
          future release.</li>
      </ul>
      <p>&nbsp;</p>
      <p><br>
      </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>
