Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
dev:sql:home [2010/07/09 00:05]
tdo
dev:sql:home [2020/11/30 18:42] (current)
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** ​                                              ^
 |[[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]] ​        ​| ​                                                                 ​
-|----------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------| +\\ 
-===== SQL Statement ​Description ​===== +\\ 
-Omnidex SQL Statement ​^ Statement Description ^+ 
 +====== Omnidex ​SQL Statement ​Descriptions ======= 
 + 
 +Omnidex SQL Statements can be issued through any standard ODBC and JDBC connection, and through the OdxSQL program. ​  
 + 
 +|< 95% 25% 75% >| 
 +^Statement ​ ^Description ​ ^ 
 +|  || 
 +^**Connections** ​ ^^
 | [[dev:​sql:​statements:​connect:​home|CONNECT]] | Connect to an Omnidex Environment. | | [[dev:​sql:​statements:​connect:​home|CONNECT]] | Connect to an Omnidex Environment. |
 | [[dev:​sql:​statements:​disconnect:​home|DISCONNECT]] | Disconnect from a connected Omnidex Environment. | | [[dev:​sql:​statements:​disconnect:​home|DISCONNECT]] | Disconnect from a connected Omnidex Environment. |
 | [[dev:​sql:​statements:​set:​home|SET]] | Set Omnidex SQL processing options. | | [[dev:​sql:​statements:​set:​home|SET]] | Set Omnidex SQL processing options. |
-| [[dev:​sql:​statements:​attach:​home|ATTACH]] | Attach an Omnidex Standalone Table (OST) to a connected Omnidex Environment ​for queries and manipulation. |+| [[dev:​sql:​statements:​attach:​home|ATTACH]] | Attach an Omnidex Standalone Table (OST) to a connected Omnidex Environment ​File. |
 | [[dev:​sql:​statements:​detach:​home|DETACH]] | Detach an Omnidex Standalone Table (OST) from a connected Omnidex Environment. | | [[dev:​sql:​statements:​detach:​home|DETACH]] | Detach an Omnidex Standalone Table (OST) from a connected Omnidex Environment. |
-^ Queries and Exports ^ ^+|  || 
 +^**Queries and Exports**  ​^|
 | [[dev:​sql:​statements:​select:​home|SELECT]] | Peform a Query Specification and SELECT rows. | | [[dev:​sql:​statements:​select:​home|SELECT]] | Peform a Query Specification and SELECT rows. |
 | [[dev:​sql:​statements:​export:​home|EXPORT]] | Export rows or rowids to an external file. | | [[dev:​sql:​statements:​export:​home|EXPORT]] | Export rows or rowids to an external file. |
 | [[dev:​sql:​statements:​open_cursor:​home |OPEN CURSOR]] | Open a Cursor. | | [[dev:​sql:​statements:​open_cursor:​home |OPEN CURSOR]] | Open a Cursor. |
 | [[dev:​sql:​statements:​close_cursor:​home|CLOSE CURSOR]] | Close a previously opened cursor. | | [[dev:​sql:​statements:​close_cursor:​home|CLOSE CURSOR]] | Close a previously opened cursor. |
-^ Updates ^ ^+|  || 
 +^**Updates**  ​^|
 | [[dev:​sql:​statements:​insert:​home|INSERT]] | Insert rows into a Table. | | [[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:​update:​home|UPDATE]] | Update rows in a Table. |
 | [[dev:​sql:​statements:​delete:​home|DELETE]] | Delete rows in a Table. | | [[dev:​sql:​statements:​delete:​home|DELETE]] | Delete rows in a Table. |
-^ Index Only Tables ^ ^+|  || 
 +^**Omnidex ​Index Queries**  ​^|
 | [[dev:​sql:​statements:​qualify:​home|QUALIFY]] | Qualify index counts using Omnidex criteria. | | [[dev:​sql:​statements:​qualify:​home|QUALIFY]] | Qualify index counts using Omnidex criteria. |
 | [[dev:​sql:​statements:​join:​home|JOIN]] | Join tables using Omnidex Indexes. | | [[dev:​sql:​statements:​join:​home|JOIN]] | Join tables using Omnidex Indexes. |
-DDL ^ ^+|  || 
 +^**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_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_database:​home|CREATE DATABASE]] | Create a Database within an Omnidex Environment. |
Line 58: Line 71:
 | [[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_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:​home|DROP INDEX]] | Removes an index from the Omnidex metadata. |
-| [[dev:​sql:​statements:​drop_index_group | DROP INDEX GROUP]] | Removes a named Index Group from the Omnidex metadata. | +| [[dev:​sql:​statements:​drop_index_group:home | DROP INDEX GROUP]] | Removes a named Index Group from the Omnidex metadata. | 
-[[dev:​sql:​statements:​attach:​home|ATTACH]] | Attach an Omnidex Standalone Table (OST) to a connected Omnidex Environment for queries and manipulation. | + || 
-| [[dev:​sql:​statements:​detach:​home|DETACH]] | Detach an Omnidex Standalone Table (OST) from a connected Omnidex Environment. ​+^**Maintenance**  ​^|
-Index Maintenance ^ ^+
 | [[dev:​sql:​statements:​update_indexes:​home|UPDATE INDEXES]] | Update Omnidex Indexes. | | [[dev:​sql:​statements:​update_indexes:​home|UPDATE INDEXES]] | Update Omnidex Indexes. |
-| [[dev:​sql:​statements:​update_rollup:​home|UPDATE ROLLUP]] | Update Rollup Table with summarized information. |+| [[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_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:​update_statistics:​home|UPDATE STATISTICS]] | Update Statistics Information. |
Line 69: Line 81:
 | [[dev:​sql:​statements:​partition:​home|PARTITION]] | Partition a table into smaller sub tables based on criteria. | | [[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:​load_ofx:​home|LOAD OFX]] | Load Indexes for a table. | 
-| 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. ​
-| 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. ​|
- +
- +
- +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
- +
- +
- +
-^                                           ​Omnidex SQL Statements ​                                                                                                                                   ^^^ +
-|**Connections** ​                                                  ​|**Omnidex Index Queries** ​                                        ​|**Data Definition** ​                                              | +
-|[[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]] ​      | +
-|[[dev:​sql:​statements:​set:​home|SET]] ​                              ​| ​                                                                 |[[dev:​sql:​statements:​create_table:​home|CREATE TABLE]] ​            | +
-|                                                                  |**Maintenance** ​                                                  ​|[[dev:​sql:​statements:​create_index:​home|CREATE INDEX]] ​            | +
-|**Queries and Exports** ​                                          ​|[[dev:​sql:​statements:​update_indexes:​home|UPDATE INDEXES]] ​        ​|[[dev:​sql:​statements:​create_index_group:​home|CREATE INDEX GROUP]] | +
-|[[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:​export:​home|EXPORT]] ​                        ​|[[dev:​sql:​statements:​update_statistics:​home|UPDATE STATISTICS]] ​  ​|[[dev:​sql:​statements:​drop_database:​home|DROP DATABASE]] ​          | +
-|[[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]] ​                | +
-|                                                                  |[[dev:​sql:​statements:​load_ofx:​home|LOAD OFX]]                     ​|[[dev:​sql:​statements:​drop_index_group:​home|DROP INDEX GROUP]] ​    | +
-|**Updates** ​                                                      |[[dev:​sql:​statements:​install_indexes:​home|INSTALL INDEXES]] ​      ​|[[dev:​sql:​statements:​attach:​home|ATTACH]] ​                        +
-|[[dev:​sql:​statements:​insert:​home|INSERT]] ​                        |[[dev:​sql:​statements:​remove_indexes:​home|REMOVE INDEXES]] ​        ​|[[dev:​sql:​statements:​detatch:​home|DETATCH]] ​                      | +
-|[[dev:​sql:​statements:​delete:​home|DELETE]] ​                        ​| ​                                                                 |[[dev:​sql:​statements:​extract:​home|EXTRACT]] ​                      ​| ​                                                                  +
-|[[dev:​sql:​statements:​update:​home|UPDATE]] ​                        ​| ​                                                                 |                                                                  | +
-|----------------------------------------------------------|---------------------------------------------------------|----------------------------------------------------------| +
- +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\ +
-\\+
  
  
  
 {{page>:​bottom_add&​nofooter&​noeditbtn}} {{page>:​bottom_add&​nofooter&​noeditbtn}}
 
Back to top
dev/sql/home.1278633902.txt.gz · Last modified: 2016/06/28 22:38 (external edit)