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 | …… Option …… | Description |
---|---|---|
API | <OA | CLOA | ODBC | JDBC> | Sets which API to use. |
AUTODISPLAY | <LIST | FORM> | Sets Columns across (LIST) or Columns stacked (FROM). |
AUTOEXPLAIN | <ON | OFF | AFTER> | Shows the Explain Plan after each Select |
AUTOFETCH | <ON | OFF> | |
AUTOPSEUDOCOLUMNS | <ON | OFF> | |
AUTORECONNECT | <ON | OFF> | |
AUTOSUBPROCESS | <n | NONE> | |
CHAR | <AUTO | n> | |
CONTINUATION | <ON | OFF> | When ON automatically terminates statements. |
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 | <option> | <[NO]COUNTS![NO]SUMMARY! [NO]DETAILS![NO]ADDIN! [NO]TEXT |
FILE_BASELINE | ||
HEADERS | <ON | OFF> | |
HEX | <ON | OFF | ONLY> | |
HISTORY | n | |
INSTANCE | n | |
INTERRUPTS | <ON | OFF | API> | |
MEMORY_BASELINE | ||
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 | |
PREPROCESSOR | <ON | OFF> | |
PROGRESS | <ON | OFF> | |
PROMPT | [“string”] [WITH [FILE] [LINE] [COMMAND] | |
PSEUDOCOLUMNS | <ON | OFF> | |
QUALIFY_COUNTS | <PARENT | NOPARENT> | |
QUALIFY_MODE | <PARSER | ODXFIND | OX_FIND> | |
REDEFROWIDS | <ON | OFF> | |
REQUIRED_OPTIMIZATION | options | |
SILENT_MODE | <ON | OFF> | |
SQL_LOGFILE | filename | |
SQL_LOGGING | <ON | OFF> [WITH options] | |
STATISTICS | <OFF | ON | filename> | |
STATISTICS_COMMENT | “string” | |
STATUSDISPLAY | <ON | OFF> | |
TIMEOUT | <seconds | OFF> | |
TIMER | <ON | CUMULATIVE | OFF>] |
> 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