This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
programs:odxsql:home [2009/12/01 20:34] tdo |
programs:odxsql:home [2012/10/26 14:26] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== OdxSQL Quick Notes ====== | + | {{page>:top_add&nofooter&noeditbtn}} |
| + | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| + | ~~NOTOC~~ | ||
| + | ====== OdxSQL Quick Reference ====== | ||
| + | {{page>:odxsql_bar&nofooter&noeditbtn}} | ||
| + | ===== OdxSQL Uses ===== | ||
| - | ^[[programs:odxsql:overview|OdxSQL Overview]]^Commands^Settings^Scripts^SELECT | + | OdxSQL is a console application for manually entering Omnidex SQL Statements and OdxSQL Commands or for processing scripts of Omnidex SQL statements. |
| - | OdxSQL is a console application for manually entering SQL Statements and OdxSQL Commands. | + | Use OdxSQL for processing Omnidex SQL Data Definition Scripts to create Omnidex Environments and Indexes. |
| - | Use OdxSQL for processing 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 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. |
| + | |||
| + | Use OdxSQL on a client computer to access an Omnidex Environment on a remote server via OdxNet to test network response times. | ||
| - | Common ways to run OdxSQL: | + | |
| + | ===== Common ways to run OdxSQL ===== | ||
| os> odxsql | os> odxsql | ||
| Line 16: | Line 25: | ||
| os> odxsql dsnfile -odxnet -odbc | os> odxsql dsnfile -odxnet -odbc | ||
| os> odxsql -? | os> odxsql -? | ||
| + | os> odxsql -use scriptfile | ||
| Running OdxSQL Explained: | Running OdxSQL Explained: | ||
| - | | odxsql | Run OdxSQL. Use the CONNECT command to connect to an Environment | | + | | odxsql | Run OdxSQL. Use the CONNECT command to connect to an Omnidex 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 envfile | Run OdxSQL and connect to the 'envfile' | | ||
| + | | odxsql dsnfile -odxnet -odbc | Run OdxSQL and an OdxNET background process and connect to the DSN using ODBC | | ||
| | odxsql -? | Displays OdxSQL command line options | | | 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 connects to an Omnidex Environment or ODBC or JDBC Omnidex File Datasource (DSN). | ||
| - | | + | * connect myenv.env |
| - | * OdxSQL automatically terminates commands and SQL Statements with a <cr>. | + | * connect mydsn.dsn using odbc (needs OdxNet running) |
| - | * Use the backslash [ \ ]statement continuation character for multi line statements. | + | * connect mydsn.dsn using jdbc (needs OdxNet running) |
| - | * Use SET CONTINUATION OFF to use the semi-colon command and statement terminator. | + | |
| + | * 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 <cr> to display a list of commands and SQL Statements. | ||
| * Use HELP <command> to display the syntax for the command. | * Use HELP <command> to display the syntax for the command. | ||
| - | * Use SET ? to get a list of OdxSQL Set options. | + | * 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 <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 | + | * 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. | ||
| + | |||
| - | * [[programs:odxsql:overview | OdxSQL Overview ]] | + | ===== See Also ===== |
| - | * OdxSQL Command Line Options | + | |
| - | * OdxSQL Commands | + | |
| - | * OdxSQL Settings | + | |
| - | * OdxSQL Script Examples | + | |
| - | * SQL SELECT | + | |
| - | * SQL SELECT Examples | + | |
| - | * Omnidex SQL Statements | + | |
| + | * [[programs:odxsql:overview | OdxSQL Overview ]] | ||
| + | * [[programs:odxsql:commands:home |OdxSQL Commands ]] | ||
| + | * [[programs:odxsql:settings:home |OdxSQL Settings ]] | ||
| + | * [[programs:odxsql:commandline |OdxSQL Command Line Options ]] | ||
| + | * OdxSQL Script Examples | ||
| + | * [[ dev:sql:statements:select:home | SQL SELECT ]] | ||
| + | * SQL SELECT Examples | ||
| + | * [[ dev:sql:statements:home | Omnidex SQL Statements ]] | ||
| + | {{page>:bottom_add&nofooter&noeditbtn}} | ||