OaHelper

Quick Links

© DISC

Omnidex SQL Overview Statements Functions Examples Quick Ref
OdxSQL Overview Commands Settings Command Line Quick Ref
Programs OdxSQL OdxNet OdxAim versions
Legacy Progs. oacomp dbinstal oahelper oadecomp Legacy Env. Syntax
Data Stores Raw data files Oracle SQLServer MySQL ODBC
Datatypes Omnidex Oracle SQLServer MySQL ODBC
DDL Create Create Env. Create Database Create Table Create Index Create Index Group
DDL Drop Drop Env. Drop Datebase Drop Table Drop Index Drop Index Group
SQL DML Select Insert Delete Update Qualify
SQL Access Connect 1 Disconnect 1 Attach Detach Set
SQL Syncing Update Indexes Update Text Update Statistics Update Rollups Update Rollup Table
SQL Special Export Partition Join Open Cursor Close Cursor
SQL Other Install Indexes Remove Indexes Load OFX Command Extract 2
SQL Functions Standard Extended Oracle String Adv. Text
Special Env Variables Glossary Debugging Conn Strings Release Notes
Interfaces ODBC JDBC Oracle Stored Procs SQL Stored Procs.
Languages Java C# PHP C++ OA/CLOA Libraries
Features Snapshots Grids Rollup Tables Geo Searches
Indexing Concepts Options Strategies Updates Explain Plans
Indexing ActiveCounts PowerSearch AutoComplete Omnidex Text Adv. Strategies
————————–————————–——————————–——————————–——————————–——————————–

1 The CONNECT and DISCONNECT statements are used in OdxSQL. Specific connection methods are used in ODBC/JDBC.
2 The EXTRACT command is only available in the OdxSQL program.