This is an old revision of the document!


DRAFT

OdxSQL Quick Reference

Command Line Options Description
odxsql Run OdxSQL. Use the CONNECT command to connect to an Omnidex Environment
odxsql env_filespec Run OdxSQL and connect to the env_filespec.
odxsql dsn_filespec -odbc Run OdxSQL and connect to the ODBC File DSN using the Omnidex ODBC driver.
odxsql env_filespec -odxnet -jdbc Run OdxSQL and start an OdxNet background process and connect to the env_filespec using the Omnidex JDBC driver.
odxsql -? Displays OdxSQL command line options
odxsql -use scriptfile Run OdxSQL and read and process the scriptfile of OdxSQL Statements and Commands.
Set Command
SET Shows the current settings.
SET ? Shows the list of available SET options.
SET TERMINATION OFFWill process SQL Statements without requiring a semi-colon terminator.
SET TIMER ONUseful to show how long a statement takes to process.
Help/Show
HELPShows a list of OdxSQL commands and SQL Statements.
HELP <command>Provides specific help on the specified command or SQL Statement.
SHOW <table>Provides information on the specified table.
SHOW ALLProvides information on all tables.
Editing
EDIT Launch editor and send current SQL Statement to either Windows Notedpad or UNIX/Linux vi or emacs.
SET EDITOR <filespec>Change the default editor. Can also be NOTEPAD, WORDPAD, VI or EMACS.
EDIT filespecTypically used to edit a script file and then use the USE file to run the script.
EDIT nEdits the command in the Command History Stack
Other Commands
HISTORYShows a numbered list of previously entered commands.
<command_number>Execute the numbered command from the Command History Stack.
Period(.)Execute the last command.
Comment (;) A semi-colon as the first character causes the rest of the line to be a comment.
USE <filespec>Processes the OdxSQL commands in a script file.
EXPLAINShows the Explain Plan for the previous SELECT Statement.
SET AUTOEXPLAIN ONAutomatically show the Explain after a SELECT Statement.
OdxSQL Settings
API AUTODISPLAY AUTOEXPLAIN AUTOFETCH AUTOPSEUDOCOLUMNS AUTORECONNECT
AUTOSUBPROCESSCHARCURSORCURSORDISPLAYDEFAULTSEDITOR
ENDIAN ERRORDISPLAYERRORSEXPLAIN SETFILE_BASELINEHEADERS
HEXHISTORYINTERRUPTSMEMORY_BASELINEMULTICONNECTMULTILINE
NULL_INDICATORSOMNIDEX_DEBUGOPTIMIZATIONODXSQL_DEBUGPAGELENGTHPAGEWIDTH
PREPROCESSORPROGRESSPROMPTPSEUDOCOLUMNSQUALIFY_COUNTSREDEFROWIDS
REQUIRED_OPTIMIZATIONSILENT_MODESQL_LOGFILESQL_LOGGINGSQL_SYNTAXSTATISTICS
STATISTICS_COMMENTSTATUSDISPLAYTERMINATIONTIMEOUTTIMER
 
Back to top
programs/odxsql/home.1278208688.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)