This is an old revision of the document!
OdxSQL is a console application for manually entering Omnidex SQL Statements and OdxSQL Commands.
Use OdxSQL for processing Data Definition Scripts to create Omnidex Environments and Indexes.
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 computer to access an Omnidex Environment on a remote server via OdxNet to test network response times.
os> odxsql os> odxsql envfile os> odxsql dsnfile -odxnet -odbc os> odxsql -? os> odxsql -use scriptfile
Running OdxSQL Explained:
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. |