Executing SQL

Executing SQL

InterSystems IRIS supports numerous ways to write and execute SQL code. These include:

• Embedded SQL: SQL code embedded within ObjectScript code.

• Dynamic SQL: SQL code executed from within ObjectScript, using the %SQL.StatementOpens in a new tab class.

• Execute() method: execute SQL code using the Execute()Opens in a new tab method of the %SYSTEM.SQLOpens in a new tab class.

• Stored Procedure containing SQL code, created using CREATE PROCEDURE or CREATE QUERY.

• The SQL Shell: SQL statements executed from the Terminal interface.

• Execute Query Interface: SQL statements executed from the Management Portal.

You can use InterSystems IRIS objects (classes and methods) to:

• Define a persistent class (an SQL table).

• Define an index.

• Define and Use a Class Query.