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:41] 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 ]] | [[sql:explain:home | Explain Plans ]]| | ^ 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. | ||