Introduction
Software
Installation
Concepts
and Design
Designing
Applications
Omnidex
Environments
SQL
Reference
Omnidex
API's
Utilities
Interfaces
Performance
Guide
Troubleshooting
Guide
Appendix
|
SQL Language Reference
|
|
|
Omnidex provides a high level SQL interface to access data
bases enhanced with Omnidex indexes. The SQL supported is
a subset of the ANSI SQL2 standard along with some very powerful
extensions specific to Omnidex (Query Language).
SQL should be used for all Omnidex application development
including ODBC applications and Java applications using the
Omnidex JDBC driver. 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, OmniAccess Objects, 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 or the OmniAccess Objects Java Native
Interface.
top
|
|