You can specify pre- and post-session SQL in the Source Qualifier transformation and the target instance when you create a mapping. When you create a Session task in the Workflow Manager you can override the SQL commands on the Mapping tab.

For the following databases, if you include a call to a stored procedure in the pre- or post-session SQL, PowerExchange issues error message PWX-00183:

For best performance, if a Source Qualifier transformation for a PowerExchange DB2 for i5/OS source in a PowerCenter session calls a stored procedure on i5/OS to return data, specify the following options on the CREATE PROCEDURE statement when you create the stored procedure:

These options ensures that the format of date and time column types are returned in the same format as if the data was being returned through the DB2 database.