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. The following is a list of all of the available OdxSQL settings.
| OdxSQL Settings | |||||
|---|---|---|---|---|---|
| API | AUTODISPLAY | AUTOEXPLAIN | AUTOFETCH | AUTOPSEUDOCOLUMNS | AUTORECONNECT |
| AUTOSUBPROCESS | CHAR | CURSOR | CURSORDISPLAY | DEFAULTS | EDITOR |
| ENDIAN | ERRORDISPLAY | ERRORS | EXPLAIN SET | FILE_BASELINE | HEADERS |
| HEX | HISTORY | INTERRUPTS | MEMORY_BASELINE | MULTICONNECT | MULTILINE |
| NULL_INDICATORS | OMNIDEX_DEBUG | OPTIMIZATION | ODXSQL_DEBUG | PAGELENGTH | PAGEWIDTH |
| PREPROCESSOR | PROGRESS | PROMPT | PSEUDOCOLUMNS | QUALIFY_COUNTS | REDEFROWIDS |
| REQUIRED_OPTIMIZATION | SILENT_MODE | SQL_LOGFILE | SQL_LOGGING | SQL_SYNTAX | STATISTICS |
| STATISTICS_COMMENT | STATUSDISPLAY | TERMINATION | TIMEOUT | TIMER |
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 before the first CONNECT Statement. |
| 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 | The cursor number being used can be set to automatically display. |
| 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 | Set the display of output values in HEX |
| 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 | |
| ODXSQL_DEBUG | <PARSE | FILE | DEBUG | ALL> <ON | OFF> | ||
| 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 | Can disable the use of the Omnidex SQL Preprocessor. Use only for testing. |
| 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. |
OdxSql 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 on