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/07/04 04:03] tdo |
dev:sql:statements:set:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ====== Omnidex SQL: SET Statements ====== | ====== Omnidex SQL: SET Statements ====== | ||
| {{page>:sql_bar&nofooter&noeditbtn}} | {{page>:sql_bar&nofooter&noeditbtn}} | ||
| - | |||
| ===== Description ===== | ===== Description ===== | ||
| Line 20: | 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. | | ||