Data Transformation Engine Database Interface Designer Reference Guide

Chapter 8 - Using Stored Procedures Using a Stored Procedure as an Input
Database Interface Designer Reference Guide
126
Next, provide the value on the command line for parm1 at execution time as
follows:
mercnt MyMap.mmc -ID1 '-VAR parm1=2000-03-11'
Using a Query to Execute a Stored Procedure
If your database permits the execution of a SELECT statement in a stored
procedure or function and can return values through subsequent row fetches, you
can specify a procedure call using the native database syntax in the Query field of
the New Query or Edit/View Query dialog box using the Database Interface
Designer.
For example, to call a stored procedure by means of ODBC using the native syntax,
the query text you enter in the New Query or Edit/View Query dialog box might
be:
{call MyProc(-1)}
Note The query text for a call to a stored procedure must be in the native database
syntax. For more information about the correct syntax of the procedure call using
your particular database adapter, refer to the database-specific adapter reference
guide.