This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
dev:sql:statements:set:home [2010/06/14 18:31] tdo |
dev:sql:statements:set:home [2010/07/04 15:59] tdo |
||
---|---|---|---|
Line 2: | Line 2: | ||
<html><div align="center"><span style="color:red">DRAFT</span></div></html> | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
====== Omnidex SQL: SET Statements ====== | ====== Omnidex SQL: SET Statements ====== | ||
+ | {{page>:sql_bar&nofooter&noeditbtn}} | ||
===== Description ===== | ===== Description ===== | ||
Line 8: | Line 9: | ||
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. | 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 | | | + | | [[INSTANCE ]]| n | Changes the instance number when using multiple connections.| |
| [[INTERRUPTS]] | <ON %%|%% OFF %%|%% API>] | | | | [[INTERRUPTS]] | <ON %%|%% OFF %%|%% API>] | | | ||
| [[NULL_INDICATORS]] | <ON %%|%% OFF %%|%% string> | | | | [[NULL_INDICATORS]] | <ON %%|%% OFF %%|%% string> | | | ||
Line 18: | Line 19: | ||
| [[REDEFROWIDS]] | <ON %%|%% OFF> | | | | [[REDEFROWIDS]] | <ON %%|%% OFF> | | | ||
| [[REQUIRED_OPTIMIZATION]] | options] | | | | [[REQUIRED_OPTIMIZATION]] | options] | | | ||
- | | [[SQL_LOGFILE]] | filename] | | | + | | [[SQL_LOGFILE]] | filespec | | |
| [[SQL_LOGGING]] | <ON %%|%% OFF %%|%% TEXT> %%[%%WITH options%%]%% | | | | [[SQL_LOGGING]] | <ON %%|%% OFF %%|%% TEXT> %%[%%WITH options%%]%% | | | ||
- | | [[SQL_SYNTAX]] | < ORACLE %%|%% OMNIDEX > | Allows some Oracle specific SQL functions to be used in Omnidex SQL statements. | | + | | [[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>] | | | | [[STATISTICS]] | <ON %%|%% OFF %%|%% filename>] | | | ||
| [[TIMEOUT]] | <seconds %%|%% OFF> | Sets how long an Omnidex QUALIFY or SELECT will process before timing out. | | | [[TIMEOUT]] | <seconds %%|%% OFF> | Sets how long an Omnidex QUALIFY or SELECT will process before timing out. | |