OdxSql is an Omnidex interactive SQL utility used for testing installations, prototyping queries, and exporting data. OdxSql supports many functions designed to assist in creating fully optimized installations and queries including benchmarking and the explain plan.
OdxSql allows the interactive specification of SQL statements using supported SQL 92 syntax. OdxSql also fully supports the Omnidex Query Language as well as several additional functions exclusive to OdxSql.
Run OdxSql from the command line with the following syntax:
odxsql [environment_name] | [-use=use_file]
Type help at the command prompt with no arguments to see an alphabetical list of ODXSQL commands.
Type help with the argument 'syntax' at the command prompt to see a list of commands with their syntax.
Type help followed by a specific command to see additional information about that command.