DISC

Contents | What's New | Quick Links

 

DBINSTAL

Introduction

Software Installation

Concepts and Design

Designing Applications

Omnidex Environments

SQL Reference

Omnidex API's

Utilities

Interfaces

Performance Guide

Troubleshooting Guide

Appendix

 

 

Environment Variables

DBINSTALSystem Commands

 

OAGLOBAL


Sets the path to the OmniAccess global environment file.

For OpenVMS, OAGLOBAL and TMPDIR are logicals; all other variables are symbols.


OA_[table_]CRITERIA


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.

OA_CRITERIA="product='type writer'"

OA_ORDERS_CRITERIA="state='CA' and amount > 1000"


OA_MAX_ROWS


Restricts the number of rows to be indexed. Generally used for testing.

OA_MAX_ROWS=100


OA_OPTIONS


Sets the connect options that will be used to connect to the Environment Catalog.

OA_OPTIONS="DBACCESS=5"


OA_PASSWORD


Sets a password for all connections.

OA_PASSWORD="my_password"


OA_[table_]SELECT_OPTIONS


Sets the options list for internal calls to oaselect, either globally or for a specified table.

OA_SELECT_OPTIONS="RESTART"

OA_ORDERS_SELECT_OPTIONS ="RECNO_ERRORS"


OA_SELECT_QUOTES={1|0}


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.

For example, if a table name is the reserved word "BANNER", you would insure that the table name is quoted by setting:

OA_SELECT_QUOTES=1


OA_USERNAME


Sets a username for all oaconnects from DBINSTAL.

OA_USERNAME="user1"


TMPDIR - (TEMP and TMP on Windows)


sets the directory where DBINSTAL builds the scratch files for sorting and loading keywords, or where oaqualify and oaexport build temporary files.

Does not apply to the MPE operating system.

Environment Variables

Indexing Options

System Commands

Program Operation

Check Indexing Status

DBINSTAL

 

 

top

Dynamic Information Systems Corporation - Omnidex Version 3.8 Build 6 J15.03-Copyright © 2003

DISC | Documentation Home