Differences

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

--- quicklinks [2010/07/08 22:18]
tdo
+++ quicklinks [2020/11/30 18:56] (current)
doc
@@ Line 1: / Line 1: @@
-^    [[:home|Quick Links ]]  ^^^^^
+~~NOTOC~~
 {{page>:sql_odxsql_bar&nofooter&noeditbtn}}
 ===== Omnidex SQL Statements and OdxSQL Commands =====
-^ DML ^| [[dev:sql:statements:select:home |Select ]]| [[dev:sql:statements:insert:home |Insert ]] | [[dev:sql:statements:delete:home |Delete ]] | [[dev:sql:statements:update:home |Update ]] | [[dev:sql:statements:qualify:home |Qualify ]] |
+^ DML ^| [[dev:sql:statements:select:home | Select  ]]| [[dev:sql:statements:insert:home |Insert ]] | [[dev:sql:statements:delete:home |Delete ]] | [[dev:sql:statements:update:home |Update ]] | [[dev:sql:statements:qualify:home |Qualify ]] |
 ^ Access ^| [[dev:sql:statements:connect:home |Connect *]] | [[dev:sql:statements:disconnect:home | Disconnect *]] | [[dev:sql:statements:attach:home | Attach ]] | [[dev:sql:statements:detach:home | Detach ]] | [[dev:sql:statements:set:home | Set ]] |
 ^ DDL Create ^| [[dev:sql:statements:create_environment:home | Create Environment ]] | [[dev:sql:statements:create_database:home | Create Database ]] | [[dev:sql:statements:create_table:home | Create Table ]] | [[dev:sql:statements:create_index:home | Create Index ]] | [[dev:sql:statements:create_index_group:home | Create Index Group ]] |
@@ Line 10: / Line 9: @@
 ^ Syncing ^| [[dev:sql:statements:update_indexes:home | Update Indexes ]] | [[dev:sql:statements:update_text:home | Update Text ]] | [[dev:sql:statements:update_statistics:home | Update Statistics ]] | [[dev:sql:statements:update_rollups:home | Update Rollups ]] | [[dev:sql:statements:update_rollup_table:home | Update Rollup Table ]] |
 ^ Special ^| [[dev:sql:statements:export:home | Export ]] | [[dev:sql:statements:Partition:home | Partition ]] | [[dev:sql:statements:join:home | Join ]] | [[dev:sql:statements:open_cursor:home | Open Cursor ]] | [[dev:sql:statements:close_cursor:home | Close Cursor ]]|
-^ Other ^| [[dev:sql:statements:install_indexes:home | Install Indexes ]] | [[ dev:sql:statements:remove_indexes:home | Remove Indexes ]] | [[dev:sql:statements:load_ofx:home | Load OFX ]]| [[dev:sql:statements:command:home | Command ]] | [[dev:odxsql:commands:extract:home | Extract *]]|
+^ Other ^| [[dev:sql:statements:install_indexes:home | Install Indexes ]] | [[ dev:sql:statements:remove_indexes:home | Remove Indexes ]] | [[dev:sql:statements:load_ofx:home | Load OFX ]]| [[dev:sql:statements:command:home | Command ]] | [[dev:odxsql:commands:extract:home | Extract *]]
 * Statement is only available from OdxSQL.
 ===== Omnidex SQL Standard Functions =====
 | [[ dev:sql:functions:abs | ABS ]]| [[ dev:sql:functions:case | CASE ]] | [[ dev:sql:functions:cast | CAST ]] |[[ dev:sql:functions:character_length | CHAR[ACTER]_LENGTH ]] |[[ dev:sql:functions:coalesce | COALESCE ]] | [[ dev:sql:functions:concatenation | || (Concatenation) ]] |
@@ Line 19: / Line 18: @@
 | [[ dev:sql:functions:mod | MOD ]] | [[ dev:sql:functions:position | POSITION]] | [[ dev:sql:functions:power | POWER ]] | [[ dev:sql:functions:round | ROUND ]] | [[ dev:sql:statements:select:sample | SAMPLE ]] | [[ dev:sql:functions:substring | SUBSTRING]] |
 | [[ dev:sql:functions:session_user | SESSION_USER]] | [[ dev:sql:functions:system_user | SYSTEM_USER ]] | [[ dev:sql:functions:trim | TRIM ]] | [[ dev:sql:functions:trunc | TRUNC ]] | [[ dev:sql:functions:upper | UPPER ]] | [[ dev:sql:functions:user | USER ]] |
 ===== Omnidex Extended Functions =====
@@ Line 29: / Line 29: @@
 | [[ dev:sql:orafunctions:chr | CHR ]] | [[ dev:sql:orafunctions:instr | INSTR ]] | [[ dev:sql:orafunctions:new_time | NEW_TIME ]] | [[ dev:sql:orafunctions:nvl | NVL ]] | [[ dev:sql:orafunctions:substr | SUBSTR ]] | [[ dev:sql:orafunctions:sys_extract_utc | SYS_EXTRACT_UTC ]] | [[ dev:sql:orafunctions:sysdate | SYSDATE ]] | [[ dev:sql:orafunctions:systimestamp | SYSTIMESTAMP ]] | [[ dev:sql:orafunctions:to_date | TO_DATE ]] | [[ dev:sql:orafunctions:to_number | TO_NUMBER ]] |
 ===== Omnidex Data Types =====
-^See Also:^[[dev:sql:datatypes:home | List of Datatypes]]^
+^See Also:^[[dev:sql:datatypes|List of Datatypes]]^
 === Standard Datatypes ===
@@ Line 37: / Line 37: @@
 | CHARACTER(//n//)        | Space-filled character string of //n// characters            |
 | CHAR(//n//)             | Synonym for CHARACTER(//n//)                                 |
-| C STRING(//n//)         | Null-terminated character string of //n// characters         |
+| STRING(//n//)           | Null-terminated character string of //n// characters         |
 | VARCHAR(//n//)*         | String of max //n// characters, with length variable         |
 | CLOB(//n//)*            | Character large object of max //n// characters, with length variable |
@@ Line 64: / Line 64: @@
 | OMNIDEX TIME(//n//)     | Omnidex proprietary time supporting //n// digits of HHMMSSNN |
 | OMNIDEX DATETIME(//n//) | Omnidex proprietary datetime supporting //n// digits of YYYYMMDDHHMMSSNN |
-| * Omnidex recommends use of the CHARACTER and C STRING datatypes rather than VARCHAR and CLOB due to the requirement of a length variable. ||
+| * Omnidex recommends use of the CHARACTER and STRING datatypes rather than VARCHAR and CLOB due to the requirement of a length variable. ||
 === National Character Datatypes ===
@@ Line 76: / Line 76: @@
 | NATIONAL CHARACTER(//n//) | Space-filled character string of //n// characters          |
 | NATIONAL CHAR(//n//)      | Synonym for CHARACTER(//n//)                               |
-| NATIONAL C STRING(//n//)  | Null-terminated character string of //n// characters       |
+| NATIONAL STRING(//n//)    | Null-terminated character string of //n// characters       |
 | NATIONAL VARCHAR(//n//)*  | String of max //n// characters, with length variable       |
 | NATIONAL CLOB(//n//)*     | Character large object of max //n// characters, with length variable |
-| * Omnidex recommends use of the NATIONAL CHARACTER and NATIONAL C STRING datatypes rather than NATIONAL VARCHAR and NATIONAL CLOB due to the requirement of a length variable.  ||
+| * Omnidex recommends use of the NATIONAL CHARACTER and NATIONAL STRING datatypes rather than NATIONAL VARCHAR and NATIONAL CLOB due to the requirement of a length variable.  ||
@@ Line 97: / Line 97: @@
 os>
 </code>
+===== SQL Statements by Category =====
+===== Omnidex SQL SELECT and Data Manipulation Statements =====
+Omnidex SQL supports SQL's SELECT and Data Manipulation Statements (INSERT, UPDATE, and DELETE).
+| [[dev:sql:statements:select:home|SELECT]] | Peform a Query Specification and SELECT rows. |
+| [[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 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.
+| [[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:detach:home|DETACH]] | Detach an Omnidex Standalone Table (OST) from a connected Omnidex Environment. |
+===== Omnidex SQL Data Definition Language (DDL) Statements =====
+Omnidex SQL has statements that create and drop objects within an Omnidex Environment.
+Also see the OdxSQL Extract command to generate DDL statements from an existing Omnidex Environment.
+^ 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. |
+| [[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 | 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. |
+===== 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_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. |
+| 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. |
+===== 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. |
 ===== Learning Omnidex =====
   * [[ tutorials:simple_flatfile | Creating a very simple flat file Environment and doing retrievals. ]]

Back to top

quicklinks.1278627501.txt.gz · Last modified: 2016/06/28 22:38 (external edit)

Sitemap Recent Changes