InterSystems Programming Tools Index
Use SQL within InterSystems IRIS; access third-party ODBC- or JDBC-compliant databases; access InterSystems IRIS 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).
InterSystems IRIS provides an implementation of SQL, known as InterSystems SQL, which you can use within various programmatic contexts.
Also, you can execute InterSystems 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 InterSystems 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.
InterSystems SQL Gateway
Enables your InterSystems IRIS applications to access third-party relational databases (via ODBC or JDBC). Using the SQL Gateway, applications can:
Access data stored in third-party relational databases within InterSystems IRIS applications using objects and/or SQL queries.
Store persistent InterSystems IRIS objects in external relational databases.
InterSystems ODBC driver
InterSystems JDBC driver
The class documentation includes examples and details.
Content Date/Time: 2019-04-10 14:45:56