Hi All,
I am using a single job in a sequence for abt 5 times i.e same job is running 5 times in a single sequence. The first time it is executed it generates a balance sheet file for dec, next time jan and so on...
Now i need that 1st time when it runs in the sequence it should simply overwrite the existing file but when the 2nd time same job is run in the sequence it should append the data to the existing file....
summary:-
in a single output file i need Dec, jan, feb, mar, and apr data.....
thanks in advance
Same job with different functions
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 221
- Joined: Fri Feb 17, 2006 3:38 am
- Location: India
- Contact:
Same job with different functions
Thanks & Regards
Parag Saundattikar
Certified for Infosphere DataStage v8.0
Parag Saundattikar
Certified for Infosphere DataStage v8.0
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If it's never been run before, "append" will create the new file. Otherwise you can include a Nested Condition activity to determine whether to truncate the file before running the remainder of the Job activities. This will have two outputs (yes and no); the yes goes into, say, an Execute Command activity to truncate file. Output from the Execute Command activity and the no output fron the Nested Condition activity are brought together in an Any sequencer, then the "append" job is run from a Job activity.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
-
- Participant
- Posts: 221
- Joined: Fri Feb 17, 2006 3:38 am
- Location: India
- Contact: