Data Transformation Engine Database Interface Designer Reference Guide

Chapter 8 - Using Stored Procedures Using a Stored Procedure as an Input
Database Interface Designer Reference Guide
125
Generated type trees for stored procedures adhere to the same format as type
trees for queries and will contain a Row group, the components of which
correspond to the
? placeholders in the CALL statement. Return values from stored
functions will typically have the field name RETURN_VALUE unless the database
returns a specific name.
The call syntax for a stored procedure can be used effectively in input cards in
combination with substitution variables to provide values to input parameters. For
example, to call GetPaymentInfo in an input card, because GetPaymentInfo
takes a single input parameter, first define the text in the Query field, an example
of which follows.