Infinite looping of a Datastage Sequence (using waitforfile)
Posted: Wed Nov 30, 2005 2:01 pm
My requirement is as follows:
1. The sequencer job need to wait for a file (say, salesdata.txt) to appear in a particular directory in unix box.
2. Once the processing is done, the file is deleted from the directory.
3. The job should go into loop and wait for a new file with the SAME name to appear and continue with steps 1 to 3.
This looping should always happen starting at 9AM and ending at 10PM. Job should end at 10PM and no more processing after 10PM.
I have to loop all the above steps after "the file timeout happens" or "after successfully processing the file" i.e. In both success or failure cases I have to loop again and wait for the file until 10PM.
How will I handle this situation?
Currently the job runs once without looping using filewait. Whenever a new copy is received we are forced to trigger the job again manually.
Thanks, Raj
1. The sequencer job need to wait for a file (say, salesdata.txt) to appear in a particular directory in unix box.
2. Once the processing is done, the file is deleted from the directory.
3. The job should go into loop and wait for a new file with the SAME name to appear and continue with steps 1 to 3.
This looping should always happen starting at 9AM and ending at 10PM. Job should end at 10PM and no more processing after 10PM.
I have to loop all the above steps after "the file timeout happens" or "after successfully processing the file" i.e. In both success or failure cases I have to loop again and wait for the file until 10PM.
How will I handle this situation?
Currently the job runs once without looping using filewait. Whenever a new copy is received we are forced to trigger the job again manually.
Thanks, Raj