This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
programs:odxsql:home [2009/12/01 20:50] 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> | ||
| - | ====== OdxSQL Quick Notes ====== | ||
| - | ^[[programs:odxsql:overview|OdxSQL Overview]]^ OdxSQL Commands ^OdxSQL Settings^OdxSQL Scripts^SQL SELECT^ Omnidex 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. | ||
| - | Use OdxSQL to prototype Omnidex Queries and use the Explain Command to review optimization. | + | ---- |
| - | |||
| - | Common ways to run OdxSQL: | ||
| - | os> odxsql | + | ===== Overview ===== |
| - | os> odxsql envfile | + | |
| - | os> odxsql dsnfile -odxnet -odbc | + | |
| - | os> odxsql -? | + | |
| - | os> odxsql -use scriptfile | + | |
| - | Running OdxSQL Explained: | + | 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 | 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 -use scriptfile | Run OdxSQL and read and process the scriptfile of OdxSQL Statements and Commands.| | + | |
| - | * OdxSQL connects to an Omnidex Environment or ODBC or JDBC Omnidex File Datasource (DSN). | + | 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. |
| - | + | ||
| - | * 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. | + | ===== Running OdxSQL ===== |
| - | * Use HELP <command> to display the syntax for the command. | + | |
| - | * Use SET ? to get a list of OdxSQL Set options. | + | On Microsoft Windows, OdxSQL is run from the Start menu or from the CMD shell, as shown below. |
| - | * Use Show <table> to show information on a table with the tables's column layout. | + | <code> |
| - | * Use SHOW ALL to see all tables, including internal system tables. | + | 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 | ||
| - | * Create scripts and process with the USE <scriptfile> command or the OdxSQL -use scriptfile | ||
| - | | ||
| - | * See Also: | ||
| - | * [[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]]^ OdxSQL Commands ^OdxSQL Settings^OdxSQL Scripts^SQL SELECT^ Omnidex SQL ^ | + | > |
| + | </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}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||
| + | |||
| + | |||