Data Transformation Engine Database Interface Designer Reference Guide

Chapter 4 - Database Type Trees Stored Procedure Type Tree Structure
Database Interface Designer Reference Guide
89
Stored Procedure Type Tree Structure
The type trees generated by the Database Interface Designer for stored
procedures used for outputs from a map are slightly different from the ones
generated for tables, queries, and queries calling stored procedures (that are used
as the source of data for a map).
In the following example, the type tree on the left is for a stored procedure that
will be used as output and the type tree on the right is for a table that will also be
used as output.
The primary differences between the two type trees are:
♦ Whereby table and query type trees have a Column item type from which
stems all of the individual column types, the type tree for a stored procedure
has an Argument item type from which stems item types representing each of
the arguments passed to the stored procedure.
♦ Instead of a Row group, the type tree for a stored procedure has a
ProcedureCall type. The ProcedureCall group represents the set of
arguments passed to the stored procedure for each execution of the procedure.
An example follows.