You must create and configure an ODBC data source before you import the DB2 for z/OS stored procedure.

PowerCenter imports and calls stored procedures with unqualified names. DB2 normally executes unqualified stored procedures according to the SQL CURRENT PATH value for PowerExchange. DB2 searches this list of schema names from left to right until it finds a schema name for which a stored procedure definition exists with the specified name.

PowerExchange, however, executes any unqualified stored procedures by using the user ID of the PowerExchange connection as the schema name. So, if the user ID on the PowerExchange connection is USER1, PowerExchange calls unqualified stored procedures as USER1.

procedurename.

After you configure the Stored Procedure transformation in a mapping, use the PowerCenter Integration Service to run the session.