Skip to main content

This is documentation for Caché and Ensemble. See the InterSystems IRIS version of this content.Opens in a new tab

Please read this important announcement about the future of Caché and Ensemble maintenanceOpens in a new tab. Contact your account team to migrate to InterSystems IRIS.

Dynamic SQL

Create SQL statements that are prepared and executed at runtime.

Background Information

In Caché, the phrase dynamic SQL refers to SQL statements that are prepared and executed at runtime. Dynamic SQL lets you program within Caché in a manner similar to an ODBC or JDBC application (except that you are executing the SQL statement within the same process context as the database engine).

Available Tools

%SQL.StatementOpens in a new tab and %SQL.StatementResultOpens in a new tab classes

The preferred form of dynamic SQL. See “Using Dynamic SQL” in Using Caché SQL, which discusses all these classes.

Also see %SQL.CustomResultSetOpens in a new tab and other classes in this package.

Availability: All namespaces.

%ResultSet.SQLOpens in a new tab class

Deprecated form of dynamic SQL.

Availability: All namespaces.

%ResultSetOpens in a new tab class

Deprecated form of dynamic SQL.

Availability: All namespaces.

See Also

Next sectionebXML
Previous sectionDOMs
FeedbackOpens in a new tab