Want to know the values passed to stored procedure stage

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
saiwelcomes
Participant
Posts: 22
Joined: Thu Apr 19, 2012 3:31 am
Location: India

Want to know the values passed to stored procedure stage

Post by saiwelcomes »

Hi All,

I want to know the values being passed to the stored procedure triggered using stored procedure stage in a parallel job. The job is currently running in production. Please let me know how to know what values are being passed as arguments to that procedure.

Thanks in advance.
Regards,
Sai Krishna
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

You need to look at the source of the stored procedure stage and see which job parameters are being used. Then see what the director log shows for parameter values on that job execution.
Post Reply