To Execute an Stored Procedure without using a shell script.

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
pavithra_12
Participant
Posts: 13
Joined: Thu Mar 17, 2005 1:20 am

To Execute an Stored Procedure without using a shell script.

Post by pavithra_12 »

Hi,

Please let me know how to Execute an Stored Procedure through a Batch Job without using a Shell Script.

-Pavithra.V
elavenil
Premium Member
Premium Member
Posts: 467
Joined: Thu Jan 31, 2002 10:20 pm
Location: Singapore

Post by elavenil »

Hi,

Any Stored procedure can be called before/After SQL tab of the any DB stages and if you want to execute the stored procedure, you might need to use BCI calls to call SP.

HTWH.

Regards
Saravanan
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Use a Stored Procedure stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
pavithra_12
Participant
Posts: 13
Joined: Thu Mar 17, 2005 1:20 am

Post by pavithra_12 »

Hi,

thanxs for the inputs.

- Pavithra
Post Reply