Page 1 of 1
calling of store procedures
Posted: Fri Sep 26, 2008 12:27 am
by visgtm
Hi,
I wanted to call store procedur by using parallel job in datastage.
Please help me out with this issue
Posted: Fri Sep 26, 2008 1:03 am
by ray.wurlod
Did you happen to
Search for an answer before posting? I'm sure this has been answered in the past.
Stored Procedure (STP) Stage
Posted: Fri Sep 26, 2008 2:10 am
by tkbharani
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]
Posted: Fri Oct 03, 2008 12:42 am
by visgtm
Hi,
Can anyone give the designing of how to invoke stored procedure using datastage parallel jobs
Posted: Fri Oct 03, 2008 1:50 am
by ray.wurlod
The immediately prior post to yours does precisely that, as far as I can discern.