This is an old revision of the document!


DRAFT

OdxSQL Quick Reference

OdxSQL Overview OdxSQL Commands OdxSQL SettingsOdxSQL ScriptsSQL SELECT Omnidex SQL

OdxSQL Uses

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.

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

Common ways to run OdxSQL

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

Running OdxSQL Explained:

odxsql Run OdxSQL. Use the CONNECT command to connect to an Environment
odxsql dsnfile -odxnet -odbc Run OdxSQL and an OdxNET background process and connect to the DSN using ODBC
odxsql envfile Run OdxSQL and connect to the 'envfile'
odxsql -? Displays OdxSQL command line options
odxsql -use scriptfile Run OdxSQL and read and process the scriptfile of OdxSQL Statements and Commands.

OdxSQL Important Information

  • 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.
    • Use SHOW ALL to see all tables, including internal system tables.
  • Create scripts and process with the USE <scriptfile> command or the OdxSQL -use scriptfile
  • Statements can edited with EDIT or using the UP ARROW to edit with arrow and insert/delete keys.
  • Use EDIT to edit the last statement using Windows Notepad or vi or emacs on Unix/Linux.
  • Use SET EDIT to change the editor of choice.

See Also

  • OdxSQL Command Line Options
  • OdxSQL Commands
  • OdxSQL Settings
  • OdxSQL Script Examples
  • SQL SELECT
  • SQL SELECT Examples
  • Omnidex SQL Statements
OdxSQL Overview OdxSQL Commands OdxSQL SettingsOdxSQL ScriptsSQL SELECT Omnidex SQL
 
Back to top
programs/odxsql/home.1259705696.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)