Sequential File: Overwrite problem

[new_dsuser]

Hello,

I have a job which writes some data into a table as well as a sequential file.
The property 'file update mode' is set to 'Overwrite'.

There is a check in one of the transformers to abort the job if a certain constraint condition succeeds. This check is done to abort the job when it is run twice. Now my problem is, even when the job aborts, the file which was created by the last run gets overwritten . Is there a way to not overwrite the file in case the job aborts?

Any help would be much appreciated.

If the issue is not clear/if you would like to know more details, please let me know

Cheers!

[priyadarshikunal]

you can use a before job subroutine to rename that file and in case it aborts, use a after job subroutine to rename it back to orignal name.

[chulett]

In other words, no. The moment the job starts and the stage 'opens' the file is overwritten.

[ArndW]

One suggestion would be to write to a different file name, then in the after-job subroutine call (which can be set to only execute when the job completes successfully) you execute a shell command to move the temporary file to the permanent file name and overwrite it.

[chulett]

Right, in some fashion you'd need to preserve the original file. You could use an After Job routine to check the INTERIM status and, if the job was aborting, swap old back for new. Or, as noted, write to a new name and if the job was going to finish normally, rename the new name to the old name.

[new_dsuser]

Priyadarshi, Craig and ArndW,

Thanks! I used a cp command as an after job sub-routine to replace the actual file which would get executed only when the job succeeds.

Really appreciate the help

Thanks!