calling of store procedures

visgtm · Post by **visgtm** » Fri Sep 26, 2008 12:27 am

Hi,
I wanted to call store procedur by using parallel job in datastage.
Please help me out with this issue

ray.wurlod · Post by **ray.wurlod** » Fri Sep 26, 2008 1:03 am

Did you happen to Search for an answer before posting? I'm sure this has been answered in the past.

tkbharani · Post by **tkbharani** » Fri Sep 26, 2008 2:10 am

To run a pl/sql procedure from Datastage a Stored Procedure (STP) stage can be used.
However it needs a flow of at least one record to run.
1. Put any source stage,.eg ODBC stage.

2. A transformer which passes that record through.

3.Put Stored Procedure stage as a destination. Fill in connection parameters and select Transform as procedure type. In the input tab select 'execute procedure for each row' [it will be run once]

visgtm · Post by **visgtm** » Fri Oct 03, 2008 12:42 am

Hi,

Can anyone give the designing of how to invoke stored procedure using datastage parallel jobs

ray.wurlod · Post by **ray.wurlod** » Fri Oct 03, 2008 1:50 am

The immediately prior post to yours does precisely that, as far as I can discern.

DSXchange

calling of store procedures

calling of store procedures

Stored Procedure (STP) Stage