Differences

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

--- dev:sql:home [2010/07/08 23:57]
tdo
+++ dev:sql:home [2016/06/28 22:38]
127.0.0.1 external edit
@@ Line 5: / Line 5: @@
 [[dev:sql:home|Statements]] | [[dev:sql:functions|Functions]] | [[dev:sql:datatypes|Datatypes]] | [[dev:sql:examples | Examples]]
+|< 95% 50% 50% >|
 ^                                           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: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: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]]     |
-|**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: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: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: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_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:join:home|JOIN]]                             |[[dev:sql:statements:install_indexes:home|INSTALL 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.
-===== SQL Statements by Category =====
+|< 95% 25% 75% >|
-===== Omnidex SQL SELECT and Data Manipulation Statements =====
+^Statement  ^Description  ^
-===== Omnidex Connection Statements =====
+|  ||
-Omnidex supports statements to establish connections and set processing options for the connection as well as attach and detach individual files to an Omnidex Environment.
+^**Connections**  ^^
-^ Omnidex SQL Statement ^ Statement Description ^
 | [[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: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. |
+|  ||
-Omnidex SQL supports SQL's SELECT and Data Manipulation Statements (INSERT, UPDATE, and DELETE).
+^**Queries and Exports**  ^|
 | [[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:open_cursor:home |OPEN CURSOR]] | Open a Cursor. |
+| [[dev:sql:statements:close_cursor:home|CLOSE CURSOR]] | Close a previously opened cursor. |
+|  ||
+^**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**  ^|
-===== Omnidex SQL Data Definition Language (DDL) Statements =====
+| [[dev:sql:statements:qualify:home|QUALIFY]] | Qualify index counts using Omnidex criteria. |
-Omnidex SQL has statements that create and drop objects within an Omnidex Environment.
+| [[dev:sql:statements:join:home|JOIN]] | Join tables using Omnidex Indexes. |
+|  ||
-Also see the OdxSQL Extract command to generate DDL statements from an existing Omnidex Environment.
+^**Data Definition**  ^|
-^ DDL Statement ^  Description  ^
 | [[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. |
@@ Line 64: / 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_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**  ^|
-===== Omnidex SQL Query and Export Statements =====
-| [[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:open_cursor:home |OPEN CURSOR]] | Open a Cursor. |
-| [[dev:sql:statements:close_cursor:home|CLOSE CURSOR]] | Close a previously opened cursor. |
-===== Omnidex SQL Index and Processing Maintenance Statements =====
-Omnidex supports several statements to synchronize the Omnidex indexes, rollup tables and internal statistics.
 | [[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_statistics:home|UPDATE STATISTICS]] | Update Statistics Information. |
@@ Line 84: / Line 81: @@
 | [[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. |
-| 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 Index Query Statements =====
-Omnidex supports lower level QUALIFY and JOIN statements to query the Omnidex indexes directly.  These statements are advanced statements used for testing and to support legacy applications.  The SELECT statement is now typically used instead.
-| [[dev:sql:statements:qualify:home|QUALIFY]] | Qualify index counts using Omnidex criteria. |
-| [[dev:sql:statements:join:home|JOIN]] | Join tables using Omnidex Indexes. |
-\\
-\\
-\\
-\\
-\\
-\\
-\\
-\\
-\\
-\\
-\\
-\\
-\\
-\\
-\\
-^                                           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}}

Back to top

dev/sql/home.txt · Last modified: 2020/11/30 18:42 by doc

Sitemap Recent Changes