This shows you the differences between two versions of the page.
programs:odxsql:settings:home [2009/12/02 19:23] tdo created |
programs:odxsql:settings:home [2016/06/28 22:38] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{page>:top_add&nofooter&noeditbtn}} | ||
- | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
- | ====== OdxSQL Settings ====== | ||
- | > set ? | ||
- | SET | ||
- | [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>] | ||
- | <code> | ||
- | |||
- | |||
- | |||
- | ===== OdxSQL Default Settings ===== | ||
- | |||
- | <code> | ||
- | > 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 | ||
- | </code> | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | {{page>:bottom_add&nofooter&noeditbtn}} |