Business Process and Data Transformation Language Reference
DTL <sql>
[Back] [Next]
   
Server:docs1
Instance:LATEST
User:UnknownUser
 
-
Go to:
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: