Stored procedure guide

[monaz]

Hi ,

I am new to stored procedure stage could anyone guide me how to resolve the below scenario.


I have a stored procedure ABCDE which takes two parameter its db2 sp.

I just need to pass the parameter to this Stored procedure and inturn stored procedure reads those parameter and insert the records into the database.

Can any one guide me how to use this SP stage also resolve the above issue.

[chulett]

You need something to feed a single record to the SP stage with those two values as columns that can be bound into the call. In PX, a Row Generator should work, perhaps with an intermediate Transformer to slide the values into the link that you need.

[dssiddu]

call the SP with parameters in the stage. Which stage you are going to use ?