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/08 23:12] tdo |
dev:sql:home [2020/11/30 18:42] (current) doc |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| ~~NOTOC~~ | ~~NOTOC~~ | ||
| - | ====== Omnidex SQL 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** ^ |
| |[[dev:sql:statements:connect:home|CONNECT]] |[[dev:sql:statements:create_environment:home|CREATE ENVIRONMENT]] | | |[[dev:sql:statements:connect:home|CONNECT]] |[[dev:sql:statements:create_environment:home|CREATE ENVIRONMENT]] | | ||
| |[[dev:sql:statements:disconnect:home|DISCONNECT]] |[[dev:sql:statements:create_database:home|CREATE DATABASE]] | | |[[dev:sql:statements:disconnect:home|DISCONNECT]] |[[dev:sql:statements:create_database:home|CREATE DATABASE]] | | ||
| |[[dev:sql:statements:set:home|SET]] |[[dev:sql:statements:create_table:home|CREATE TABLE]] | | |[[dev:sql:statements:set:home|SET]] |[[dev:sql:statements:create_table:home|CREATE TABLE]] | | ||
| |[[dev:sql:statements:attach:home|ATTACH]] |[[dev:sql:statements:create_index:home|CREATE INDEX]] | | |[[dev:sql:statements:attach:home|ATTACH]] |[[dev:sql:statements:create_index:home|CREATE INDEX]] | | ||
| - | |[[dev:sql:statements:detatch:home|DETATCH]] |[[dev:sql:statements:create_index_group:home|CREATE INDEX GROUP]] | | + | |[[dev:sql:statements:detach:home|DETACH]] |[[dev:sql:statements:create_index_group:home|CREATE INDEX GROUP]] | |
| | |[[dev:sql:statements:drop_environment:home|DROP ENVIRONMENT]] | | | |[[dev:sql:statements:drop_environment:home|DROP ENVIRONMENT]] | | ||
| - | |**Queries and Exports** |[[dev:sql:statements:drop_database:home|DROP DATABASE]] | | + | ^**Queries and Exports** |[[dev:sql:statements:drop_database:home|DROP DATABASE]] | |
| |[[dev:sql:statements:select:home|SELECT]] |[[dev:sql:statements:drop_table:home|DROP TABLE]] | | |[[dev:sql:statements:select:home|SELECT]] |[[dev:sql:statements:drop_table:home|DROP TABLE]] | | ||
| |[[dev:sql:statements:export:home|EXPORT]] |[[dev:sql:statements:drop_index:home|DROP INDEX]] | | |[[dev:sql:statements:export:home|EXPORT]] |[[dev:sql:statements:drop_index:home|DROP INDEX]] | | ||
| |[[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]] | | ||
| |[[dev:sql:statements:delete:home|DELETE]] |[[dev:sql:statements:update_rollups:home|UPDATE ROLLUPS]] | | |[[dev:sql:statements:delete:home|DELETE]] |[[dev:sql:statements:update_rollups:home|UPDATE ROLLUPS]] | | ||
| |[[dev:sql:statements:update:home|UPDATE]] |[[dev:sql:statements:update_statistics:home|UPDATE STATISTICS]] | | |[[dev:sql:statements:update:home|UPDATE]] |[[dev:sql:statements:update_statistics:home|UPDATE STATISTICS]] | | ||
| | |[[dev:sql:statements:update_text:home|UPDATE TEXT]] | | | |[[dev:sql:statements:update_text:home|UPDATE TEXT]] | | ||
| - | |**Omnidex Index Queries** |[[dev:sql:statements:partition:home|PARTITION]] | | + | ^**Omnidex Index Queries** |[[dev:sql:statements:partition:home|PARTITION]] | |
| |[[dev:sql:statements:qualify:home|QUALIFY]] |[[dev:sql:statements:load_ofx:home|LOAD OFX]] | | |[[dev:sql:statements:qualify:home|QUALIFY]] |[[dev:sql:statements:load_ofx:home|LOAD OFX]] | | ||
| |[[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]] | | ||
| - | |----------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------| | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| - | \\ | ||
| \\ | \\ | ||
| \\ | \\ | ||
| + | ====== Omnidex SQL Statement Descriptions ======= | ||
| + | Omnidex SQL Statements can be issued through any standard ODBC and JDBC connection, and through the OdxSQL program. | ||
| - | ^ Omnidex SQL Statements ^^^ | + | |< 95% 25% 75% >| |
| - | |**Connections** |**Omnidex Index Queries** |**Data Definition** | | + | ^Statement ^Description ^ |
| - | |[[dev:sql:statements:connect:home|CONNECT]] |[[dev:sql:statements:qualify:home|QUALIFY]] |[[dev:sql:statements:create_environment:home|CREATE ENVIRONMENT]] | | + | | || |
| - | |[[dev:sql:statements:disconnect:home|DISCONNECT]] |[[dev:sql:statements:join:home|JOIN]] |[[dev:sql:statements:create_database:home|CREATE DATABASE]] | | + | ^**Connections** ^^ |
| - | |[[dev:sql:statements:set:home|SET]] | |[[dev:sql:statements:create_table:home|CREATE TABLE]] | | + | | [[dev:sql:statements:connect:home|CONNECT]] | Connect to an Omnidex Environment. | |
| - | | |**Maintenance** |[[dev:sql:statements:create_index:home|CREATE INDEX]] | | + | | [[dev:sql:statements:disconnect:home|DISCONNECT]] | Disconnect from a connected Omnidex Environment. | |
| - | |**Queries and Exports** |[[dev:sql:statements:update_indexes:home|UPDATE INDEXES]] |[[dev:sql:statements:create_index_group:home|CREATE INDEX GROUP]] | | + | | [[dev:sql:statements:set:home|SET]] | Set Omnidex SQL processing options. | |
| - | |[[dev:sql:statements:select:home|SELECT]] |[[dev:sql:statements:update_rollups:home|UPDATE ROLLUPS]] |[[dev:sql:statements:drop_environment:home|DROP ENVIRONMENT]] | | + | | [[dev:sql:statements:attach:home|ATTACH]] | Attach an Omnidex Standalone Table (OST) to a connected Omnidex Environment File. | |
| - | |[[dev:sql:statements:export:home|EXPORT]] |[[dev:sql:statements:update_statistics:home|UPDATE STATISTICS]] |[[dev:sql:statements:drop_database:home|DROP DATABASE]] | | + | | [[dev:sql:statements:detach:home|DETACH]] | Detach an Omnidex Standalone Table (OST) from a connected Omnidex Environment. | |
| - | |[[dev:sql:statements:open_cursor:home|OPEN CURSOR]] |[[dev:sql:statements:update_text:home|UPDATE TEXT]] |[[dev:sql:statements:drop_table:home|DROP TABLE]] | | + | | || |
| - | |[[dev:sql:statements:close_cursor:home|CLOSE CURSOR]] |[[dev:sql:statements:partition:home|PARTITION]] |[[dev:sql:statements:drop_index:home|DROP INDEX]] | | + | ^**Queries and Exports** ^| |
| - | | |[[dev:sql:statements:load_ofx:home|LOAD OFX]] |[[dev:sql:statements:drop_index_group:home|DROP INDEX GROUP]] | | + | | [[dev:sql:statements:select:home|SELECT]] | Peform a Query Specification and SELECT rows. | |
| - | |**Updates** |[[dev:sql:statements:install_indexes:home|INSTALL INDEXES]] |[[dev:sql:statements:attach:home|ATTACH]] | | + | | [[dev:sql:statements:export:home|EXPORT]] | Export rows or rowids to an external file. | |
| - | |[[dev:sql:statements:insert:home|INSERT]] |[[dev:sql:statements:remove_indexes:home|REMOVE INDEXES]] |[[dev:sql:statements:detatch:home|DETATCH]] | | + | | [[dev:sql:statements:open_cursor:home |OPEN CURSOR]] | Open a Cursor. | |
| - | |[[dev:sql:statements:delete:home|DELETE]] | |[[dev:sql:statements:extract:home|EXTRACT]] | | + | | [[dev:sql:statements:close_cursor:home|CLOSE CURSOR]] | Close a previously opened cursor. | |
| - | |[[dev:sql:statements:update:home|UPDATE]] | | | | + | | || |
| - | |----------------------------------------------------------|---------------------------------------------------------|----------------------------------------------------------| | + | ^**Updates** ^| |
| - | + | | [[dev:sql:statements:insert:home|INSERT]] | Insert rows into a Table. | | |
| - | \\ | + | | [[dev:sql:statements:update:home|UPDATE]] | Update rows in a Table. | |
| - | \\ | + | | [[dev:sql:statements:delete:home|DELETE]] | Delete rows in a Table. | |
| - | \\ | + | | || |
| - | \\ | + | ^**Omnidex Index Queries** ^| |
| - | \\ | + | | [[dev:sql:statements:qualify:home|QUALIFY]] | Qualify index counts using Omnidex criteria. | |
| - | \\ | + | | [[dev:sql:statements:join:home|JOIN]] | Join tables using Omnidex Indexes. | |
| - | \\ | + | | || |
| - | \\ | + | ^**Data Definition** ^| |
| - | \\ | + | | [[dev:sql:statements:create_environment:home|CREATE ENVIRONMENT]] | Create an Omnidex Environment into a named physical operating system file. | |
| - | \\ | + | | [[dev:sql:statements:create_database:home|CREATE DATABASE]] | Create a Database within an Omnidex Environment. | |
| - | \\ | + | | [[dev:sql:statements:create_table:home|CREATE TABLE]] | Create a Table within a Database in the Omnidex metadata or an Omnidex or RDBMS temporary table. | |
| - | \\ | + | | [[dev:sql:statements:create_index:home|CREATE INDEX]] | Specify an Index in the Omnidex metadata but will not physically create the index. | |
| - | \\ | + | | [[dev:sql:statements:create_index_group:home | CREATE INDEX GROUP ]] | Specify an Index Group within the Omnidex metadata. | |
| - | \\ | + | | [[dev:sql:statements:drop_environment:home|DROP ENVIRONMENT]] | Deletes the Omnidex Metadata Environment by physically deleting the operating system file. | |
| - | \\ | + | | [[dev:sql:statements:drop_database:home|DROP DATABASE]] | Remove the named Database from the Omnidex metadata. | |
| - | \\ | + | | [[dev:sql:statements:drop_table:home|DROP TABLE]] | Remove a table from the Omnidex metadata or deletes a previously created temporary table. | |
| - | \\ | + | | [[dev:sql:statements:drop_index:home|DROP INDEX]] | Removes an index from the Omnidex metadata. | |
| - | \\ | + | | [[dev:sql:statements:drop_index_group:home | DROP INDEX GROUP]] | Removes a named Index Group from the Omnidex metadata. | |
| - | \\ | + | | || |
| - | \\ | + | ^**Maintenance** ^| |
| - | \\ | + | | [[dev:sql:statements:update_indexes:home|UPDATE INDEXES]] | Update Omnidex Indexes. | |
| - | \\ | + | | [[dev:sql:statements:update_rollup_table:home|UPDATE ROLLUP TABLE]] | Update Rollup Table with summarized information. | |
| - | \\ | + | | [[dev:sql:statements:update_rollups:home|UPDATE ROLLUPS]] | Update all Rollup Tables for an Omnidex Database. | |
| - | \\ | + | | [[dev:sql:statements:update_statistics:home|UPDATE STATISTICS]] | Update Statistics Information. | |
| - | \\ | + | | [[dev:sql:statements:home:update_text|UPDATE TEXT]] | Update Textual Statistics. | |
| - | \\ | + | | [[dev:sql:statements:partition:home|PARTITION]] | Partition a table into smaller sub tables based on criteria. | |
| - | \\ | + | | [[dev:sql:statements:load_ofx:home|LOAD OFX]] | Load Indexes for a table. | |
| + | | [[ 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. | | ||
| {{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||