Data Transformation Engine Database Interface Designer Reference Guide

Chapter 8 - Using Stored Procedures Using a Stored Procedure as an Output
Database Interface Designer Reference Guide
127
To define a query using a stored procedure
When you use a stored procedure to define a query, follow the same steps as when
you use a SELECT or other statement:
1 Define the query in the New Query or Edit/View Query dialog box of the
Database Interface Designer.
2 Generate a type tree from the query.
3 In the Map Designer, specify the query when defining the data source for the
executable map input card for the stored procedure.
Using a Stored Procedure as an Output
Using the database adapters, you can call stored procedures in output cards.
Type trees generated for stored procedures contain an item type for each input
argument. Instead of a Row type, these type trees have a ProcedureCall type
that represents the set of arguments passed to the stored procedure for each
execution of that procedure. The DBProcedure type consists of a series of
ProcedureCalls. The stored procedure is called once for each ProcedureCall in
the DBProcedure output. This information is highlighted in the following example.