<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="../Templates/DocTemp.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>SQL Reference - Set Operations</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>SQL Reference</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="#limits">Limitations</a></p>
      <p><a href="#example">Examples</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><a href="Nested%20Queries.htm">Nested Queries</a></p>
      <p>Set Operations</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>Set Operations - UNION, INTERSECT, EXCEPT</h2>
      <p>UNION, INTERSECT and EXCEPT are set operations used to append similar 
        data from disparate sources in a single SQL statement. These set operations 
        are necessary when defining partitions and Union Views in the Omnidex 
        environment file.</p>
      <ul>
        <li>The UNION set operation &quot;unions&quot; or appends two result sets 
          from two separate SQL SELECT statements together, to form a single result 
          set. The ALL keyword causes duplicate values to be repeated. For example:<br>
          <span class="ex">left : {1,3,5,7} right : {2,3,4,5}<br>
          union : {1,2,3,4,5,7}<br>
          union all : {1,2,3,3,4,5,5,7}</span></li>
        <li>The INTERSECT set operation creates a single result set comprised 
          of values that exist in both result sets from two separate SQL SELECT 
          statements. Values that exist in one result set but not the other, are 
          discarded.<br>
          <span class="ex">left : {1,3,5,7} right : {2,3,4,5}<br>
          intersect : {1,3,5}</span></li>
        <li>The EXECEPT set operation creates a single result set comprised of 
          values that exist ONLY in the left SQL SELECT result set. Values that 
          exist in both result sets are discarded, as are all values that exist 
          only in the right result set.<br>
          <span class="ex">left : {1,3,5,7} right : {2,3,4,5}<br>
          except : {1,7}</span></li>
      </ul>
      <p class="line">&nbsp;</p>
      <h3><a name="syntax"></a>Syntax</h3>
      <p class="ex">sql_select_statement <strong>UNION</strong> [ALL] sql_select_statement</p>
      <p class="ex">sql_select_statement <strong>INTERSECT</strong> sql_select_statement</p>
      <p class="ex">sql_select_statement <strong>EXCEPT</strong> sql_select_statement</p>
      <p class="line">&nbsp;</p>
      <h3><a name="limits"></a>Limitations</h3>
      <ul>
        <li>When using set operations, an ORDER BY clause must be only on the 
          last member of the set. The sort order is then applied to the entire 
          set. This limitation is a SQL 2 standard restriction, not specific to 
          Omnidex.</li>
        <li>Each individual member of a set operation is optimized. However, there 
          is no optimization across members of the set.</li>
      </ul>
      <p class="line">&nbsp;</p>
      <h3><a name="example"></a>Examples</h3>
      <p>The next few examples demonstrate the difference in results between UNION, 
        UNION ALL, INTERSECT, and EXCEPT. All examples use the same sql select 
        statements, but the results differ greatly depending on the SET operation 
        used.</p>
      <p>This first example selects distinct account numbers from both the Activity 
        and Orders tables, which are then combined with a UNION ALL statement. 
        The ALL keyword causes duplicate account nuimbers to be repeated. Specifically, 
        the account number 1 occurs in both the Activity and Orders table and 
        is therefore returned twice. The text 'Activity' and 'Orders' are included 
        in the select statement to demonstrate which table the values came from.</p>
      <p class="ex">SELECT DISTINCT 'Activity', acct FROM activity WHERE tickler='RC' 
        <br>
        UNION ALL<br>
        SELECT DISTINCT 'Orders', acct FROM orders WHERE quantity &lt; 3</p>
      <table width="50%" border="0" cellspacing="0" cellpadding="0">
        <tr valign="top"> 
          <td> <p class="ex">ACTIVITY<br>
              -----------</p></td>
          <td> <p class="ex">ACCT<br>
              -------- </p></td>
        </tr>
        <tr valign="top"> 
          <td> <p class="ex">Activity<br>
              Activity<br>
              Orders<br>
              Orders<br>
              Orders </p></td>
          <td> <p class="ex">1<br>
              4<br>
              1<br>
              2<br>
              3</p></td>
        </tr>
      </table>
      <p class="ex"> 5 rows returned</p>
      <p class="line2">&nbsp;</p>
      <p>Like the first example, this example selects distinct account numbers 
        from both the Activity and Orders tables, which are then combined with 
        a UNION statement. The ALL keyword is omitted, causing only distinct values 
        to be returned. The account number 1, which occurs in both the Activity 
        and Orders tables, is only returned once.</p>
      <p class="ex">SELECT DISTINCT acct FROM activity WHERE tickler='RC' <br>
        UNION<br>
        SELECT DISTINCT acct FROM orders WHERE quantity &lt; 3</p>
      <p class="ex">ACCT<br>
        ----------<br>
        1<br>
        2<br>
        3<br>
        4</p>
      <p class="ex"> 4 rows returned</p>
      <p class="line2">&nbsp;</p>
      <p>This next example INTERSECTS the results of the same select statements. 
        This causes only one row to be returned, the account number 1, because 
        this is the only account number that occurs in both the Activity and Orders 
        tables.</p>
      <p class="ex">SELECT DISTINCT acct FROM activity WHERE tickler='RC' <br>
        INTERSECT<br>
        SELECT DISTINCT acct FROM orders WHERE quantity &lt; 3</p>
      <p class="ex">ACCT<br>
        ----------<br>
        1</p>
      <p class="ex"> 1 row returned</p>
      <p class="line2">&nbsp;</p>
      <p>The last two examples use the EXCEPT set operation, which causes only 
        those rows from the first table that do not have matching rows in the 
        second table, to be returned. As we saw in the first example (UNION ALL) 
        above, there are two rows in the Activity table with account numbers 1 
        and 4, and three rows in the Orders table with account numbers 1, 2, 3. 
      </p>
      <p>In this case, the Activity table is first and the Orders table is second. 
        Since account number 4 is the only account number in the Activity table 
        that does not occur in the Orders table, the row with account number 4 
        is the only row returned.</p>
      <p class="ex">SELECT DISTINCT acct FROM activity WHERE tickler='RC' <br>
        EXCEPT<br>
        SELECT DISTINCT acct FROM orders WHERE quantity &lt; 3</p>
      <p class="ex">ACCT<br>
        ----------<br>
        4</p>
      <p class="ex"> 1 row returned</p>
      <p>Now if we switch the order of the select statements, the Orders table 
        is first and the Activity table is second. Account number 1 occurs in 
        both tables so is discarded while, account numbers 2 and 3 occur in the 
        first table (Orders) but not in the second table (Activity), and are therefore 
        returned.</p>
      <p class="ex">SELECT DISTINCT acct FROM orders WHERE quantity &lt; 3<br>
        EXCEPT<br>
        SELECT DISTINCT acct FROM activity WHERE tickler='RC'</p>
      <p class="ex">ACCT<br>
        ----------<br>
        2<br>
        3</p>
      <p class="ex"> 2 rows returned</p>
      <p class="line2">&nbsp;</p>
      <p>The following example shows a UNION ALL statement used to declare the 
        partitioned ORDERS table in an Omnidex Environment file.</p>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td valign="top"> <p class="ex">table<br>
              &nbsp; as </p></td>
          <td colspan="2" valign="top"> <p class="ex">&quot;ORDERS&quot;<br>
              &quot;select * from ORDERS01 UNION ALL<br>
              &nbsp;select * from ORDERS02 UNION ALL<br>
              &nbsp;select * from ORDERS03 UNION ALL<br>
              &nbsp;select * from ORDERS04 UNION ALL<br>
              &nbsp;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>
              ... </p></td>
          <td valign="top"> <p class="ex">datatype INTEGER<br>
              datatype CHARACTER<br>
              ... </p></td>
          <td valign="top"> <p class="ex">length 4<br>
              length 4<br>
              ... </p></td>
        </tr>
        <tr> 
          <td valign="top"> <p class="ex">table <br>
              physical<br>
              partition by<br>
              foreign<br>
              ...<br>
              columns from</p></td>
          <td colspan="2" valign="top"> <p class="ex">&quot;ORDERS01&quot;<br>
              &quot;dat\orders.dat&quot;<br>
              PRODUCT_NO in ('H672','H100','A940','HL6P','MPOP')&quot;<br>
              &quot;ACCT&quot; references &quot;PROSPECTS&quot;(&quot;ACCT&quot;)<br>
              ...<br>
              &quot;ORDERS&quot; </p></td>
        </tr>
        <tr> 
          <td valign="top"> <p class="ex">table <br>
              physical<br>
              partition by<br>
              foreign<br>
              ...<br>
              columns from</p></td>
          <td valign="top"> <p class="ex">&quot;ORDERS02&quot;<br>
              &quot;dat\orders.dat&quot;<br>
              PRODUCT_NO in ('G523','DM20','P900','G520','IC9S','T750')&quot;<br>
              &quot;ACCT&quot; references &quot;PROSPECTS&quot;(&quot;ACCT&quot;)<br>
              ...<br>
              &quot;ORDERS&quot;</p></td>
          <td valign="top"> <p class="ex">&nbsp;</p></td>
        </tr>
        <tr> 
          <td valign="top"> <p class="ex">...</p></td>
          <td valign="top"> <p class="ex">&nbsp;</p></td>
          <td valign="top"> <p class="ex">&nbsp;</p></td>
        </tr>
      </table>
      <p><br>
      </p>
      <p>&nbsp;</p>
      <!-- InstanceEndEditable --><P align="right"><a href="#">Top</a> </P>
	  </td>
  </tr>
  <tr>
    <td width="175" class="bbar">
<p>&nbsp;</p></td>
    <td align="right" valign="middle" class="bbar"> <p class="banner">Omnidex 
        Version 4.1 Build 1 - E10.04 - Dynamic Information Systems Corporation 
        - Copyright &copy; 2004</p></td>
  </tr>
</table>
<div class="menu0" id="m1" onMouseOver="changeClass('menu1','m1'); changeVisibility('visible','s1');" onMouseOut="changeClass('menu0','m1'); changeVisibility('hidden','s1');"> 
  <a href="../index.htm">Home</a></div>      
<div class="menu0" id="m2" onMouseOver="changeClass('menu1','m2'); changeVisibility('visible','s2');" onMouseOut="changeClass('menu0','m2'); changeVisibility('hidden','s2');"> 
  <a href="../Omnidex%20Concepts/Omnidex%20Overview.htm">Omnidex</a></div>      
<div class="menu0" id="m3" onMouseOver="changeClass('menu1','m3'); changeVisibility('visible','s3');" onMouseOut="changeClass('menu0','m3'); changeVisibility('hidden','s3');"> 
  <a href="../Getting%20Started/Getting%20Started.htm">Getting Started </a></div>      
<div class="menu0" id="m4" onMouseOver="changeClass('menu1','m4'); changeVisibility('visible','s4');" onMouseOut="changeClass('menu0','m4'); changeVisibility('hidden','s4');"> 
  <a href="../Development/Development.htm">Development</a></div>      
<div class="menu0" id="m5" onMouseOver="changeClass('menu1','m5'); changeVisibility('visible','s5');" onMouseOut="changeClass('menu0','m5'); changeVisibility('hidden','s5');"> 
  <a href="../Utilities/Utilities.htm">Utilities</a></div>      
<div class="menu0" id="m6" onMouseOver="changeClass('menu1','m6'); changeVisibility('visible','s6');" onMouseOut="changeClass('menu0','m6'); changeVisibility('hidden','s6');"> 
  <a href="../Appendix/Appendix.htm">Appendix</a></div>
    <td>&nbsp;</td>
  </tr>
</table> 
<table id="s1" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m1'); changeVisibility('visible','s1');" onMouseOut="changeClass('menu0','m1'); changeVisibility('hidden','s1');">
  <tr> 
    <td id="s11" class="menu1" onMouseOver="changeClass('menu0','s11');" onMouseOut="changeClass('menu1','s11');"><a href="../Whats%20New.htm">What's 
      New!</a></td>
  </tr>
  <tr> 
    <td id="s12" class="menu1" onMouseOver="changeClass('menu0','s12');" onMouseOut="changeClass('menu1','s12');"><a href="../Quick%20Links.htm">Quick 
      Links</a></td>
  </tr>
  <tr> 
    <td id="s13" class="menu1" onMouseOver="changeClass('menu0','s13');" onMouseOut="changeClass('menu1','s13');"><a href="../Contents.htm">Contents</a></td>
  </tr>
</table>
<table id="s2" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m2'); changeVisibility('visible','s2');" onMouseOut="changeClass('menu0','m2'); changeVisibility('hidden','s2');">
  <tr> 
    <td id="s21" class="menu1" onMouseOver="changeClass('menu0','s21');" onMouseOut="changeClass('menu1','s21');"><a href="../Omnidex%20Concepts/Features/Features.htm">Features</a></td>
  </tr>
  <tr> 
    <td id="s22" class="menu1" onMouseOver="changeClass('menu0','s22');" onMouseOut="changeClass('menu1','s22');"><a href="../Omnidex%20Concepts/Indexing%20Strategies/Indexing%20Strategies.htm">Indexing 
      Strategies</a></td>
  </tr>
  <tr> 
    <td id="s23" class="menu1" onMouseOver="changeClass('menu0','s23');" onMouseOut="changeClass('menu1','s23');"><a href="../Omnidex%20Concepts/Indexing%20Options/Indexing%20Options.htm">Indexing 
      Options </a></td>
  </tr>
  <tr> 
    <td id="s24" class="menu1" onMouseOver="changeClass('menu0','s24');" onMouseOut="changeClass('menu1','s24');"><a href="../Omnidex%20Concepts/Index%20Maintenance/Index%20Maintenance.htm">Index 
      Maintenance </a></td>
  </tr>
  <tr> 
    <td id="s25" class="menu1" onMouseOver="changeClass('menu0','s25');" onMouseOut="changeClass('menu1','s25');"><a href="../Omnidex%20Concepts/Partitioning/Partitioning.htm">Optimization</a></td>
  </tr>
  <tr> 
    <td id="s26" class="menu1" onMouseOver="changeClass('menu0','s26');" onMouseOut="changeClass('menu1','s26');"><a href="../Omnidex%20Concepts/Index%20Maintenance/Index%20Maintenance.htm">Partitioning</a></td>
  </tr>
  <tr> 
    <td id="s27" class="menu1" onMouseOver="changeClass('menu0','s27');" onMouseOut="changeClass('menu1','s27');"><a href="../Omnidex%20Concepts/Text/Omnidex%20Text.htm">Omnidex Text</a></td>
  </tr>
</table>
<table id="s3" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m3'); changeVisibility('visible','s3');" onMouseOut="changeClass('menu0','m3'); changeVisibility('hidden','s3');">
  <tr> 
    <td id="s31" class="menu1" onMouseOver="changeClass('menu0','s31');" onMouseOut="changeClass('menu1','s31');"><a href="../Getting%20Started/1%20-%20Installation%20and%20Setup.htm">Server 
      Setup Guides</a></td>
  </tr>
  <tr> 
    <td id="s32" class="menu1" onMouseOver="changeClass('menu0','s32');" onMouseOut="changeClass('menu1','s32');"><a href="../Getting%20Started/Omnidex%20Client/Windows%20Client.htm">Windows 
      Client</a></td>
  </tr>
  <tr> 
    <td id="s33" class="menu1" onMouseOver="changeClass('menu0','s33');" onMouseOut="changeClass('menu1','s33');"><a href="../Database%20Platforms/Supported%20Database%20Platforms.htm">Database 
      Platforms </a></td>
  </tr>
  <tr> 
    <td id="s34" class="menu1" onMouseOver="changeClass('menu0','s34');" onMouseOut="changeClass('menu1','s34');"><a href="../Environment%20Catalog/Environment%20Catalog.htm">Environment 
      Catalog</a> </td>
  </tr>
</table>
<table id="s4" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m4'); changeVisibility('visible','s4');" onMouseOut="changeClass('menu0','m4'); changeVisibility('hidden','s4');">
  <tr> 
    <td id="s41" class="menu1" onMouseOver="changeClass('menu0','s41');" onMouseOut="changeClass('menu1','s41');"><a href="../SQL%20Reference/SQL%20Reference.htm">SQL 
      Reference</a> </td>
  </tr>
  <tr> 
    <td id="s42" class="menu1" onMouseOver="changeClass('menu0','s42');" onMouseOut="changeClass('menu1','s42');"><a href="../Development/ODBC/ODBC.htm">ODBC</a></td>
  </tr>
  <tr> 
    <td id="s43" class="menu1" onMouseOver="changeClass('menu0','s43');" onMouseOut="changeClass('menu1','s43');"><a href="../Development/JDBC/JDBC.htm">JDBC</a></td>
  </tr>
  <tr> 
    <td id="s44" class="menu1" onMouseOver="changeClass('menu0','s44');" onMouseOut="changeClass('menu1','s44');"><a href="../Development/OmniAccess%20API/OmniAccess%20API.htm">OmniAccess 
      API</a></td>
  </tr>
  <tr> 
    <td id="s45" class="menu1" onMouseOver="changeClass('menu0','s45');" onMouseOut="changeClass('menu1','s45');"><a href="../Development/Debugging/OMNIDEX_DEBUG.htm">Debugging</a></td>
  </tr>
</table>
<table id="s5" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m5'); changeVisibility('visible','s5');" onMouseOut="changeClass('menu0','m5'); changeVisibility('hidden','s5');">
  <tr> 
    <td id="s51" class="menu1" onMouseOver="changeClass('menu0','s51');" onMouseOut="changeClass('menu1','s51');"><A href="../Utilities/DBINSTAL/DBINSTAL.htm">DBINSTAL</A></td>
  </tr>
  <tr> 
    <td id="s52" class="menu1" onMouseOver="changeClass('menu0','s52');" onMouseOut="changeClass('menu1','s52');"><a href="../Utilities/DSEDIT/DSEDIT.htm">DSEDIT</a></td>
  </tr>
  <tr> 
    <td id="s53" class="menu1" onMouseOver="changeClass('menu0','s53');" onMouseOut="changeClass('menu1','s53');"><a href="../Utilities/NSADMIN/NSADMIN.htm">NSADMIN</a></td>
  </tr>
  <tr> 
    <td id="s54" class="menu1" onMouseOver="changeClass('menu0','s54');" onMouseOut="changeClass('menu1','s54');"><a href="../Utilities/OACOMP/OACOMP.htm">OACOMP</a></td>
  </tr>
  <tr> 
    <td id="s55" class="menu1" onMouseOver="changeClass('menu0','s55');" onMouseOut="changeClass('menu1','s55');"><a href="../Utilities/OADECOMP/OADECOMP.htm">OADECOMP</a></td>
  </tr>
  <tr> 
    <td id="s56" class="menu1" onMouseOver="changeClass('menu0','s56');" onMouseOut="changeClass('menu1','s56');"><a href="../Utilities/OAHELPER/OAHELPER.htm">OAHELPER</a></td>
  </tr>
  <tr> 
    <td id="s57" class="menu1" onMouseOver="changeClass('menu0','s57');" onMouseOut="changeClass('menu1','s57');"><A href="../Utilities/ODXAIM/ODXAIM.htm">ODXAIM</A></td>
  </tr>
  <tr> 
    <td id="s58" class="menu1" onMouseOver="changeClass('menu0','s58');" onMouseOut="changeClass('menu1','s58');"><a href="../Utilities/ODXMAKE/ODXMAKE.htm">ODXMAKE</a></td>
  </tr>
  <tr> 
    <td id="s59" class="menu1" onMouseOver="changeClass('menu0','s59');" onMouseOut="changeClass('menu1','s59');"><a href="../Utilities/ODXNET/ODXNET.htm">ODXNET</a></td>
  </tr>
  <tr> 
    <td id="s510" class="menu1" onMouseOver="changeClass('menu0','s510');" onMouseOut="changeClass('menu1','s510');"><A href="../Utilities/ODXQUERY/ODXQUERY.htm">ODXQUERY</A></td>
  </tr>
  <tr> 
    <td id="s511" class="menu1" onMouseOver="changeClass('menu0','s511');" onMouseOut="changeClass('menu1','s511');"><a href="../Utilities/ODXSQL/ODXSQL.htm">ODXSQL</a></td>
  </tr>
  <tr> 
    <td id="s512" class="menu1" onMouseOver="changeClass('menu0','s512');" onMouseOut="changeClass('menu1','s512');"><a href="../Utilities/REGMAINT/REGMAINT.htm">REGMAINT</a></td>
  </tr>
  <tr> 
    <td id="s513" class="menu1" onMouseOver="changeClass('menu0','s513');" onMouseOut="changeClass('menu1','s513');"><A href="../Utilities/REGTEST/REGTEST.htm">REGTEST</A></td>
  </tr>
  <tr> 
    <td id="s514" class="menu1" onMouseOver="changeClass('menu0','s514');" onMouseOut="changeClass('menu1','s514');"><a href="../Utilities/SNOWGEN/SNOWGEN.htm">SNOWGEN</a></td>
  </tr>
  <tr> 
    <td id="s515" class="menu1" onMouseOver="changeClass('menu0','s515');" onMouseOut="changeClass('menu1','s515');"><a href="../Utilities/SYSINFO/SYSINFO.htm">SYSINFO</a></td>
  </tr>
  <tr> 
    <td id="s516" class="menu1" onMouseOver="changeClass('menu0','s516');" onMouseOut="changeClass('menu1','s516');"><a href="../Utilities/VERSIONS/VERSIONS.htm">VERSIONS</a></td>
  </tr>
  <tr> 
    <td id="s517" class="menu1" onMouseOver="changeClass('menu0','s517');" onMouseOut="changeClass('menu1','s517');"><a href="../Utilities/VIEWGEN/VIEWGEN.htm">VIEWGEN</a></td>
  </tr>
</table>
<table id="s6" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m6'); changeVisibility('visible','s6');" onMouseOut="changeClass('menu0','m6'); changeVisibility('hidden','s6');">
  <tr> 
    <td id="s61" class="menu1" onMouseOver="changeClass('menu0','s61');" onMouseOut="changeClass('menu1','s61');"><a href="../Appendix/Cardinality.htm">Cardinality</a></td>
  </tr>
  <tr> 
    <td id="s62" class="menu1" onMouseOver="changeClass('menu0','s62');" onMouseOut="changeClass('menu1','s62');"><a href="../Appendix/Date%20Formats.htm">Date 
      Formats </a></td>
  </tr>
  <tr> 
    <td id="s63" class="menu1" onMouseOver="changeClass('menu0','s63');" onMouseOut="changeClass('menu1','s63');"><a href="../Appendix/Environment%20Variables.htm">Environment 
      Variables </a></td>
  </tr>
  <tr> 
    <td id="s64" class="menu1" onMouseOver="changeClass('menu0','s64');" onMouseOut="changeClass('menu1','s64');"><a href="../Appendix/File%20Name%20Handling.htm">File 
      Name Handling</a></td>
  </tr>
  <tr> 
    <td id="s65" class="menu1" onMouseOver="changeClass('menu0','s65');" onMouseOut="changeClass('menu1','s65');"><a href="../Appendix/Glossary%20A.htm">Glossary</a></td>
  </tr>
  <tr> 
    <td id="s66" class="menu1" onMouseOver="changeClass('menu0','s66');" onMouseOut="changeClass('menu1','s66');"><a href="../Appendix/Null.htm">Null</a></td>
  </tr>
  <tr> 
    <td id="s67" class="menu1" onMouseOver="changeClass('menu0','s67');" onMouseOut="changeClass('menu1','s67');"><a href="../Appendix/OAGLOBAL.htm">OAGLOBAL</a></td>
  </tr>
  <tr> 
    <td id="s68" class="menu1" onMouseOver="changeClass('menu0','s68');" onMouseOut="changeClass('menu1','s68');"><a href="../Appendix/Operating%20Limits.htm">Operating 
      Limits</a></td>
  </tr>
  <tr> 
    <td id="s69" class="menu1" onMouseOver="changeClass('menu0','s69');" onMouseOut="changeClass('menu1','s69');"><a href="../Appendix/Provided%20Managed%20Synonym%20Lists.htm">Managed 
      Synonym Lists</a></td>
  </tr>
  <tr> 
    <td id="s70" class="menu1" onMouseOver="changeClass('menu0','s70');" onMouseOut="changeClass('menu1','s70');"><a href="../Appendix/Reserved%20Words.htm">Reserved 
      Words</a></td>
  </tr>
  <tr> 
    <td id="s71" class="menu1" onMouseOver="changeClass('menu0','s71');" onMouseOut="changeClass('menu1','s71');"><a href="../Appendix/Supported%20Datatypes.htm">Supported 
      Data Types</a></td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
<!-- InstanceEnd --></html>
