Put date in file name when write out

[lsnovick]

Does anyone know how to put the SYSDATE in the file name of a sequential file?

[BillB]

As long as a Sequence Job is involved, then build your date string in a UserVariables Activity. It can then be used downstream in whatever you are using to create or rename your file.

[vivekgadwal]

As long as a Sequence Job is involved, then build your date string in a UserVariables Activity. It can then be used downstream in whatever you are using to create or rename your file.

The file name portion of the Sequential File stage accepts job parameters, the same way as you write it elsewhere (using # signs). As Bill pointed out, once you figure out the SYSDATE from somewhere in a Sequence, you can use it as a parameter to your job.

[chulett]

Another common technique is to write it out with a static name and then rename it 'after job' using O/S commands to include the date and time if required.