Mapper, can I include running a Stored Procedure in my program?

Document ID : KB000055787
Last Modified Date : 14/02/2018
Show Technical Document Details

Yes. Use the SQL Reusable Transformation Wizard to create an SQL RT that will prompt you for a profile to connect to the database server and will provide a query window where you can enter the stored procedure in appropriate syntax for that RDBMS.

Select File > New, and from the New Object list, select SQL Reusable Transformation. The Create SQL Reusable Transformation wizard will guide you through creating this RT.