This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
programs:odxsql:commands:home [2009/12/08 02:56] tdo |
programs:odxsql:commands:home [2012/10/26 14:28] (current) |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| <html><div align="center"><span style="color:red">DRAFT</span></div></html> | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| ~~NOTOC~~ | ~~NOTOC~~ | ||
| - | ====== OdxSQL Commands ====== | + | ====== OdxSQL Commands and Omnidex SQL Statements ====== |
| {{page>:odxsql_bar&nofooter&noeditbtn}} | {{page>:odxsql_bar&nofooter&noeditbtn}} | ||
| + | |||
| + | OdxSQL processes Omnidex SQL statements and OdxSQL specific commands either interactively or in batch oriented script files via the USE command. | ||
| + | |||
| + | The following is a list of Omnidex SQL Statements and OdxSQL commands organized by type with a complete alphabetic list shown below. | ||
| ===== Connecting and Disconnecting ===== | ===== Connecting and Disconnecting ===== | ||
| Line 41: | Line 45: | ||
| ^ DML Statement ^ Description ^ | ^ DML Statement ^ Description ^ | ||
| - | | [[programs:odxsql:commands:join|JOIN]] | Statement | Join tables using Omnidex Indexes. | | + | | [[programs:odxsql:commands:join|JOIN]] | Join tables using Omnidex Indexes. | |
| - | | [[programs:odxsql:commands:qualify|QUALIFY]] | Statement | Qualify rows using Omnidex criteria. | | + | | [[programs:odxsql:commands:qualify|QUALIFY]] | Qualify rows using Omnidex criteria. | |
| - | | [[programs:odxsql:commands:fetch|FETCH]] | Statement | Explicitly fetch data from the database. | | + | | [[programs:odxsql:commands:fetch|FETCH]] | Explicitly fetch data from the database. | |
| - | | [[programs:odxsql:commands:fetchkeys|FETCHKEYS]] | Statement | Explicitly fetch keys from the Omnidex Indexes. | | + | | [[programs:odxsql:commands:fetchkeys|FETCHKEYS]] | Explicitly fetch keys from the Omnidex Indexes. | |
| - | | [[programs:odxsql:commands:open_cursor|OPEN CURSOR]] | Statement | Open a Cursor. | | + | | [[programs:odxsql:commands:open_cursor|OPEN CURSOR]] | Open a Cursor. | |
| - | | [[programs:odxsql:commands:close_cursor|CLOSE CURSOR]] | Statement | Close a previously opened cursor. | | + | | [[programs:odxsql:commands:close_cursor|CLOSE CURSOR]] | Close a previously opened cursor. | |
| ===== Omnidex SQL Operational Statements ===== | ===== Omnidex SQL Operational Statements ===== | ||
| Line 122: | Line 127: | ||
| | [[programs:odxsql:commands:rename|RENAME]] | Rename a file or fileset in the underlying Operating System. | | | [[programs:odxsql:commands:rename|RENAME]] | Rename a file or fileset in the underlying Operating System. | | ||
| | [[programs:odxsql:commands:view |VIEW]] | View a text file. | | | [[programs:odxsql:commands:view |VIEW]] | View a text file. | | ||
| - | |||
| ===== Alphabetical List of OdxSQL Commands and Omnidex SQL Statements ===== | ===== Alphabetical List of OdxSQL Commands and Omnidex SQL Statements ===== | ||
| Line 199: | Line 203: | ||
| | [[programs:odxsql:commands:use|USE]] | Command | Read and process a file of OdxSQL Commands and Omnidex SQL Statements, optionally with WHERE criteria. | | | [[programs:odxsql:commands:use|USE]] | Command | Read and process a file of OdxSQL Commands and Omnidex SQL Statements, optionally with WHERE criteria. | | ||
| | [[programs:odxsql:commands:validate|VALIDATE]] | Command | Validate the Omnidex Environment's view of the underlying data. To be removed in 5.1 | | | [[programs:odxsql:commands:validate|VALIDATE]] | Command | Validate the Omnidex Environment's view of the underlying data. To be removed in 5.1 | | ||
| - | | [[programs:odxsql:commands:version|VERSION]] | Both | Display current Omnidex Software versions. | | + | | [[programs:odxsql:commands:version|VERSION]] | Command | Display current Omnidex Software versions. | |
| | [[programs:odxsql:commands:view | VIEW]] | Command | View a text file. | | | [[programs:odxsql:commands:view | VIEW]] | Command | View a text file. | | ||