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

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.Statement and %SQL.StatementResult classes
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.
%ResultSet.SQL class
Deprecated form of dynamic SQL.
Availability: All namespaces.
%ResultSet class
Deprecated form of dynamic SQL.
Availability: All namespaces.
See Also