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/06 19:23]
tdo
programs:odxsql:home [2016/06/28 22:38] (current)
Line 1: Line 1:
 {{page>:​top_add&​nofooter&​noeditbtn}} {{page>:​top_add&​nofooter&​noeditbtn}}
-<​html><​div align="​center"><​span style="​color:​red">​DRAFT</​span></​div></​html>​ 
-~~NOTOC~~ 
-====== OdxSQL Quick Reference ====== 
-{{page>:​sql_odxsql_bar&​nofooter&​noeditbtn}} 
-^ Command Line Options ^ Description ^ 
-| odxsql | Run OdxSQL. ​ Use the CONNECT command to connect to an Omnidex Environment | 
-| odxsql env_filespec | Run OdxSQL and connect to the env_filespec. | 
-| odxsql dsn_filespec -odbc |Run OdxSQL and connect to the ODBC File DSN using the Omnidex ODBC driver.| 
-| odxsql env_filespec -odxnet -jdbc |Run OdxSQL and start an OdxNet background process and connect to the env_filespec using the Omnidex JDBC driver.| 
-| odxsql -? | Displays OdxSQL command line options | 
-| odxsql -use scriptfile | Run OdxSQL and read and process the scriptfile of OdxSQL Statements and Commands.| 
-^Set Command ^ ^ 
-|SET| Shows the current settings. | 
-|SET ? | Shows the list of available SET options. | 
-|SET TERMINATION OFF|Will process SQL Statements without requiring a semi-colon terminator.| 
-|SET TIMER ON|Useful to show how long a statement takes to process.| 
-^ Help/Show ^ ^ 
-|HELP|Shows a list of OdxSQL commands and SQL Statements.| 
-|HELP <​command>​|Provides specific help on the specified command or SQL Statement.| 
-|SHOW <​table>​|Provides information on the specified table.| 
-|SHOW ALL|Provides information on all tables.| 
-^Editing^ ^ 
-|EDIT| Launch editor and send current SQL Statement to either Windows Notedpad or UNIX/Linux vi or emacs. | 
-|SET EDITOR <​filespec>​|Change the default editor. Can also be NOTEPAD, WORDPAD, VI or EMACS.| 
-|EDIT filespec|Typically used to edit a script file and then use the USE file to run the script.| 
-|EDIT n|Edits the command in the Command History Stack|. 
-^Other Commands^ ^ 
-|HISTORY|Shows a numbered list of previously entered commands.| 
-|<​command_number>​|Execute the numbered command from the Command History Stack.| 
-|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.| 
-|SET ERRORS | Sets how errors will be handled when processing a USE file. | 
-|EXPLAIN|Shows the Explain Plan for the previous 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 ^ ^ ^ ^ ^ ^ + 
-|API |AUTODISPLAY |AUTOEXPLAIN |AUTOFETCH |AUTOPSEUDOCOLUMNS |AUTORECONNECT| +====== Programs: ​OdxSQL ​====== 
-|AUTOSUBPROCESS|CHAR|CURSOR|CURSORDISPLAY|DEFAULTS|EDITOR| + 
-|ENDIAN |ERRORDISPLAY|ERRORS|EXPLAIN SET|FILE_BASELINE|HEADERS+**[[programs:​odxsql:​home|Overview]]** ​[[programs:​odxsql:​commands|Commands]] ​[[programs:​odxsql:​options|Options]] ​[[programs:​odxsql:​cmdline|Command-line]] ​[[programs:​odxsql:​files|Command Files]] ​ 
-|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|+ 
 +===== Overview ===== 
 + 
 +The OdxSQL program is a console-based utility for issuing Omnidex statements and viewing their results. ​ OdxSQL allows customers to test or execute nearly every capability in Omnidex. ​ Furthermore,​ OdxSQL can be easily integrated into shell scripts for use in automated batch operations. 
 + 
 +By default, OdxSQL executes statements against an Omnidex environment;​ however, OdxSQL can also be run as an ODBC or JDBC client tool.  In this scenario, the commands entered in OdxSQL are redirected to either the ODBC client interface or the JDBC client interface, which in turn a executed through Omnidex Network Services to the Omnidex server. ​ This allows a wide range of tests to be performed against these interfaces. ​ Note that two other programs, OdbcSQL and JdbcSQL, also provide similar capabilities. 
 + 
 +===== Running OdxSQL =====  
 + 
 +On Microsoft Windows, OdxSQL is run from the Start menu or from the CMD shell, as shown below. 
 + 
 +<​code>​ 
 +D:​\db\simple>​odxsql 
 +ODXSQL - Omnidex SQL                                  Wed, Jun 10, 2015 11:28am 
 +(c) Dynamic Information Systems Corp. 1981-2015 ​             Enterprise 5.3.09C 
 +Microsoft Windows Server 2012 R2 Standard ​                 WIN2 / administrator 
 +Dynamic Information Systems Corp 
 + 
 + 
 +
 +</​code>​ 
 + 
 +On Linux, OdxSQL is run from your preferred shell, whether bash, korn, or some other shell. ​  
 + 
 +<​code>​ 
 + 
 +lnx3> [/home/db]$ odxsql 
 +ODXSQL - Omnidex SQL                                  Wed, Jun 10, 2015 11:37am 
 +(c) Dynamic Information Systems Corp. 1981-2015 ​             Enterprise 5.3.09C 
 +Linux 2.6.32-431.20.3.el6.x86_64 ​                                  lnx3 / oadev 
 +Dynamic Information Systems Corp 
 + 
 + 
 +
 +</​code>​ 
 + 
 +=====  ===== 
 + 
 +**[[programs:​odxsql:​commands|Next]]** 
 + 
 +====== Additional Resources ====== 
 + 
 +See also:  
 + 
 +{{page>:​programs:​see_also&​nofooter&​noeditbtn}} 
 + 
 +{{page>:​bottom_add&​nofooter&​noeditbtn}} 
 + 
  
 
Back to top
programs/odxsql/home.1278444190.txt.gz · Last modified: 2016/06/28 22:38 (external edit)