Stored procedure

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
santoshkumar
Charter Member
Charter Member
Posts: 35
Joined: Sun Jan 16, 2005 8:39 am
Location: US

Stored procedure

Post by santoshkumar »

Hi,

Can I have Stored procedure Stage in a Datastage job as a stand alone stage. i.e no input parameter, and no return values,
I just need to process every thing in the procedure.But need call the same using DS job

will this scenario work?
Thanks in advance

Regs
Santosh
Last edited by santoshkumar on Wed Nov 30, 2005 4:52 am, edited 1 time in total.
Top
Eric
Participant
Posts: 254
Joined: Mon Sep 29, 2003 4:35 am

Post by Eric »

Stored procedures must be called from a DataStage Job.
If your procedure is a before/after routine then the job does not have to do anything much for the procedure to be executed.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”