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. | |