InterSystems IRIS Data Platform 2019.2  /  InterSystems Programming Tools Index

InterSystems Programming Tools Index
Dynamic SQL
Previous section           Next section
InterSystems: The power behind what matters   

Create SQL statements that are prepared and executed at runtime.
Background Information
In InterSystems IRIS, the phrase dynamic SQL refers to SQL statements that are prepared and executed at runtime. Dynamic SQL lets you program within InterSystems IRIS 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 InterSystems SQL, which discusses all these classes.
Also see %SQL.CustomResultSet and other classes in this package.
Availability: All namespaces.
See Also

Previous section           Next section
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-08-22 06:48:58