This shows you the differences between two versions of the page.
|
dev:sql:statements:set:home [2010/06/14 18:31] tdo |
dev:sql:statements:set:home [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| - | ====== 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 | | | ||
| - | | [[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]] | filename] | | | ||
| - | | [[SQL_LOGGING]] | <ON %%|%% OFF %%|%% TEXT> %%[%%WITH options%%]%% | | | ||
| - | | [[SQL_SYNTAX]] | < ORACLE %%|%% OMNIDEX > | Allows some Oracle specific SQL functions to be used in Omnidex SQL statements. | | ||
| - | | [[STATISTICS]] | <ON %%|%% OFF %%|%% filename>] | | | ||
| - | | [[TIMEOUT]] | <seconds %%|%% OFF> | Sets how long an Omnidex QUALIFY or SELECT will process before timing out. | | ||
| - | |||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||