docs.intersystems.com
Home  /  Application Development: Additional Options  /  InterSystems Programming Tools Index  /  Tools Index  /  SQL


InterSystems Programming Tools Index
SQL
[Back]  [Next] 
InterSystems: The power behind what matters   
Search:  


Use SQL within InterSystems IRIS; access third-party ODBC- or JDBC-compliant databases; access InterSystems IRIS as an ODBC- or JDBC-compliant database.
Background
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.
%SYSTEM.SQL class
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 IRIS SQL Gateway.
Availability: All namespaces.
InterSystems ODBC driver
Enables you to access InterSystems IRIS as a ODBC-compliant database. See Using ODBC with InterSystems IRIS.
Availability: All namespaces.
InterSystems JDBC driver
Enables you to access InterSystems IRIS as a JDBC-compliant database. See Using Java JDBC with InterSystems IRIS.
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 production-enabled namespaces.
Reminder
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