This is an old revision of the document!
OdxSQL's operation is controlled by several settings. These settings can be dynamically changed by using the OdxSQL SET Command.
To see OdxSQL's current settings, issue the SET Command without any arguments.
> SET
| Setting | Default | Other Options | Description |
|---|---|---|---|
| API | OA | ODBC | JDBC | CLOA | Sets which API to use. |
| AUTODISPLAY | LIST | FORM> | Sets Columns across (LIST) or Columns stacked (FROM). |
| AUTOEXPLAIN | OFF | ON | AFTER> | Shows the Explain Plan for the SELECT statement instead of processing the SELECT. |
| AUTOFETCH | ON | OFF | Automatically fetch records after a SELECT or QUALIFY. |
| AUTOPSEUDOCOLUMNS | OFF | ON | |
| AUTORECONNECT | OFF | ON | |
| AUTOSUBPROCESS | NONE | n | |
| CHAR | AUTO | n | |
| CONTINUATION | ON | OFF | When ON automatically terminates statements. |
| CURSOR | last opened | n | Sets the default Cursor to use for processing. |
| CURSORDISPLAY | OFF | ON | |
| DEFAULTS | <none> | <none> | Resets all settings to their initial defaults. |
| EDITOR | NOTEPAD or vi | WORDPAD | EMACS | path | Sets which editor to use with the EDIT Command |
| ENDIAN | LITTLE | BIG | NATIVE | OPPOSITE> | |
| ERRORDISPLAY | MESSAGE | NONE | DETAIL | FULL | |
| ERRORS | ABORT | CONTINUE | EXIT | Set processing of USE file. |
| EXPLAIN | SUMMARY DETAILS ADDIN | [NO]COUNTS | TEXT | Sets the EXPLAIN Command options. |
| FILE_BASELINE | OFF | ||
| HEADERS | ON | OFF | Turn the Column Headers ON or OFF.s |
| HEX | OFF | ON | ONLY | |
| HISTORY | 100 | n | Sets the size of the Command History stack. |
| INSTANCE | last connection | n | Sets the default Instance to use for processing. |
| INTERRUPTS | ON | OFF | API | |
| MEMORY_BASELINE | OFF | ||
| MULTILINE | OFF | ON | n | |
| NULL_INDICATORS | OFF | ON | string | |
| OMNIDEX_DEBUG | OFF | ON | profile [FILE=filename] | |
| OPTIMIZATION | DEFAULT | options | |
| ODXNET | INACTIVE | ||
| PAGELENGTH | 24 | n | Set the page length before the paging prompt is issued. |
| PAGEWIDTH | 80 | n | Sets the page width of the display. |
| PREPROCESSOR | ON | OFF | |
| PROGRESS | OFF | ON | |
| PROMPT | “> ” | “string” [WITH [FILE] [LINE] [COMMAND]] | Sets the OdxSQL command prompt. |
| PSEUDOCOLUMNS | ON | OFF | |
| QUALIFY_COUNTS | PARENT | NOPARENT | |
| QUALIFY_MODE | PARSER | ODXFIND | OX_FIND | Changes the Qualify Mode to internal routines. |
| REDEFROWIDS | ON | OFF | |
| REMOTE_HOST | NONE | ||
| REQUIRED_OPTIMIZATION | NONE | options | |
| SILENT_MODE | OFF | ON | |
| SQL_LOGFILE | DEFAULT | filename | |
| SQL_LOGGING | OFF | ON [WITH options] | |
| STATISTICS | OFF | ON | filename | |
| STATISTICS_COMMENT | none | “string” | |
| STATUSDISPLAY | OFF | ON | |
| TIMEOUT | OFF | seconds | |
| TIMER | OFF | ON | CUMULATIVE | Shows the CPU and Elapsed time of SELECT and QUALIFY statements. |
OdxSET has settings that govern its operation. The settings can be modified with the SET command.
Note that OdxSQL also allows SET Statements from the Omnidex SQL Language.
set autoexplain on set explain counts, text, $ox set pagelength 0 set timer on SET STATISTICS ET STATISTICS_COMMENT
SET STATISTICS