This is an old revision of the document!


OdxSQL Quick Notes

  • Common ways to run OdxSQL
os> odxsql
os> odxsql envfile
os> odxsql dsnfile -odxnet -odbc
os> 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 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 Command Line Options
  • OdxSQL Commands
  • OdxSQL Settings
  • SQL SELECT
  • SQL SELECT Examples
  • Omnidex SQL Statements
 
Back to top
programs/odxsql/home.1259698238.txt.gz ยท Last modified: 2012/10/26 14:25 (external edit)