docs.intersystems.com
Home  /  Application Development: Creating Productions  /  Business Process and Data Transformation Language Reference  /  DTL Elements  /  DTL <sql>


Business Process and Data Transformation Language Reference
DTL <sql>
[Back]  [Next] 
InterSystems: The power behind what matters   
Search:  


Execute an embedded SQL SELECT statement within a data transformation.
Synopsis
<sql><![CDATA[   SELECT SSN INTO :context.SSN   FROM MyApp.PatientTable   WHERE PatID = :request.PatID ]]> </sql>
Elements
Element Purpose
<annotation> Optional. A text string that describes the <sql> element.
Description
The DTL <sql> element executes an arbitrary embedded SQL SELECT statement from within a DTL <transform> element.
To use the <sql> element effectively, keep the following tips in mind: