OdxSQL Quick Notes

• Common ways to run OdxSQL

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

^ ^ ^

• 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 statements.
• 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