Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section

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

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

Also see %SQL.CustomResultSet and other classes in this package.

Availability: All namespaces.

Deprecated form of dynamic SQL.

Availability: All namespaces.

Deprecated form of dynamic SQL.

Availability: All namespaces.

See Also