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 [2009/12/01 20:30]
tdo
programs:odxsql:home [2016/06/28 22:38] (current)
Line 1: Line 1:
-====== OdxSQL Quick Notes ======+{{page>:​top_add&​nofooter&​noeditbtn}}
  
-^[[programs:​odxsql:​overview|Overview]]^Commands^Odx SQL^ 
  
-OdxSQL ​is a console application for manually entering SQL Statements and OdxSQL Commands.+====== Programs: ​OdxSQL ​======
  
-Use OdxSQL for processing Data Definition Scripts to create Omnidex Environments and Indexes.+**[[programs:​odxsql:​home|Overview]]** | [[programs:​odxsql:​commands|Commands]] | [[programs:​odxsql:​options|Options]] | [[programs:​odxsql:​cmdline|Command-line]] | [[programs:​odxsql:​files|Command Files]] ​
  
-Use OdxSQL to test SQL SELECTs and ODBC, JDBC and Network Services set up. 
  
-  +----
-Common ways to run OdxSQL+
  
-  os> odxsql 
-  os> odxsql envfile 
-  os> odxsql dsnfile -odxnet -odbc 
-  os> odxsql -? 
  
-Explained:  +===== Overview =====
-| odxsql | Run OdxSQL. ​ Use the CONNECT command to connect to an Environment | +
-| odxsql dsnfile -odxnet -odbc | Run OdxSQL and an OdxNET background process and connect to the DSN using ODBC | +
-| odxsql envfile | Run OdxSQL and connect to the '​envfile'​ | +
-| odxsql -? | Displays OdxSQL command line options |+
  
-  * OdxSQL ​connects ​to an Omnidex Environment ​or ODBC or JDBC Omnidex ​File Datasource (DSN). +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.
-   +
-  * OdxSQL ​automatically terminates commands and SQL Statements with a <​cr>​. +
-    * Use the backslash [ \ ]statement continuation character ​for multi line statements.  +
-    * Use SET CONTINUATION OFF to use the semi-colon command and statement terminator.+
  
-  * Use HELP <cr> to display a list of commands and SQL Statements. +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.
-    * Use HELP <​command> ​to display ​the syntax for the command.+
  
-  * Use SET ? to get a list of OdxSQL ​Set options.+===== Running ​OdxSQL ​===== 
  
-  * Use Show <​table>​ to show information on a table with the tables'​s column layout.+On Microsoft Windows, OdxSQL is run from the Start menu or from the CMD shell, as shown below.
  
-  ​Create scripts ​+<​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}}
  
-  * [[programs:​odxsql:​overview | OdxSQL Overview ]] 
-  * OdxSQL Command Line Options 
-  * OdxSQL Commands 
-  * OdxSQL Settings 
-  * OdxSQL Script Examples 
-  * SQL SELECT 
-  * SQL SELECT Examples 
-  * Omnidex SQL Statements 
  
  
 
Back to top
programs/odxsql/home.1259699445.txt.gz · Last modified: 2016/06/28 22:38 (external edit)