Can we call DataStage Job PL/SQL procedure

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Angna
Participant
Posts: 1
Joined: Fri Nov 21, 2003 4:27 pm

Can we call DataStage Job PL/SQL procedure

Post by Angna »

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
raju_chvr
Premium Member
Premium Member
Posts: 165
Joined: Sat Sep 27, 2003 9:19 am
Location: USA

Re: Can we call DataStage Job PL/SQL procedure

Post by raju_chvr »

Angna wrote:we need to call lot of func from other groups
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.

you can write UNIX(whatever shell) scripts to call both stored procedures and also DS jobs. Please search this forum on those issues.
Post Reply