This is an old revision of the document!
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.
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.
Common ways to run OdxSQL:
os> odxsql os> odxsql envfile os> odxsql dsnfile -odxnet -odbc os> odxsql -? os> odxsql -use script_file
Running OdxSQL Explained:
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. |