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/03 21:51]
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 ====== 
  
-^[[programs:​odxsql:​overview|OdxSQL Overview]]^ [[programs:​odxsql:​commands:​home|OdxSQL Commands]] ^[[programs:​odxsql:​settings:​home | OdxSQL Settings ]]^OdxSQL Scripts^SQL SELECT^ Omnidex SQL ^ 
-===== OdxSQL Uses ===== 
  
-OdxSQL ​is a console application for manually entering Omnidex 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. 
  
-Use OdxSQL to prototype Omnidex Queries and use the Explain Command to review optimization.+----
  
-Use OdxSQL on a Client machine to access an Omnidex Environment on a remote server via OdxNet to test network response times. 
  
- +===== Overview =====
  
-===== Common ways to run OdxSQL ​=====+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.
  
-  os> odxsql +===== Running OdxSQL ===== 
-  os> odxsql envfile +
-  os> odxsql dsnfile -odxnet -odbc +
-  os> odxsql -? +
-  os> odxsql -use scriptfile+
  
-Running ​OdxSQL ​Explained:  +On Microsoft Windows, ​OdxSQL ​is run from the Start menu or from the CMD shell, as shown below.
-| odxsql | Run OdxSQL. ​ Use the CONNECT command to connect to an Omnidex 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 -use scriptfile | Run OdxSQL and read and process the scriptfile of OdxSQL Statements and Commands.+
-===== OdxSQL Important Information =====+
  
-  * OdxSQL connects to an Omnidex Environment or ODBC or JDBC Omnidex ​File Datasource ​(DSN). +<​code>​ 
-   +D:​\db\simple>​odxsql 
-  * OdxSQL automatically terminates commands and SQL Statements with a return <cr>. +ODXSQL - Omnidex ​SQL                                  Wed, Jun 10, 2015 11:28am 
-    * Use the backslash %%[ \ ]%% statement continuation character for multi line statements.  +(cDynamic Information Systems Corp1981-2015 ​             Enterprise 5.3.09C 
-    * Use SET CONTINUATION OFF to use the semicolon character as the statement terminator.+Microsoft Windows Server 2012 R2 Standard ​                 WIN2 / administrator 
 +Dynamic Information Systems Corp
  
-  * Use HELP <cr> to display a list of commands and SQL Statements. 
-    * Use HELP <​command>​ to display the syntax for the command. 
  
-  * Use SET <crto show a list of the current OdxSQL settings. +
-  * Use SET ? to get a list of OdxSQL Set options.+</​code>​
  
-  * Use SHOW <​table>​ to show information on a table with the tables'​s column layout. +On Linux, OdxSQL is run from your preferred shell, whether bash, kornor some other shell 
-    * Use SHOW ALL to see all tablesincluding internal system tables.+
  
-  * Create scripts and process with the USE <scriptfilecommand or the OdxSQL -use scriptfile +<code>
-     +
-  * Use EDIT to edit the last statement using Windows Notepad or Linux/Unix vi or emacs. +
-    * Use SET EDIT to change the editor of choice. +
-    * Use EDIT file to edit a script file without leaving OdxSQL and then USE file to run. +
-    * Use EDIT n to edit a command in the Command History Stack.+
  
-  * Edit previous commands by using the UP ARROW and scrolling through the commands. +lnx3> [/home/db]$ odxsql 
-    * Use the Right and Left ArrowInsertDelete, Home, and End keys to edit.+ODXSQL - Omnidex SQL                                  WedJun 102015 11:37am 
 +(c) Dynamic Information Systems Corp1981-2015 ​             Enterprise 5.3.09C 
 +Linux 2.6.32-431.20.3.el6.x86_64 ​                                  lnx3 / oadev 
 +Dynamic Information Systems Corp
  
-  * Use HISTORY to display a numbered list of previous commands. 
-    * Use the history number to re-execute the numbered command. 
-    * Use a period ( . ) to execute the last command. 
-  
  
-===== See Also =====+
 +</​code>​
  
-    * [[programs:​odxsql:​overview | OdxSQL Overview ]] +=====  =====
-    * OdxSQL Command Line Options +
-    * OdxSQL Commands +
-    * OdxSQL Settings +
-    * OdxSQL Script Examples +
-    * SQL SELECT +
-    * SQL SELECT Examples +
-    * Omnidex SQL Statements+
  
-^[[programs:​odxsql:​overview|OdxSQL Overview]]^ ​[[programs:​odxsql:​commands:home|OdxSQL Commands]] ^OdxSQL Settings^OdxSQL Scripts^SQL SELECT^ Omnidex SQL ^+**[[programs:​odxsql:​commands|Next]]**
  
 +====== Additional Resources ======
 +
 +See also: 
 +
 +{{page>:​programs:​see_also&​nofooter&​noeditbtn}}
  
 {{page>:​bottom_add&​nofooter&​noeditbtn}} {{page>:​bottom_add&​nofooter&​noeditbtn}}
 +
 +
 +
 
Back to top
programs/odxsql/home.1259877062.txt.gz · Last modified: 2016/06/28 22:38 (external edit)