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 03:00] tdo |
programs:odxsql:commands:home [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 7: | Line 7: | ||
OdxSQL processes Omnidex SQL statements and OdxSQL specific commands either interactively or in batch oriented script files via the USE command. | 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 SQL Statements and OdxSQL commands organized by type with a complete alphabetic list shown below. | + | 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 28: | Line 28: | ||
| [[dev:sql:statements:update:home |UPDATE]] | Issue an Omnidex SQL UPDATE Statement. | | | [[dev:sql:statements:update:home |UPDATE]] | Issue an Omnidex SQL UPDATE Statement. | | ||
| [[dev:sql:statements:delete:home | DELETE]] | Issue the SQL DELETE Statement. | | | [[dev:sql:statements:delete:home | DELETE]] | Issue the SQL DELETE Statement. | | ||
- | |||
===== Omnidex SQL Data Definition Language (DDL) Statements ===== | ===== Omnidex SQL Data Definition Language (DDL) Statements ===== | ||
^ DDL Statement ^ Description ^ | ^ DDL Statement ^ Description ^ | ||
Line 42: | Line 41: | ||
| [[programs:odxsql:commands:drop_index|DROP INDEX]] | Drop Index. | | | [[programs:odxsql:commands:drop_index|DROP INDEX]] | Drop Index. | | ||
| [[programs:odxsql:commands:drop_indexes|DROP INDEXES]] | Drop Indexes. | | | [[programs:odxsql:commands:drop_indexes|DROP INDEXES]] | Drop Indexes. | | ||
+ | | [[programs:odxsql:commands:show_ddl|SHOW DDL]] | Show Data Definition Statements. | | ||
+ | |||
===== Additional Omnidex SQL DML Statements ===== | ===== Additional Omnidex SQL DML Statements ===== | ||
^ 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 108: | Line 110: | ||
| [[programs:odxsql:commands:error|ERROR]] | Display the text of an error message from the Omnidex Error Message file. | | | [[programs:odxsql:commands:error|ERROR]] | Display the text of an error message from the Omnidex Error Message file. | | ||
| [[programs:odxsql:commands:execsql|EXECSQL]] | Execute an Omnidex SQL Statement directly with the oaexecsql routine without OdxSQL doing any processing. | | | [[programs:odxsql:commands:execsql|EXECSQL]] | Execute an Omnidex SQL Statement directly with the oaexecsql routine without OdxSQL doing any processing. | | ||
- | | [[programs:odxsql:commands:sleep|SLEEP]] | Sleep for a specified number of seconds. | | + | |
===== OdxSQL Operating System Commands ===== | ===== OdxSQL Operating System Commands ===== | ||
Line 126: | Line 128: | ||
| [[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 193: | Line 194: | ||
| [[programs:odxsql:commands:set|SET]] | Both | Set an OdxSQL setting. | | | [[programs:odxsql:commands:set|SET]] | Both | Set an OdxSQL setting. | | ||
| [[programs:odxsql:commands:show|SHOW]] | Command |Show Omnidex Environment information including Databases, Tables, Column layouts, Query Statistics, etc. | | | [[programs:odxsql:commands:show|SHOW]] | Command |Show Omnidex Environment information including Databases, Tables, Column layouts, Query Statistics, etc. | | ||
+ | | [[programs:odxsql:commands:show_ddl|SHOW DDL]] | Show Data Definition Statements. | | ||
| [[programs:odxsql:commands:signal|SIGNAL]] | Command | Sends a Signal to a process. | | | [[programs:odxsql:commands:signal|SIGNAL]] | Command | Sends a Signal to a process. | | ||
- | | [[programs:odxsql:commands:sleep|SLEEP]] | Command | Sleep for a specified number of seconds. | | ||
| [[programs:odxsql:commands:update|UPDATE]] | Statement | Issue an Omnidex SQL UPDATE Statement. | | | [[programs:odxsql:commands:update|UPDATE]] | Statement | Issue an Omnidex SQL UPDATE Statement. | | ||
| [[programs:odxsql:commands:update_indexes|UPDATE INDEXES]] |Statement | Update Omnidex Indexes | | | [[programs:odxsql:commands:update_indexes|UPDATE INDEXES]] |Statement | Update Omnidex Indexes | | ||
Line 203: | Line 204: | ||
| [[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. | | ||