OdxSQL Quick Notes

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 -?

Running OdxSQL Explained:

• OdxSQL connects to an Omnidex Environment or ODBC or JDBC Omnidex File Datasource (DSN).

• 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.
  • Use HELP <command> to display the syntax for the command.

• Use SET ? to get a list of OdxSQL Set options.

• Use Show <table> to show information on a table with the tables's column layout.

• Create scripts

• OdxSQL Overview
• OdxSQL Command Line Options
• OdxSQL Commands
• OdxSQL Settings
• OdxSQL Script Examples
• SQL SELECT
• SQL SELECT Examples
• Omnidex SQL Statements