OdxSQL Quick Notes

• Common ways to run OdxSQL

os> odxsql
os> odxsql envfile
os> odxsql dsnfile -odxnet -odbc
os> odxsql -?

Explained:

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

• OdxSQL automatically terminates commands and SQL Statements.
• 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 the table and the column layout.

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