This shows you the differences between two versions of the page.
|
programs:odxsql:home [2015/06/10 17:39] doc |
programs:odxsql:home [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | |||
| - | |||
| - | ====== Programs: OdxSQL ====== | ||
| - | |||
| - | **[[programs:odxsql:home|Overview]]** | [[programs:odxsql:commands|Commands]] | [[programs:odxsql:options|Options]] | [[programs:odxsql:cmdline|Command-line]] | [[programs:odxsql:files|Command Files]] | ||
| - | |||
| - | |||
| - | ---- | ||
| - | |||
| - | |||
| - | ===== 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}} | ||
| - | |||
| - | |||