Stored procedures native call syntax

A stored procedure can be accessed from within a map by specifying the native call syntax in the following scenarios:

• A query that is specified in an input card.
• The first argument in a DBQUERY or DBLOOKUP function.

  This argument does not need to be a literal. The arguments to the stored procedure may be determined at map execution time.

• The SQL Statement adapter command (-STMT) in DBQUERY, DBLOOKUP, or GET functions.

For information about using DBLOOKUP or DBQUERY, or for information about using the syntax for device-independent calls to access return values and output adapter commands refer to the Database Interface Designer documentation.

For example, a call to a stored procedure using DB2® in a DBLOOKUP might be:

DBLOOKUP ("{call MyAddNameProc(' " + Name:Column + " ',-1)}" ,
"mydb.mdq",
"MyDB")