Waiting for file to finish and append
Posted: Tue Jul 18, 2006 12:49 pm
I have a Server job that writes rejections on a sequential file. In the next transformer there are more rejections which writes to a temp and ultimately should be appended to the first rejections file.
The problem is: It aborts because it is trying to write to a file that is open. I tried using the DSWaitForFile in the Before or After-stage, however it does not recognize if the rejections file is already there to begin with, so it hangs waiting until it fails.
I searched the Archives and tried different other things but I keep getting the job to Abort when trying to append back in the first file. The first file seemed finished or looks finished.
Any suggestions how to do this?
Is there a better way to do this?
Here is how my job looks like:
Thanks,
Rodre
The problem is: It aborts because it is trying to write to a file that is open. I tried using the DSWaitForFile in the Before or After-stage, however it does not recognize if the rejections file is already there to begin with, so it hangs waiting until it fails.
I searched the Archives and tried different other things but I keep getting the job to Abort when trying to append back in the first file. The first file seemed finished or looks finished.
Any suggestions how to do this?
Is there a better way to do this?
Here is how my job looks like:
Code: Select all
Seq. file- - - > Transf- - - - - - - - - >Transf- - - - >Output file
| |
| |
v v
Reject file Temp Reject File
|
|
v
Transf
|
|
v
Append to Reject file
Rodre