^ Setting ^ Option ^ Description ^

| [[API | <OA ! CLOA ! ODBC ! JDBC>|
| [[AUTODISPLAY | <LIST ! FORM>|
| [[AUTOEXPLAIN | <ON ! OFF ! AFTER>|
| [[AUTOFETCH | <ON ! OFF>|
| [[AUTOPSEUDOCOLUMNS | <ON ! OFF>|
| [[AUTORECONNECT | <ON ! OFF>|
| [[AUTOSUBPROCESS | <n ! NONE>
| [[CHAR | <AUTO ! n>|
| [[CONTINUATION | <ON ! OFF>|
| [[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 | <[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 |<ON ! OFF ! 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