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 might 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, see the Database Interface Designer documentation. For information about using the syntax for device-independent calls to access return values and output adapter commands, see the Database Interface Designer documentation. Also see that documentation for information about calling stored procedures with object type parameters.

For example, a call to a stored procedure using OLE DB 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.