Home / InterSystems Programming Tools Index / Tools Index / SQL

InterSystems Programming Tools Index
Previous section           Next section
InterSystems: The power behind what matters   

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).
Available Tools
InterSystems SQL
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.
For an introduction, see Using InterSystems SQL.
For reference information, see the InterSystems SQL Reference.
Availability: All namespaces.
Includes methods related to InterSystems SQL. These include methods that do the following tasks:
Availability: All namespaces.
%SQL.Migration.Util class
Provides utilities for SQL migration. This class provides methods like the following;
It also provides several class queries.
Availability: All namespaces.
InterSystems SQL Gateway
Enables your InterSystems IRIS applications to access third-party relational databases (via ODBC or JDBC). Using the SQL Gateway, applications can:
For details, see Using the InterSystems SQL Gateway.
Availability: All namespaces.
InterSystems ODBC driver
Enables you to access InterSystems IRIS as a ODBC-compliant database. See Using the InterSystems ODBC Driver.
Availability: All namespaces.
InterSystems JDBC driver
Enables you to access InterSystems IRIS as a JDBC-compliant database. See Using Java with the InterSystems JDBC Driver.
Availability: All namespaces.
Config.SQL, Config.SqlSysDatatypes, and Config.SqlUserDatatypes classes
Enable you to modify and obtain information about the [SQL], [SqlSysDatatypes], and [SqlUserDatatypes] sections of the CPF file. (Note that you usually modify this file via the Management Portal. See the System Administration Guide.)
Config.SqlSysDatatypes and Config.SqlUserDatatypes each provide the List() class query.
The class documentation includes examples and details.
Availability: %SYS namespace.
SQL Adapters
Enable productions to execute SQL statements against a remote database via an ODBC-defined or JDBC-defined Data Source Name (DSN). See Using SQL Adapters in Productions.
Availability: All interoperability-enabled namespaces.
The special variable $SYSTEM is bound to the %SYSTEM package. This means that instead of ##class(%SYSTEM.class).method(), you can use $SYSTEM.class.method().
See Also

Previous section           Next section
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-04-10 14:45:56