Use SQL within Caché; access third-party ODBC- or JDBC-compliant databases; access Caché as an ODBC- or JDBC-compliant database.
SQL (Structured Query Language) is a programming language designed for managing data in relational database management systems (RDBMS).
Caché provides an implementation of SQL, known as Caché SQL, which you can use within various programmatic contexts.
Also, you can execute Caché SQL directly within the SQL Shell (in the Terminal) and in the Management Portal. Each of these includes an option to view the query plan, which can help you identify ways to make a query more efficient.
Includes methods related to Caché SQL. These include methods that do the following tasks:
Provides utilities for SQL migration. This class provides methods like the following;
It also provides several class queries.
Caché SQL Gateway
Enables your Caché applications to access third-party relational databases (via ODBC or JDBC). Using the SQL Gateway, applications can:
Caché ODBC driver
Caché JDBC driver
The class documentation includes examples and details.
Ensemble SQL Adapters
© 1997-2019 InterSystems Corporation, Cambridge, MA