This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
programs:odxsql:settings:home [2010/07/04 19:03] tdo |
programs:odxsql:settings:home [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 10: | Line 10: | ||
|API |AUTODISPLAY |AUTOEXPLAIN |AUTOFETCH |AUTOPSEUDOCOLUMNS |AUTORECONNECT| | |API |AUTODISPLAY |AUTOEXPLAIN |AUTOFETCH |AUTOPSEUDOCOLUMNS |AUTORECONNECT| | ||
|AUTOSUBPROCESS|CHAR|CURSOR|CURSORDISPLAY|DEFAULTS|EDITOR| | |AUTOSUBPROCESS|CHAR|CURSOR|CURSORDISPLAY|DEFAULTS|EDITOR| | ||
- | |ENDIAN |ERRORDISPLAY|ERRORS|EXPLAIN SET|FILE_BASELINE|HEADERS| | + | |ENDIAN |ERRORDISPLAY|ERRORS|EXPLAIN|FILE_BASELINE|HEADERS| |
- | |HEX|HISTORY|INTERRUPTS|MEMORY_BASELINE|MULTICONNECT|MULTILINE| | + | |HEX|HISTORY|INSTANCE|INTERRUPTS|MEMORY_BASELINE|MULTICONNECT| |
- | |NULL_INDICATORS|OMNIDEX_DEBUG|OPTIMIZATION|ODXSQL_DEBUG|PAGELENGTH|PAGEWIDTH| | + | |MULTILINE|NULL_INDICATORS|OMNIDEX_DEBUG|OPTIMIZATION|ODXSQL_DEBUG|PAGELENGTH| |
- | |PREPROCESSOR|PROGRESS|PROMPT|PSEUDOCOLUMNS|QUALIFY_COUNTS|REDEFROWIDS| | + | |PAGEWIDTH|PREPROCESSOR|PROGRESS|PROMPT|PSEUDOCOLUMNS|QUALIFY_COUNTS| |
- | |REQUIRED_OPTIMIZATION|SILENT_MODE|SQL_LOGFILE|SQL_LOGGING|SQL_SYNTAX|STATISTICS| | + | |REDEFROWIDS|REQUIRED_OPTIMIZATION|SILENT_MODE|SQL_LOGFILE|SQL_LOGGING|SQL_SYNTAX| |
- | |STATISTICS_COMMENT|STATUSDISPLAY|TERMINATION|TIMEOUT|TIMER| | + | |STATISTICS|STATISTICS_COMMENT|STATUSDISPLAY|TERMINATION|TIMEOUT|TIMER| |
To see OdxSQL's current settings, issue the SET Command without any arguments. | To see OdxSQL's current settings, issue the SET Command without any arguments. | ||
> SET | > SET | ||
+ | |||
+ | To see OdxSQL's a list of all the settings and the available setting values issue the SET ? command. | ||
+ | |||
+ | > SET ? | ||
===== OdxSQL All Settings in Alphabetical Order ===== | ===== OdxSQL All Settings in Alphabetical Order ===== | ||
Line 50: | Line 54: | ||
| [[ NULL_INDICATORS]] | OFF | ON %%|%% string| | | | [[ NULL_INDICATORS]] | OFF | ON %%|%% string| | | ||
| [[ ODXSQL_DEBUG]] | | <PARSE %%|%% FILE %%|%% DEBUG %%|%% ALL> <ON %%|%% OFF> | | | | [[ ODXSQL_DEBUG]] | | <PARSE %%|%% FILE %%|%% DEBUG %%|%% ALL> <ON %%|%% OFF> | | | ||
- | | [[ OMNIDEX_DEBUG]] | OFF | ON %%|%% profile [FILE=filename] | | | + | | [[ 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| | | | [[ OPTIMIZATION]] | DEFAULT |options| | | ||
- | | [[ ODXNET]] | INACTIVE | | | | ||
| [[ PAGELENGTH]] | 24 | n | Set the page length before the paging prompt is issued.| | | [[ PAGELENGTH]] | 24 | n | Set the page length before the paging prompt is issued.| | ||
| [[PAGEWIDTH]] | 80 | n | Sets the page width of the display. | | | [[PAGEWIDTH]] | 80 | n | Sets the page width of the display. | | ||
Line 62: | Line 65: | ||
| [[QUALIFY_MODE]] | PARSER | ODXFIND %%|%% OX_FIND | Changes the Qualify Mode to internal routines. | | | [[QUALIFY_MODE]] | PARSER | ODXFIND %%|%% OX_FIND | Changes the Qualify Mode to internal routines. | | ||
| [[REDEFROWIDS]] | ON | OFF | | | | [[REDEFROWIDS]] | ON | OFF | | | ||
- | | [[REMOTE_HOST]] | NONE | | | | ||
| [[REQUIRED_OPTIMIZATION]] | NONE |options| | | | [[REQUIRED_OPTIMIZATION]] | NONE |options| | | ||
| [[SILENT_MODE]] | OFF | ON | | | | [[SILENT_MODE]] | OFF | ON | | |