This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
quicklinks [2011/04/19 22:49] doc |
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 ]] | | ||
| Line 11: | Line 11: | ||
| ^ 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<sup>1</sup>]] | [[dev:sql:statements:disconnect:home<sup>1</sup> | 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<sup>2</sup>]] | | + | ^ 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 ]] | [[dev:sql:functions:string:home | String ]] | [[dev:sql:functions:text:home | Adv. Text ]]| | ^ 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 ]] | | ||
| Line 23: | Line 23: | ||
| ^ 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 ]] | | ||
| ^--------------------------^|--------------------------|--------------------------------|--------------------------------|--------------------------------|--------------------------------| | ^--------------------------^|--------------------------|--------------------------------|--------------------------------|--------------------------------|--------------------------------| | ||
| - | <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. | + | <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. | ||