Check Number of file in sequence.
Posted: Mon Mar 18, 2013 8:01 am
Hi,
I have a sequence. Sequence starts with a loop followed by a sequencer stage. From sequencer stage I have 3 file watcher stage, out of the 3 file watcher
file watcher 1 -- looks for exact file name (abcd.txt)
file watcher 2 -- looks for file pattern (xyz*.txt), can be one or more files.
file watcher 3 -- looks for file pattern (mnop*.csv) should exactelly have 4 files to start the load job to run.
for file watch 2 and 3
------------------------
I have suggested to implement 2 script and create 2 trigger file (one for each) and make our file watcher job to look at the trigger file rather than the actual file. But I was told not to use any such script and try in datastage stages only
Is there any stage in sequence which can help me to solve this. I think user variable activity stage can help me, but I have not done this before could any body help me to implement this logic.
Regards
Manoj
I have a sequence. Sequence starts with a loop followed by a sequencer stage. From sequencer stage I have 3 file watcher stage, out of the 3 file watcher
file watcher 1 -- looks for exact file name (abcd.txt)
file watcher 2 -- looks for file pattern (xyz*.txt), can be one or more files.
file watcher 3 -- looks for file pattern (mnop*.csv) should exactelly have 4 files to start the load job to run.
for file watch 2 and 3
------------------------
I have suggested to implement 2 script and create 2 trigger file (one for each) and make our file watcher job to look at the trigger file rather than the actual file. But I was told not to use any such script and try in datastage stages only
Is there any stage in sequence which can help me to solve this. I think user variable activity stage can help me, but I have not done this before could any body help me to implement this logic.
Regards
Manoj