our project has lot of inter dependencies and we r trying to figure out what to do in DataStage and what in PL/sql
and again the process flow is like we need to call lot of func from other groups.So i know I can call PL/Sql procedure in a DataStage job.but if i need to call other way round i am not sure
Any comments on this will be appreciated
Can we call DataStage Job PL/SQL procedure
Moderators: chulett, rschirm, roy
Re: Can we call DataStage Job PL/SQL procedure
what other functions are you talking about. and for your primary question can we call DS jobs from other functions .. yes.. one way is to use command line for calling the jobs.Angna wrote:we need to call lot of func from other groups
you can write UNIX(whatever shell) scripts to call both stored procedures and also DS jobs. Please search this forum on those issues.