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/02 13:26] tdo |
programs:odxsql:home [2012/10/26 14:26] (current) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ~~NOTOC~~ | ~~NOTOC~~ | ||
| ====== OdxSQL Quick Reference ====== | ====== OdxSQL Quick Reference ====== | ||
| - | + | {{page>:odxsql_bar&nofooter&noeditbtn}} | |
| - | ^[[programs:odxsql:overview|OdxSQL Overview]]^ [[programs:odxsql:commands:home|OdxSQL Commands]] ^OdxSQL Settings^OdxSQL Scripts^SQL SELECT^ Omnidex SQL ^ | + | |
| ===== OdxSQL Uses ===== | ===== OdxSQL Uses ===== | ||
| - | OdxSQL is a console application for manually entering SQL Statements and OdxSQL Commands. | + | 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 Data Definition Scripts to create Omnidex Environments and Indexes. | + | Use OdxSQL for processing Omnidex SQL 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 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 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 ===== | ||
| Line 28: | Line 29: | ||
| Running OdxSQL Explained: | Running OdxSQL Explained: | ||
| | odxsql | Run OdxSQL. Use the CONNECT command to connect to an Omnidex 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 -use scriptfile | Run OdxSQL and read and process the scriptfile of OdxSQL Statements and Commands.| | ||
| Line 35: | Line 36: | ||
| * 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 |
| + | * 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>. | * OdxSQL automatically terminates commands and SQL Statements with a return <cr>. | ||
| - | * Use the backslash [ \ ]statement continuation character for multi line statements. | + | * Use the backslash %%[ \ ]%% statement continuation character for multi line statements. |
| - | * Use SET CONTINUATION OFF to use the semi-colon command and statement terminator. | + | * 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. | * 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 | + | * Create scripts with an editor and process with the USE <scriptfile> command or the OdxSQL -use scriptfile |
| | | ||
| - | * Edit the current command with EDIT | + | * Use EDIT to edit the last statement using Windows Notepad or Linux/Unix vi or emacs. |
| - | * 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 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 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. | * Edit previous commands by using the UP ARROW and scrolling through the commands. | ||
| Line 60: | Line 65: | ||
| * Use HISTORY to display a numbered list of previous commands. | * Use HISTORY to display a numbered list of previous commands. | ||
| * Use the history number to re-execute the numbered command. | * Use the history number to re-execute the numbered command. | ||
| - | * Use a period ( . ) to execute the current command. | + | * Use a period ( . ) to execute the last command. |
| Line 66: | Line 71: | ||
| * [[programs:odxsql:overview | OdxSQL Overview ]] | * [[programs:odxsql:overview | OdxSQL Overview ]] | ||
| - | * OdxSQL Command Line Options | + | * [[programs:odxsql:commands:home |OdxSQL Commands ]] |
| - | * OdxSQL Commands | + | * [[programs:odxsql:settings:home |OdxSQL Settings ]] |
| - | * OdxSQL Settings | + | * [[programs:odxsql:commandline |OdxSQL Command Line Options ]] |
| * OdxSQL Script Examples | * OdxSQL Script Examples | ||
| - | * SQL SELECT | + | * [[ dev:sql:statements:select:home | SQL SELECT ]] |
| * SQL SELECT Examples | * SQL SELECT Examples | ||
| - | * Omnidex SQL Statements | + | * [[ dev:sql:statements:home | Omnidex SQL Statements ]] |
| - | + | ||
| - | ^[[programs:odxsql:overview|OdxSQL Overview]]^ OdxSQL Commands ^OdxSQL Settings^OdxSQL Scripts^SQL SELECT^ Omnidex SQL ^ | + | |
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||