Stored procedures native call syntax

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

• 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 about using the syntax for device-independent calls to access return values and output adapter commands see the Database Interface Designer documentation.

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

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

String literals must be contained within single quotation marks; adapter arguments must be separated by commas.