This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:overview [2009/11/29 22:34] tdo |
dev:sql:overview [2012/10/26 14:26] (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> | ||
| ====== Omnidex SQL Reference ====== | ====== Omnidex SQL Reference ====== | ||
| + | {{page>:sql_bar&nofooter&noeditbtn}} | ||
| + | |||
| ===== Overview ===== | ===== Overview ===== | ||
| - | Omnidex SQL is a rich implementation of the SQL2 and SQL99 standards along with extensions specific to Omnidex. | ||
| - | Omnidex SQL statements can be tested and scripted using the [[programs:odxsql:overview|ODXSQL]] program. | + | Omnidex provides a high-level SQL interface to access databases enhanced with Omnidex indexes. The SQL supported is a subset of the ANSI SQL2 and ANSI SQL99 standard along with some very powerful extensions specific to Omnidex. |
| - | ===== Statements by Type ===== | + | SQL should be used for all Omnidex application development including ODBC applications, Java applications using the Omnidex JDBC driver, and OmniAccess applications through oaexecsql. The Query Language extensions work in conjunction with the SQL standard syntax, in all types of applications. |
| - | ==== Data Manipulation Statements ==== | + | |
| - | | SELECT | Select data | | + | Third party ODBC tools such as Microstratey, Cognos Impromptu, and Microsoft's Query, Access, Excel, and Word communicate with Omnidex via the Omnidex ODBC driver. |
| - | | INSERT | Insert data | | + | Development tools such as Microsoft's Interdev, Visual Basic, and Visual C++ can communicate with Omnidex via the OmniAccess API or the Omnidex ODBC driver using object layers such as ActiveX Data Objects (ADO). |
| - | | DELETE | Delete data | | + | |
| - | | UPDATE | Update data | | + | Java applications such as applets, servlets, and standard console applications can communicate with Omnidex via the Omnidex JDBC driver. |
| - | | QUALIFY | Qualify rows using Omnidex criteria | | + | |
| + | Omnidex SQL is a rich implementation of the SQL2 and SQL99 standards along with extensions specific to Omnidex. | ||
| - | ==== Index Manipulation Statements ==== | + | Omnidex SQL Statements are callable via the ODBC and JDBC Interfaces. |
| - | | | | | + | |
| - | ==== Miscellaneous Statements ==== | + | |
| - | ===== All Statements ===== | + | |
| - | * [[dev:sql:assignvalues|ASSIGNVALUES]] <tab>(TODO) | + | Omnidex SQL statements can also be tested and scripted using the [[programs:odxsql:overview|OdxSQL]] program. |
| - | * [[dev:sql:attach|ATTACH]] <tab>(TODO) | + | ===== Omnidex Statements ===== |
| - | * [[dev:sql:close_cursor|CLOSE CURSOR]] <tab>(TODO) | + | ===== Omnidex Functions ===== |
| - | * [[dev:sql:command|command]] <tab>(TODO) | + | |
| - | * [[dev:sql:connect|CONNECT]] <tab>(TODO) | + | |
| - | * [[dev:sql:create_database|CREATE DATABASE]] <tab>(TODO) | + | |
| - | * [[dev:sql:create_directory|CREATE DIRECTORY]] <tab>(TODO) | + | |
| - | * [[dev:sql:create_environment|CREATE ENVIRONMENT]] <tab>(TODO) | + | |
| - | * [[dev:sql:create_file|CREATE FILE]] <tab>(TODO) | + | |
| - | * [[dev:sql:create_index|CREATE INDEX]] <tab>(TODO) | + | |
| - | * [[dev:sql:create_indexes|CREATE INDEXES]] <tab>(TODO) | + | |
| - | * [[dev:sql:create_table|CREATE TABLE]] <tab>(TODO) | + | |
| - | * [[dev:sql:delete|DELETE]] <tab>(TODO) | + | |
| - | * [[dev:sql:deleteindex|DELETEINDEX]] <tab>(TODO) | + | |
| - | * [[dev:sql:detach|DETACH]] <tab>(TODO) | + | |
| - | * [[dev:sql:disconnect|DISCONNECT]] <tab>(TODO) | + | |
| - | * [[dev:sql:drop_database|DROP DATABASE]] <tab>(TODO) | + | |
| - | * [[dev:sql:drop_environment|DROP ENVIRONMENT]] <tab>(TODO) | + | |
| - | * [[dev:sql:drop_index|DROP INDEX]] <tab>(TODO) | + | |
| - | * [[dev:sql:drop_indexes|DROP INDEXES]] <tab>(TODO) | + | |
| - | * [[dev:sql:drop_table|DROP TABLE]] <tab>(TODO) | + | |
| - | * [[dev:sql:export|EXPORT]] <tab>(TODO) | + | |
| - | * [[dev:sql:helper|HELPER]] <tab>(TODO) | + | |
| - | * [[dev:sql:insert|INSERT]] <tab>(TODO) | + | |
| - | * [[dev:sql:insertindex|INSERTINDEX]] <tab>(TODO) | + | |
| - | * [[dev:sql:join|JOIN]] <tab>(TODO) | + | |
| - | * [[dev:sql:load_ofx|LOAD OFX]] <tab>(TODO) | + | |
| - | * [[dev:sql:open_cursor|OPEN CURSOR]] <tab>(TODO) | + | |
| - | * [[dev:sql:partition|PARTITION]] <tab>(TODO) | + | |
| - | * [[dev:sql:qualify|QUALIFY]] <tab>(TODO) | + | |
| - | * [[dev:sql:select|SELECT]] <tab>(TODO) | + | |
| - | * [[dev:sql:set|SET]] <tab>(TODO) | + | |
| - | * [[dev:sql:update|UPDATE]] <tab>(TODO) | + | |
| - | * [[dev:sql:update_indexes|UPDATE INDEXES]] <tab>(TODO) | + | |
| - | * [[dev:sql:update_rollup|UPDATE ROLLUP]] <tab>(TODO) | + | |
| - | * [[dev:sql:update_rollups|UPDATE ROLLUPS]] <tab>(TODO) | + | |
| - | * [[dev:sql:update_statistics|UPDATE STATISTICS]] <tab>(TODO) | + | |
| - | * [[dev:sql:update_text|UPDATE TEXT]] <tab>(TODO) | + | |
| - | * [[dev:sql:updateindex|UPDATEINDEX]] <tab>(TODO) | + | |
| - | * [[dev:sql:version|VERSION]] <tab>(TODO) | + | |