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/04 19:27] tdo |
programs:odxsql:home [2012/10/26 14:26] (current) |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| ====== OdxSQL Quick Reference ====== | ====== OdxSQL Quick Reference ====== | ||
| {{page>:odxsql_bar&nofooter&noeditbtn}} | {{page>:odxsql_bar&nofooter&noeditbtn}} | ||
| - | |||
| - | |||
| ===== OdxSQL Uses ===== | ===== OdxSQL Uses ===== | ||
| - | OdxSQL is a console application for manually entering Omnidex 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. | ||
| Line 31: | 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 38: | 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. | ||
| Line 47: | Line 48: | ||
| * Use SET <cr> to show a list of the current OdxSQL settings. | * Use SET <cr> to show a list of the current OdxSQL settings. | ||
| - | * Use SET ? to get a list of OdxSQL Set options. | + | * 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 |
| | | ||
| * 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. | ||
| Line 66: | Line 67: | ||
| * Use a period ( . ) to execute the last command. | * Use a period ( . ) to execute the last command. | ||
| + | |||
| ===== See Also ===== | ===== See Also ===== | ||
| * [[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 ]] |
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||