AFTER/BEFORE ROUTINE

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
karthi_gana
Premium Member
Premium Member
Posts: 729
Joined: Tue Apr 28, 2009 10:49 pm

AFTER/BEFORE ROUTINE

Post by karthi_gana »

All,

what is the difference between 'AFTER/BEFORE ROUTINE' which is under 'Job Properties' and in the 'Transformer' ?

Say for example,

I used mv command (to move the processed file to Archive folder) in 'AFTER/BEFORE ROUTINE' in the job properties.

I called a user defined routine (which will send the job status ) in 'AFTER/BEFORE ROUTINE' in the TRANSFORMER.

which one will trigger first? will both of them execute once the job completed ?
Karthik
mk_ds09
Participant
Posts: 72
Joined: Sun Jan 25, 2009 4:50 pm
Location: Pune

Post by mk_ds09 »

Job level routines are executed as per their definations i.e. before job subroutine executes before job execution ..e.g. In most of the cases it is used to create the input files or move or copy the files ..

After job subroutine executes after the job's successful completion.
E.g. mostly to remove the intermediate files..

Before Stage and After Stage will be executed as per their definations..

i.e. Before stage execution routine executes and after stage routine will execute after the stage execution..

Hope this helps !
-----------------------------------
Regards
MK

What would you attempt to do if you knew you could not fail?

-----------------------------------
Post Reply