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/08 17:13] tdo |
programs:odxsql:home [2012/10/26 14:26] (current) |
||
|---|---|---|---|
| Line 33: | Line 33: | ||
| | 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.| | ||
| - | |||
| ===== OdxSQL Important Information ===== | ===== 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 |
| + | * 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 46: | 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 65: | 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}} | ||