DRAFT

Omnidex SQL: SET STATEMENTS

Description

INSTANCE	n
INTERRUPTS	<ON \| OFF \| API>]
NULL_INDICATORS	<ON \| OFF \| string>
OMNIDEX_DEBUG	<ON \| OFF \| profile> [FILE=filename]]
OPTIMIZATION	options
PSEUDOCOLUMNS	<ON \| OFF>	desc
QUALIFY_COUNTS	<PARENT \| NOPARENT>	desc
QUALIFY_MODE	<PARSER \| ODXFIND \| OX_FIND>	desc
REDEFROWIDS	<ON \| OFF>	desc
REQUIRED_OPTIMIZATION	options]	desc
SQL_LOGFILE	filename]	desc
SQL_LOGGING	<ON \| OFF> [WITH options]	desc
STATISTICS	<ON \| OFF \| filename>]	desc
TIMEOUT	<seconds \| OFF>	desc

Internal SET Commands

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]

Level 2 Headline

        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 …

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.