This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
programs:odxsql:home [2010/07/04 01:40] tdo |
programs:odxsql:home [2012/10/26 14:51] (current) |
||
|---|---|---|---|
| Line 29: | Line 29: | ||
| |HISTORY|Shows a numbered list of previously entered commands.| | |HISTORY|Shows a numbered list of previously entered commands.| | ||
| |<command_number>|Execute the numbered command from the Command History Stack.| | |<command_number>|Execute the numbered command from the Command History Stack.| | ||
| - | |Period(.)|Execute the last command.| | + | |Period (.)|Execute the last command.| |
| + | |Comment (;) | A semi-colon as the first character causes the rest of the line to be a comment. | | ||
| |USE <filespec>|Processes the OdxSQL commands in a script file.| | |USE <filespec>|Processes the OdxSQL commands in a script file.| | ||
| + | |SET ERRORS | Sets how errors will be handled when processing a USE file. | | ||
| |EXPLAIN|Shows the Explain Plan for the previous SELECT Statement.| | |EXPLAIN|Shows the Explain Plan for the previous SELECT Statement.| | ||
| - | |SET AUTOEXPLAIN ON|Automatically show the Explain after a SELECT Statement.| | + | |SET AUTOEXPLAIN ON|Automatically show the Explain Plan instead of the SELECT output.| |
| + | |SET EXPLAIN |Sets options for the Explain Plan. | | ||
| - | ^ OdxSQL Settings ^ | + | ^ OdxSQL Settings ^ ^ ^ ^ ^ ^ |
| |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 SET|FILE_BASELINE|HEADERS| | ||
| |HEX|HISTORY|INTERRUPTS|MEMORY_BASELINE|MULTICONNECT|MULTILINE| | |HEX|HISTORY|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| | ||
| - | |||
| - | [HISTORY n] | ||
| - | [INSTANCE n] | ||
| - | [INTERRUPTS <ON | OFF | API>] | ||
| - | Press <RETURN> to continue or '/' to stop paging ... | ||
| - | [MEMORY_BASELINE] | ||
| - | [MULTICONNECT] <ON | OFF> | ||
| - | [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]] | ||
| - | [SQL_SYNTAX <OMNIDEX | ORACLE | SQLSERVER>] | ||
| - | [STATISTICS <ON | OFF | filename>] | ||
| - | [STATISTICS_COMMENT "string"] | ||
| - | Press <RETURN> to continue or '/' to stop paging ... | ||
| - | [STATUSDISPLAY <ON | OFF>] | ||
| - | [TERMINATION <ON | OFF>] | ||
| - | [TIMEOUT <seconds | OFF>] | ||
| - | [TIMER <ON | CUMULATIVE | OFF>] | ||