After-job subroutine

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
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

After-job subroutine

Post by mydsworld »

When I write after-job subroutine, do I need to open a job handler for the job or skip that as the job is already open.

Also, how do I access other components (stage,links etc) used in the job.Is it possible to pass a stage variable (derived in a transformer) to a after-job subroutine.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

You can use the mnemonic DSJ.ME in both the before and after job subroutines. You cannot pass a stage variable into the routine.
swapnilverma
Participant
Posts: 135
Joined: Tue Aug 14, 2007 4:27 am
Location: Mumbai

Post by swapnilverma »

I think it depends up on the routine how you are coding it...

if its accepting some variables then you can pass the stage variables as well..

:arrow: ArndW correct me if I am wrong ?
Thanks
Swapnil

"Whenever you find whole world against you just turn around and Lead the world"
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

swapnilverma - I am ready to be proven worng, so please try it. As far as I know, you can only pass certain values to the parameters, and stage variables values are certainly not among the possibilities.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Job Parameters or hard-coded values only. There's no mechanism to send a stage variable to an after-job routine as an argument.
-craig

"You can never have too many knives" -- Logan Nine Fingers
swapnilverma
Participant
Posts: 135
Joined: Tue Aug 14, 2007 4:27 am
Location: Mumbai

Post by swapnilverma »

ArndW wrote:swapnilverma - I am ready to be proven worng, so please try it. As far as I know, you can only pass certain values to the parameters, and stage variables values are certainly not among the possibilities.

Yes you are correct we can pass the satge variable to a routine used in transformer but not to AFTER JOB routine...

:? :? :?
Thanks
Swapnil

"Whenever you find whole world against you just turn around and Lead the world"
swapnilverma
Participant
Posts: 135
Joined: Tue Aug 14, 2007 4:27 am
Location: Mumbai

Post by swapnilverma »

ArndW wrote:swapnilverma - I am ready to be proven worng, so please try it. As far as I know, you can only pass certain values to the parameters, and stage variables values are certainly not among the possibilities.

Yes you are correct we can pass the satge variable to a routine used in transformer but not to AFTER JOB routine...

:? :? :?
Thanks
Swapnil

"Whenever you find whole world against you just turn around and Lead the world"
Post Reply