Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
programs:odxsql:home [2010/07/04 01:36]
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|
 +|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|
  
-  [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|[NO]NODES>​ 
-  [FILE_BASELINE] 
-  [HEADERS <ON | OFF>] 
-  [HEX <ON | OFF | ONLY>] 
-  [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>] 
- 
- 
-{{page>:​bottom_add&​nofooter&​noeditbtn}} 
 
Back to top
programs/odxsql/home.1278207375.txt.gz · Last modified: 2012/10/26 14:48 (external edit)