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 | FILE_BASELINE | HEADERS |
| HEX | HISTORY | INSTANCE | 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
To see OdxSQL's a list of all the settings and the available setting values issue the SET ? command.
> 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 | |
| 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 errors of statements from a 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 | ||
| MULTICONNECT | OFF | ON | Allows OdxSQL to connect to multiple Environments. |
| MULTILINE | OFF | ON | n | |
| NULL_INDICATORS | OFF | ON | string | |
| ODXSQL_DEBUG | <PARSE | FILE | DEBUG | ALL> <ON | OFF> | ||
| OMNIDEX_DEBUG | OFF | ON | profile [FILE=filename] | When ON, writes Omnidex debugging to odxdebug.log or to a named file with FILE clause. |
| OPTIMIZATION | DEFAULT | options | |
| 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 | |
| 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 statements. |
set autoexplain on set explain counts, text set pagelength 0 set timer on SET STATISTICS on