Action disabled: source

DRAFT

Omnidex SQL: SET Statements

Description

The following SET statements can modify the default Omnidex processing characteristics for a particular Omnidex connection and can be used with an ODBC or JDBC application.

Note that these SET statements can also be issued interactively within OdxSQL or in an OdxSQL batch script. Note that OdxSQL also has SET commands that govern specific processing options of OdxSQL that are not allowed in an ODBC or JDBC application.

INSTANCE n Changes the instance number when using multiple connections.
INTERRUPTS <ON | OFF | API>]
NULL_INDICATORS <ON | OFF | string>
OMNIDEX_DEBUG <ON | OFF | profile> [FILE=filename]]
OPTIMIZATION options
PSEUDOCOLUMNS <ON | OFF>
QUALIFY_COUNTS <PARENT | NOPARENT>
QUALIFY_MODE <PARSER | ODXFIND | OX_FIND> Sets how the QUALIFY statement will process criteria
REDEFROWIDS <ON | OFF>
REQUIRED_OPTIMIZATION options]
SQL_LOGFILE filespec
SQL_LOGGING <ON | OFF | TEXT> [WITH options]
SQL_SYNTAX < ORACLE|OMNIDEX| SQLSERVER > Allows some Oracle specific SQL functions to be used in Omnidex SQL statements or the SQLSERVER bracket syntax.
STATISTICS <ON | OFF | filename>]
TIMEOUT <seconds | OFF> Sets how long an Omnidex QUALIFY or SELECT will process before timing out.
 
Back to top
dev/sql/statements/set/home.txt ยท Last modified: 2016/06/28 22:38 (external edit)