This is an old revision of the document!
| SET Command | Option | Description |
|---|---|---|
| API | <OA|CLOA|ODBC|JDBC> | SET's which API to use. |
| 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]
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.