<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="/Templates/DISCTemplate.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Untitled Document</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- InstanceBeginEditable name="head" -->
<script language="JavaScript" type="text/javascript">
function goBack() { //v2.0
  if (history.length > 0){history.back()}
}
</script>
<!-- InstanceEndEditable -->
<link href="../../discstyles.css" rel="stylesheet" type="text/css">
</head>

<body>
<table width="800" border="1" cellpadding="1" cellspacing="1" bordercolor="#003399" bgcolor="#FFFFFF">
  <tr>
    <td>
	<table width="800" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td width="150" valign="top" bgcolor="#6699CC"><a name="top"></a> <a href="http://www.disc.com/index.html"><img src="../../images/flatlogo.gif" alt="DISC" width="95" height="25" hspace="10" vspace="10" border="0"></a> 
          </td>
          <td width="300" valign="top" bgcolor="#6699CC"> <img src="../../images/omnidex.gif" width="100" height="25" hspace="10" vspace="10"></td>
          <td width="350" valign="top" bgcolor="#6699CC"> 
            <p class="topnav"><a href="../../Table%20of%20Contents.htm" class="top">Contents</a> 
              | <a href="../../Internals/Release%20Notes/Whats%20New.htm" class="top">What's 
              New</a> | <a href="../../Quick%20Links.htm" class="top">Quick Links</a></p></td>
        </tr>
      </table>
	<table width="800" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td width="400" background="../../images/bottombar.jpg" bgcolor="#003366"> 
            <h1><font size="2">Version 4.0</font><img src="../../images/blank.gif" width="90" height="10"></h1></td>
          <td width="400" valign="top" background="../../images/bottombar.jpg" bgcolor="#003366"> 
            <!-- InstanceBeginEditable name="SectionTitle" -->
            <h1>DBINSTAL</h1>
            <!-- InstanceEndEditable --></td>
        </tr>
      </table>
	  <table width="800" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td width="200" valign="top" background="../../images/left.jpg" bgcolor="#6699CC"><!-- InstanceBeginEditable name="LeftNav" --> 
            <p class="leftnav"><a class="top" href="../../Omnidex%20Version%204.0.htm">Introduction</a></p>
            <p class="leftnav"><a class="top" href="../../Software%20Installation/Software%20Installation.htm">Software 
              Installation</a></p>
            <p class="leftnav"><a class="top" href="../../Concepts%20and%20Design/Concepts%20and%20Design.htm">Concepts 
              and Design</a></p>
            <p class="leftnav"><a href="../../Designing%20Applications/Designing%20Applications.htm" class="top">Designing 
              Applications</a></p>
            <p class="leftnav"><a href="../../Omnidex%20Environments/Omnidex%20Environments.htm" class="top">Omnidex 
              Environments</a></p>
            <p class="leftnav"><a href="../../SQL%20Reference/SQL%20Reference.htm" class="top">SQL 
              Reference</a></p>
            <p class="leftnav"><a href="../../Application%20Programming%20Interfaces/Application%20Programming%20Interfaces.htm" class="top">Omnidex 
              API's</a></p>
            <p class="leftnav"><a href="../Utility%20Reference.htm" class="top">Utilities</a></p>
            <p class="leftnav"><a href="../../Interfaces/Interfaces.htm" class="top">Interfaces</a></p>
            <p class="leftnav"><a href="../../Performance/Performance%20Guide.htm" class="top">Performance 
              Guide</a></p>
            <p class="leftnav"><a href="../../Troubleshooting/Troubleshooting%20Guide.htm" class="top">Troubleshooting 
              Guide</a></p>
            <p class="leftnav"><a href="../../Appendix/Appendix.htm" class="top">Appendix</a></p>
            <p>&nbsp;</p>
            <p>&nbsp;</p>
            <!-- InstanceEndEditable --> </td>
          <td width="600" height="35" valign="top">
		  <table width="600" border="0" cellpadding="0" cellspacing="0">
		  <tr>
		        <td width="450" bgcolor="#FFFFFF"> <!-- InstanceBeginEditable name="PageTitle" -->
                  <h2>Environment Variables</h2>
              <!-- InstanceEndEditable -->
			</td>
			    <td width="150" valign="top" bgcolor="#FFFFFF"> <!-- InstanceBeginEditable name="NavButtons" --> 
                  <p class="buttonnav"><img src="../../images/back.gif" name="back" width="40" height="12" id="back" onClick="goBack()"><a href="DBINSTAL.htm"><img src="../../images/up.gif" alt="DBINSTAL" width="40" height="12" border="0"></a><a href="System%20Commands.htm"><img src="../../images/next.gif" alt="System Commands" width="40" height="12" border="0"></a></p>
                  <!-- InstanceEndEditable -->
			</td>
		  </tr>
		      <tr bgcolor="#FFFFFF"> 
                <td colspan="2"> 
                  <p class="line">&nbsp;</p>
			</td>
		  </tr>
          <tr> 
          	    <td width="450" valign="top" bgcolor="#FFFFFF"><!-- InstanceBeginEditable name="Content1" -->
                  <h4>OAGLOBAL</h4>
                  <p><br>
                    Sets the path to the OmniAccess global environment file.</p>
                  <p>For OpenVMS, OAGLOBAL and TMPDIR are logicals; all other 
                    variables are symbols.</p>
                  <h4><br>
                    OA_[table_]CRITERIA</h4>
                  <p><br>
                    Limits the records retrieved and indexed from the underlying 
                    database based on the criteria. Valid criteria are the same 
                    as those used in oaselect. Criteria can be set for individual 
                    tables or for the entire database.</p>
                  <p class="ex">OA_CRITERIA=&quot;product='type writer'&quot;</p>
                  <p class="ex">OA_ORDERS_CRITERIA=&quot;state='CA' and amount 
                    &gt; 1000&quot;</p>
                  <h4><br>
                    OA_MAX_ROWS</h4>
                  <p><br>
                    Restricts the number of rows to be indexed. Generally used 
                    for testing.</p>
                  <p class="ex">OA_MAX_ROWS=100</p>
                  <h4><br>
                    OA_OPTIONS</h4>
                  <p><br>
                    Sets the connect options that will be used to connect to the 
                    Environment Catalog.</p>
                  <p class="ex">OA_OPTIONS=&quot;DBACCESS=5&quot;</p>
                  <h4><br>
                    OA_PASSWORD</h4>
                  <p><br>
                    Sets a password for all connections.</p>
                  <p class="ex">OA_PASSWORD=&quot;my_password&quot;</p>
                  <h4><br>
                    OA_[table_]SELECT_OPTIONS</h4>
                  <p><br>
                    Sets the options list for internal calls to oaselect, either 
                    globally or for a specified table.</p>
                  <p class="ex">OA_SELECT_OPTIONS=&quot;RESTART&quot;</p>
                  <p class="ex">OA_ORDERS_SELECT_OPTIONS =&quot;RECNO_ERRORS&quot;</p>
                  <p class="ex"><br>
                    OA_SELECT_QUOTES={1|0}</p>
                  <p><br>
                    Quotes table names (when set to 1) or leaves them as is (when 
                    set to 0) when table names are passed to oaselect if the table 
                    names are also reserved words.</p>
                  <p>For example, if a table name is the reserved word &quot;BANNER&quot;, 
                    you would insure that the table name is quoted by setting: 
                  </p>
                  <p class="ex">OA_SELECT_QUOTES=1</p>
                  <h4><br>
                    OA_USERNAME</h4>
                  <p><br>
                    Sets a username for all oaconnects from DBINSTAL.</p>
                  <p class="ex">OA_USERNAME=&quot;user1&quot;</p>
                  <h4><br>
                    TMPDIR - (TEMP and TMP on Windows)</h4>
                  <p><br>
                    sets the directory where DBINSTAL builds the scratch files 
                    for sorting and loading keywords, or where oaqualify and oaexport 
                    build temporary files.</p>
                  <p>Does not apply to the MPE operating system.</p>
                  <p></p>
                  <!-- InstanceEndEditable --></td>
          	    <td width="150" valign="top"><!-- InstanceBeginEditable name="RightNav" -->
                  <table width="150" border="1" cellpadding="1" cellspacing="0" bordercolor="#003333" bgcolor="#006699">
                    <tr> 
                <td><p class="rightnav">Environment Variables</p>
                        <p class="rightnav"><a href="Indexing%20Options.htm" class="top">Indexing 
                          Options</a></p>
                        <p class="rightnav"><a href="System%20Commands.htm" class="top">System 
                          Commands</a></p>
                        <p class="rightnav"><a href="Program%20Operation.htm" class="top">Program 
                          Operation</a></p>
                        <p class="rightnav"><a href="Check%20Indexing%20Status.htm" class="top">Check 
                          Indexing Status</a></p>
                        <p class="rightnav"><a href="DBINSTAL.htm" class="top">DBINSTAL</a></p></td>
              </tr>
            </table>
            <!-- InstanceEndEditable --></td>
        	</tr>
		  </table>
		  <table width="600" border="0" cellpadding="0" cellspacing="0">
		    <tr>
			  <td width="600">
			  <!-- InstanceBeginEditable name="Content2" -->
                  <P>&nbsp;</P>
            <P>&nbsp;</P>
            <P class="topnav"><a href="#top">top</a></P>
            <!-- InstanceEndEditable -->
			  </td>
			</tr>
		  </table>
		</td>
        </tr>
      </table>
	  <table width="800" height="35" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td width="600" valign="bottom" background="../../images/bottombar.jpg">
<p class="bottomnav">Dynamic Information Systems Corporation - Omnidex Version 
              4.0 Build 6 J30.03-Copyright &copy; 2003</p></td>
          <td width="200" valign="bottom" background="../../images/bottombar.jpg"> 
            <p class="topnav"><a href="http://www.disc.com" class="top">DISC</a> 
              | <a href="../../Omnidex%20Version%204.0.htm" class="top">Documentation 
              Home</a></p></td>
        </tr>
      </table>
	  </td>
  </tr>
</table>
</body>
<!-- InstanceEnd --></html>
