OdxSQL Quick Reference

OdxSQL is a console application for manually entering Omnidex SQL Statements and OdxSQL Commands or for processing scripts of Omnidex SQL statements.

Use OdxSQL for processing Omnidex SQL Data Definition Scripts to create Omnidex Environments and Indexes.

Use OdxSQL to test Omnidex SQL SELECTs and ODBC, JDBC and Network Services set up.

Use OdxSQL to prototype Omnidex Queries and use the Explain Command to review optimization.

Use OdxSQL on a client computer to access an Omnidex Environment on a remote server via OdxNet to test network response times.

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

Running OdxSQL Explained:

• OdxSQL connects to an Omnidex Environment or ODBC or JDBC Omnidex File Datasource (DSN).
  • connect myenv.env
  • connect mydsn.dsn using odbc (needs OdxNet running)
  • connect mydsn.dsn using jdbc (needs OdxNet running)

• OdxSQL automatically terminates commands and SQL Statements with a return <cr>.
  • Use the backslash [ \ ] statement continuation character for multi line statements.
  • Use SET CONTINUATION OFF to use the semicolon character as the 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 <cr> to show a list of the current OdxSQL settings.
  • 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.
  • Use SHOW ALL to see all tables, including internal system tables.

• Create scripts with an editor and process with the USE <scriptfile> command or the OdxSQL -use scriptfile

• Use EDIT to edit the last statement using Windows Notepad or Linux/Unix vi or emacs.
• Use SET EDIT to change the editor of choice.
• Use EDIT file to edit a script file without leaving OdxSQL and then USE file to run.
• Use EDIT n to edit a command in the Command History Stack.

• Edit previous commands by using the UP ARROW and scrolling through the commands.
  • Use the Right and Left Arrow, Insert, Delete, Home, and End keys to edit.

• Use HISTORY to display a numbered list of previous commands.
  • Use the history number to re-execute the numbered command.
  • Use a period ( . ) to execute the last command.

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