Stored proceadure

ranga1970 · Post by **ranga1970** » Wed Apr 20, 2005 5:56 pm

I have sored proceadure say

ABC

This reades the data from table1 and compares data in table2 and updates some data based on differences.

I could develop job to do this, but if i do not want to develop a new logic in this job but just want to call this stored proceadure which will take care of rest

My question is how to call this stored proceadure and execute it in datastage.

1. can we directly call stored proceadure either in before job exeution sub routene or after job subroutene

2 .I thinkwe can call shell script in before job sub routene or after job subroutene, which in tern can call shell script

In suggestion help in this regard is of great help for me to develop my knowledge and I would really appreciate that

thanks

ray.wurlod · Post by **ray.wurlod** » Wed Apr 20, 2005 6:29 pm

Call stored procedure from any passive stage that supports them, for example ODBC stage. Search the forum for more information; it's been covered before.

chulett · Post by **chulett** » Wed Apr 20, 2005 7:13 pm

Or don't even bother with DataStage just to do this. A nice little korn shell script wrapper that executes the stored procedure using sqlplus (or whatever) would work just fine, too.

trokosz · Post by **trokosz** » Wed Apr 20, 2005 10:41 pm

You can use a Sequencer Routine Activity Stage and call the Stored Procedure from there as another option. You can also write Job Control.

suma · Post by **suma** » Thu Apr 21, 2005 12:41 am

You can also write Job Control

Can you tell me how to call a procedure through Job control.
I have simply called my procedure thro the stages.
Now if i can call a procedure through Job Control is there any way that i can control the execution of procedure as before /after Job Subroutine.

Thanks
SumA