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 after each 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 | 0 | n | |
| 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 | |
| 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 | |
| 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. |
> set Current settings: API OA AUTODISPLAY LIST AUTOEXPLAIN OFF AUTOFETCH ON AUTOPSEUDOCOLUMNS OFF AUTORECONNECT OFF AUTOSUBPROCESS NONE CHAR AUTO CONTINUATION ON CURSOR 0 CURSORDISPLAY OFF EDITOR DEFAULT ENDIAN LITTLE ERRORDISPLAY MESSAGE ERRORS ABORT EXPLAIN NOCOUNTS SUMMARY DETAILS ADDIN NOTEXT FILE_BASELINE OFF HEADERS ON HEX OFF HISTORY 100 INSTANCE 0 Press <RETURN> to continue or '/' to stop paging ... INTERRUPTS ON (currently armed) MEMORY_BASELINE OFF MULTILINE OFF NULL_INDICATORS OFF ODXNET INACTIVE OMNIDEX_DEBUG OFF OPTIMIZATION DEFAULT PAGELENGTH 24 PAGEWIDTH 80 PREPROCESSOR ON PROGRESS OFF PROMPT "> " PSEUDOCOLUMNS ON QUALIFY_COUNTS PARENT QUALIFY_MODE PARSER REDEFROWIDS ON REMOTE_HOST NONE REQUIRED_OPTIMIZATION NONE SILENT_MODE OFF SQL_LOGFILE DEFAULT SQL_LOGGING OFF STATISTICS OFF STATUSDISPLAY OFF Press <RETURN> to continue or '/' to stop paging ... TIMEOUT OFF TIMER OFF
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
The SET STATISTICS command in ODXSQL has been expanded to track more information, including the process ID and the thread ID. As well, a new command called SET STATISTICS_COMMENT