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 …

  [API <OA | CLOA | ODBC | JDBC>]
  [AUTODISPLAY <LIST | FORM>]
  [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]]]
  [PSEUDOCOLUMNS <ON | OFF>]
  [QUALIFY_COUNTS <PARENT | NOPARENT>]
  [QUALIFY_MODE <PARSER | ODXFIND | OX_FIND>]
  [REDEFROWIDS <ON | OFF>]
  [REQUIRED_OPTIMIZATION options]
  [SILENT_MODE <ON | OFF>]
  [SQL_LOGFILE filename]
  [SQL_LOGGING <ON | OFF> [WITH options]]
  [STATISTICS <ON | OFF | filename>]

  [STATUSDISPLAY <ON | OFF>]
  [TIMEOUT <seconds | OFF>]
  [TIMER <ON | CUMULATIVE | OFF>]

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.