This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
quicklinks [2011/04/17 00:26] admin |
quicklinks [2012/10/26 14:40] (current) |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| ^ OdxSQL ^|[[programs:odxsql:overview| Overview]] | [[programs:odxsql:commands:home| Commands]] | [[programs:odxsql:settings:home | Settings ]] | [[programs:odxsql:commandline | Command Line ]] | [[programs:odxsql:home | Quick Ref ]] | | ^ OdxSQL ^|[[programs:odxsql:overview| Overview]] | [[programs:odxsql:commands:home| Commands]] | [[programs:odxsql:settings:home | Settings ]] | [[programs:odxsql:commandline | Command Line ]] | [[programs:odxsql:home | Quick Ref ]] | | ||
| ^ Programs ^| [[programs:odxsql:home | OdxSQL ]] | [[programs:odxnet:home | OdxNet ]] | [[ programs:odxaim:home | OdxAim ]] | [[ programs:versions:home | versions ]] | | | ^ Programs ^| [[programs:odxsql:home | OdxSQL ]] | [[programs:odxnet:home | OdxNet ]] | [[ programs:odxaim:home | OdxAim ]] | [[ programs:versions:home | versions ]] | | | ||
| - | ^ Legacy Progs. ^| [[programs:oacomp:home | oacomp ]] | [[programs:dbinstal:home | dbinstal ]] | [[programs:oahelper | oahelper ]] | [[programs:oadecomp:home | oadecomp ]] | [[oaenv:home | Leg. Env. Syntax ]] | | + | ^ Legacy Progs. ^| [[programs:oacomp:home | oacomp ]] | [[programs:dbinstal:home | dbinstal ]] | [[programs:oahelper | oahelper ]] | [[programs:oadecomp:home | oadecomp ]] | [[oaenv:home | Legacy Env. Syntax ]] | |
| ^ Data Stores ^| [[integration:rawdata:home | Raw data files ]] | [[integration:rdbms:oracle:home | Oracle ]] | [[ integration:rdbms:sqlserver:home | SQLServer ]] | [[integration:rdbms:mysql:home | MySQL ]] | [[integration:rdbms:odbc:home | ODBC ]] | | ^ Data Stores ^| [[integration:rawdata:home | Raw data files ]] | [[integration:rdbms:oracle:home | Oracle ]] | [[ integration:rdbms:sqlserver:home | SQLServer ]] | [[integration:rdbms:mysql:home | MySQL ]] | [[integration:rdbms:odbc:home | ODBC ]] | | ||
| ^ Datatypes ^| [[appendix:reference:datatypes | Omnidex ]] | [[integration:rdbms:oracle:datatypes | Oracle ]] | [[ integration:rdbms:sqlserver:datatypes | SQLServer ]] | [[integration:rdbms:mysql:datatypes | MySQL ]] | [[integration:rdbms:odbc:home | ODBC ]] | | ^ Datatypes ^| [[appendix:reference:datatypes | Omnidex ]] | [[integration:rdbms:oracle:datatypes | Oracle ]] | [[ integration:rdbms:sqlserver:datatypes | SQLServer ]] | [[integration:rdbms:mysql:datatypes | MySQL ]] | [[integration:rdbms:odbc:home | ODBC ]] | | ||
| - | ^DDL Create ^| [[dev:sql:statements:create_environment:home | Create Env. ]] | [[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 ]] | | + | ^ DDL Create ^| [[dev:sql:statements:create_environment:home | Create Env. ]] | [[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 ]] | |
| - | ^DDL Drop ^| [[dev:sql:statements:drop_environment:home | Drop Env. ]] | [[dev:sql:statements:drop_database:home |Drop Datebase ]] | [[dev:sql:statements:drop_table:home | Drop Table ]] | [[dev:sql:statements:drop_index:home | Drop Index ]] | [[dev:sql:statements:drop_index_group:home | Drop Index Group ]] | | + | ^ DDL Drop ^| [[dev:sql:statements:drop_environment:home | Drop Env. ]] | [[dev:sql:statements:drop_database:home |Drop Datebase ]] | [[dev:sql:statements:drop_table:home | Drop Table ]] | [[dev:sql:statements:drop_index:home | Drop Index ]] | [[dev:sql:statements:drop_index_group:home | Drop Index Group ]] | |
| ^ SQL 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 ]] | | ^ SQL 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 ]] | | ||
| - | ^ SQL 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 ]] | | + | ^ SQL Access ^| [[dev:sql:statements:connect:home |Connect]] <sup>,,1,,</sup> | [[dev:sql:statements:disconnect:home|Disconnect]] <sup>,,1,,</sup> | [[dev:sql:statements:attach:home | Attach ]] | [[dev:sql:statements:detach:home | Detach ]] | [[dev:sql:statements:set:home | Set ]] | |
| - | ^SQL 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 ]] | | + | ^ SQL 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 ]] | |
| - | ^SQL 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 ]]| | + | ^ SQL 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 ]]| |
| - | ^SQL 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 *]] | | + | ^ SQL 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]] <sup>,,2,,</sup> | |
| - | ^ SQL Functions ^| [[dev:sql:functions:home | Standard ]]| [[dev:sql:functions:home | Extended ]] | [[dev:sql:functions:home | Oracle ]] | | | | + | ^ SQL Functions ^| [[dev:sql:functions:home | Standard ]]| [[dev:sql:functions:home | Extended ]] | [[dev:sql:functions:home | Oracle ]] | [[dev:sql:functions:string:home | String ]] | [[dev:sql:functions:text:home | Adv. Text ]]| |
| ^ Special ^| [[appendix:reference:envvar:home | Env Variables ]] | [[glossary:home | Glossary ]] | [[dev:debugging:home | Debugging ]] | [[dev:connections:home | Conn Strings ]]| [[install:releases:home | Release Notes ]] | | ^ Special ^| [[appendix:reference:envvar:home | Env Variables ]] | [[glossary:home | Glossary ]] | [[dev:debugging:home | Debugging ]] | [[dev:connections:home | Conn Strings ]]| [[install:releases:home | Release Notes ]] | | ||
| ^ Interfaces ^| [[dev:odbc:home | ODBC ]] | [[dev:odbc:home | JDBC ]] | [[dev:dbprocs:oracle:home | Oracle Stored Procs ]] | [[dev:dbprocs:sqlserver:home | SQL Stored Procs. ]] | | | ^ Interfaces ^| [[dev:odbc:home | ODBC ]] | [[dev:odbc:home | JDBC ]] | [[dev:dbprocs:oracle:home | Oracle Stored Procs ]] | [[dev:dbprocs:sqlserver:home | SQL Stored Procs. ]] | | | ||
| - | ^ [[dev:home | Languages ]] ^| [[dev:jdbc:sample | Java ]] | [[dev:odbc:sample | C# ]] | [[dev:odbc:examples:php_select | PHP ]] | [[dev:odbc:examples:simpleselect | C++ ]] || | + | ^ [[dev:home | Languages ]] ^| [[dev:jdbc:sample | Java ]] | [[dev:odbc:sample | C# ]] | [[dev:odbc:examples:php_select | PHP ]] | [[dev:odbc:examples:simpleselect | C++ ]] | [[dev:oa:home | OA/CLOA Libraries ]]| |
| ^ Features ^| [[admin:features:snapshots:home | Snapshots ]] | [[admin:features:grids:home | Grids ]] | [[admin:features:rollups:home | Rollup Tables ]] | [[admin:features:geo:home | Geo Searches ]] | | | ^ Features ^| [[admin:features:snapshots:home | Snapshots ]] | [[admin:features:grids:home | Grids ]] | [[admin:features:rollups:home | Rollup Tables ]] | [[admin:features:geo:home | Geo Searches ]] | | | ||
| - | ^ Indexing ^| [[admin:indexing:concepts:home | Concepts ]] | [[admin:indexing:indexes:home | Options ]] | [[admin:indexing:strategies:home | Strategies ]] | [[admin:basics:updates:home | Updates ]] | | | + | ^ Indexing ^| [[admin:indexing:concepts:home | Concepts ]] | [[admin:indexing:indexes:home | Options ]] | [[admin:indexing:strategies:home | Strategies ]] | [[admin:basics:updates:home | Updates ]] | [[sql:explain:home | Explain Plans ]]| |
| ^ Indexing ^| [[admin:indexing:activecounts:home | ActiveCounts ]] | [[admin:indexing:powersearch:home | PowerSearch ]] | [[admin:indexing:autocomplete:home | AutoComplete ]] | [[admin:indexing:text:home | Omnidex Text ]] | [[admin:indexing:advanced:home | Adv. Strategies ]] | | ^ Indexing ^| [[admin:indexing:activecounts:home | ActiveCounts ]] | [[admin:indexing:powersearch:home | PowerSearch ]] | [[admin:indexing:autocomplete:home | AutoComplete ]] | [[admin:indexing:text:home | Omnidex Text ]] | [[admin:indexing:advanced:home | Adv. Strategies ]] | | ||
| ^--------------------------^|--------------------------|--------------------------------|--------------------------------|--------------------------------|--------------------------------| | ^--------------------------^|--------------------------|--------------------------------|--------------------------------|--------------------------------|--------------------------------| | ||
| - | * Statement is only available from OdxSQL. | ||
| + | <sup>,,1,,</sup> The CONNECT and DISCONNECT statements are used in OdxSQL. Specific connection methods are used in ODBC/JDBC.\\ | ||
| + | <sup>,,2,,</sup> The EXTRACT command is only available in the OdxSQL program. | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | ===== 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 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. | | ||
| - | | [[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_indexeshome|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. | | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | ^ [[overview:home | Overview]] ^ [[nopage|Topics]] ^ [[admin:home | Administration]] ^ [[ dev:home | Development]] ^ [[nopage | General]] ^ | ||
| - | | [[overview:omnidex | What is Omnidex?]] | [[odxadmin:nopage | Fast Counts]] | [[programs:odxadmin:home | Omnidex Administrator]]| [[dev:sql:home | Omnidex SQL Reference]] | [[osinstall:home | Software Installation]] | | ||
| - | | [[nopage | Omnidex Architecture]] | [[admin:nopage | Fast Aggregations]] | [[programs:odxsql:home | OdxSQL]] | [[dev:odbc:home | ODBC]] | [[nopage | Platform Support]] | | ||
| - | | [[nopage | Omnidex on Customer Lists]]| [[nopage | Textual Searches]] | [[sql:explain:home | Optimizing Query Performance]] |[[dev:jdbc:home|JDBC]] | [[appendix:releasenotes | Release Notes]] | | ||
| - | | [[nopage | Omnidex on Business Analytics]] | [[admin:nopage | Fuzzy Searches]] |[[nopage | RDBMS Topics]] | [[dev:dbprocs:home | Stored Procedures]] | [[glossary:home|Glossary]] | | ||
| - | | [[nopage | Omnidex on Transaction Logs]] | [[admin:nopage | Portable Snapshots]] | [[programs:legacy|Legacy Tools/APIs]] | [[dev:debug | Debugging]] | [[appendix:docmap | Documentation Map]]| | ||
| - | | [[nopage | Omnidex on Flat File Databases]] | [[admin:grid:overview | Scalable Grids]] | [[admin:nopage | Administrator FAQ]] | [[dev:nopage |Developer FAQ]] | [[appendix:nopage | Installation FAQ]]| | ||
| - | [[:quicklinks|(c)]],,Copyright Dynamic Information Systems - This document was last updated March 30, 2011,, | ||