Omnidex SQL:

        SET DEBUG …
	SET OPTIMIZATION …
	SET REQUIRED_OPTIMIZATION
	SET CHAR …
	SET TIMEOUT …
	SET REDEFROWIDS …	
	SET PSEUDOCOLUMNS …
	SET QUALIFY_MODE <ODXFIND | PARSER >
	SET AUTOPSEUDOCOLUMNS …
	SET PREPROCESSOR …
	SET SQL_LOGGING …
	SET SQL_LOGFILE …
^ SET Command ^ Description ^
| API api | <OA, CLOA , ODBC , JDBC> |
| AUTODISPLAY <LIST %%|%% FORM> | desc |
|  [AUTOEXPLAIN <ON %%|%% OFF %%|%% AFTER>] | |
|  [AUTOFETCH <ON %%|%% OFF>] | |
|  [CHAR <AUTO %%|%% n>] | |
|  [CONTINUATION <ON %%|%% OFF>] | |
|  [CURSOR n]
|  [CURSORDISPLAY <ON %%|%% OFF>] | |
|  [DEFAULTS] | |
|  [EDITOR <NOTEPAD %%|%% WORDPAD %%|%% VI %%|%% EMACS %%|%% path> | |
|  [ENDIAN <LITTLE | BIG %%|%% NATIVE %%|%% OPPOSITE> | |
|  [ERRORDISPLAY <NONE %%|%% MESSAGE %%|%% DETAIL | FULL>] | |
|  [ERRORS <ABORT %%|%% CONTINUE %%|%% EXIT>] | |
|  [EXPLAIN <[NO]COUNTS%%|%%[NO]SUMMARY|[NO]DETAILS%%|%%[NO]ADDIN%%|%%[NO]T | |
|  [HEADERS <ON %%|%% OFF>] | |
|  [HEX <ON %%|%% OFF %%|%% ONLY>] | |
|  [HISTORY n] | |
|  [INSTANCE n] | |
|  [INTERRUPTS <ON %%|%% OFF %%|%% API>] | |
|  [MULTILINE] <ON %%|%% OFF %%|%% n> | |
|  [NULL_INDICATORS <ON %%|%% OFF %%|%% string>] | |
|  [OMNIDEX_DEBUG <ON | OFF %%|%% profile> [FILE=filename]] | |
|  [OPTIMIZATION options] | |
|  [ODXSQL_DEBUG <PARSE %%|%% FILE %%|%% DEBUG %%|%% ALL> <ON %%|%% OFF>] | |
| [PAGELENGTH n] | |
|  [PAGEWIDTH n] | |
|  [PROMPT ["string"] [WITH [FILE] [LINE] [COMMAND]]] | desc |
|  [PSEUDOCOLUMNS <ON %%|%% OFF>] | desc |
|  [QUALIFY_COUNTS <PARENT %%|%% NOPARENT>] | desc |
|  [QUALIFY_MODE <PARSER %%|%% ODXFIND | OX_FIND>] | desc |
|  [REDEFROWIDS <ON %%|%% OFF>] | desc |
|  [REQUIRED_OPTIMIZATION options]  |desc  |
|  [SILENT_MODE <ON %%|%% OFF>] |desc |
|  [SQL_LOGFILE filename] |desc |
|  [SQL_LOGGING <ON %%|%% OFF> [WITH options]] | desc |
|  [STATISTICS <ON %%|%% OFF | filename>] |desc |
|  [STATUSDISPLAY <ON | OFF>] |desc |
|  [TIMEOUT <seconds %%|%% OFF>] | desc |
|  [TIMER <ON %%|%% CUMULATIVE %%|&& OFF>] | desc |

Internal
x [AUTOPSEUDOCOLUMNS <ON | OFF>]
x [AUTORECONNECT <ON | OFF>]
x [AUTOSUBPROCESS <n | NONE>
x [STATISTICS_COMMENT "string"]
x [PREPROCESSOR <ON | OFF>]
x [PROGRESS <ON | OFF>]
x [MEMORY_BASELINE]
x [FILE_BASELINE]

The syntaxes of the SQL Logging SET commands are shown below:

  set sql_logging <on | off> 

This command activates SQL Logging for this process. By default, statements are logged to the $SQL_STATEMENTS file along with statistics about the execution of the command. The $SQL_STATEMENTS file is named “sqllog.tdf”, and is located in the same directory as the compiled environment file. This file is a standard tab-delimited file, and may be easily imported into other applications. The file may be flushed by simply removing the file; the file will be automatically recreated the next time logging is activated.

  set sql_logfile <filename>

This command redirects the SQL logging for this process to a text file that only contains the statement, and does not contain any statistical information. If the file already exists, it will be appended to rather than overwritten.