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

Execute an embedded SQL SELECT statement within a data transformation.
<sql><![CDATA[   SELECT SSN INTO :context.SSN   FROM MyApp.PatientTable   WHERE PatID = :request.PatID ]]> </sql>
Element Purpose
<annotation> Optional. A text string that describes the <sql> element.
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:

Send us comments on this page
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA