Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links
 

OMNIDEX

SQL Reference

SQL Reference

SELECT Statement

Joins

Nested Queries

Set Operations

ON CURSOR | INSTANCE

WITH Options

Commands

Functions

 

 

 

Omnidex provides a high-level SQL interface to access databases enhanced with Omnidex indexes, as an alternative to the OmniAccess API. The SQL supported is a subset of the ANSI SQL2 standard along with some very powerful extensions specific to Omnidex.

SQL should be used for all Omnidex application development including ODBC applications, Java applications using the Omnidex JDBC driver, and OmniAccess applications through oaexecsql. The Query Language extensions work in conjunction with the SQL standard syntax, in all types of applications.

  • Third party ODBC tools such as BrioQuery, Cognos Impromptu, and Microsoft's Query, Access, Excel, and Word communicate with Omnidex via the Omnidex ODBC driver.
  • Development tools such as Microsoft's Interdev, Visual Basic, and Visual C++ can communicate with Omnidex via the OmniAccess API or the Omnidex ODBC driver using object layers such as ActiveX Data Objects (ADO).
  • Java applications such as applets, servlets, and standard console applications can communicate with Omnidex via the Omnidex JDBC driver.

Top