Omnidex SQL:

      SET DEBUG …
SET OPTIMIZATION …
SET REQUIRED_OPTIMIZATION
SET CHAR …
SET TIMEOUT …
SET REDEFROWIDS …	
SET PSEUDOCOLUMNS …
SET QUALIFY_MODE …
SET AUTOPSEUDOCOLUMNS …
SET PREPROCESSOR …
SET SQL_LOGGING …
SET SQL_LOGFILE …

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.