This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
dev:sql:home [2010/07/12 21:13] tdo |
dev:sql:home [2020/11/30 18:42] doc |
||
---|---|---|---|
Line 3: | Line 3: | ||
====== Omnidex SQL Statement Quick Reference ====== | ====== Omnidex SQL Statement Quick Reference ====== | ||
- | [[dev:sql:home|Statements]] | [[dev:sql:functions|Functions]] | [[dev:sql:datatypes|Datatypes]] | [[dev:sql:examples | Examples]] | + | [[dev:sql:home|Statements]] | [[dev:sql:functions:home|Functions]] | [[dev:sql:datatypes|Datatypes]] | [[dev:sql:examples:home|Examples]] |
+ | |< 95% 50% 50% >| | ||
^ Omnidex SQL Statements ^^ | ^ Omnidex SQL Statements ^^ | ||
^**Connections** ^**Data Definition** ^ | ^**Connections** ^**Data Definition** ^ | ||
Line 18: | Line 19: | ||
|[[dev:sql:statements:open_cursor:home|OPEN CURSOR]] |[[dev:sql:statements:drop_index_group:home|DROP INDEX GROUP]] | | |[[dev:sql:statements:open_cursor:home|OPEN CURSOR]] |[[dev:sql:statements:drop_index_group:home|DROP INDEX GROUP]] | | ||
|[[dev:sql:statements:close_cursor:home|CLOSE CURSOR]] |[[dev:sql:statements:extract:home|EXTRACT]] | | |[[dev:sql:statements:close_cursor:home|CLOSE CURSOR]] |[[dev:sql:statements:extract:home|EXTRACT]] | | ||
- | |%% %% | | | + | |. | | |
^**Updates** ^**Maintenance** ^ | ^**Updates** ^**Maintenance** ^ | ||
|[[dev:sql:statements:insert:home|INSERT]] |[[dev:sql:statements:update_indexes:home|UPDATE INDEXES]] | | |[[dev:sql:statements:insert:home|INSERT]] |[[dev:sql:statements:update_indexes:home|UPDATE INDEXES]] | | ||
Line 28: | Line 29: | ||
|[[dev:sql:statements:join:home|JOIN]] |[[dev:sql:statements:install_indexes:home|INSTALL INDEXES]] | | |[[dev:sql:statements:join:home|JOIN]] |[[dev:sql:statements:install_indexes:home|INSTALL INDEXES]] | | ||
| |[[dev:sql:statements:remove_indexes:home|REMOVE INDEXES]] | | | |[[dev:sql:statements:remove_indexes:home|REMOVE INDEXES]] | | ||
- | |--------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------| | ||
\\ | \\ | ||
\\ | \\ | ||
Line 36: | Line 36: | ||
Omnidex SQL Statements can be issued through any standard ODBC and JDBC connection, and through the OdxSQL program. | Omnidex SQL Statements can be issued through any standard ODBC and JDBC connection, and through the OdxSQL program. | ||
+ | |< 95% 25% 75% >| | ||
^Statement ^Description ^ | ^Statement ^Description ^ | ||
| || | | || | ||
Line 82: | Line 83: | ||
| [[ dev:sql:statements:install_indexes:home | INSTALL INDEXES ]]| Specifies the Omnidex indexes into the Omnidex XML Environment. No indexing is performed. | | | [[ dev:sql:statements:install_indexes:home | INSTALL INDEXES ]]| Specifies the Omnidex indexes into the Omnidex XML Environment. No indexing is performed. | | ||
| [[ dev:sql:statements:remove_indexes:home | REMOVE INDEXES]]| Removes the Omnidex indexes from the Omnidex XML Environment. | | | [[ dev:sql:statements:remove_indexes:home | REMOVE INDEXES]]| Removes the Omnidex indexes from the Omnidex XML Environment. | | ||
- | |-----------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------| | ||
{{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} |