Appending sysdate to seq file name

[mekrreddy]

Hello,

I have to append sysdate to a reject file file name (capturing reject records) which runs everyday Seq_xxxx_11/01/2009.txt , Can i do that in parallel job.? please give your thoughts.

Thanks in advance..

[chulett]

You basically have three ways:

1. Use one of the date macros
2. Use a job parameter, feed in the date
3. Write to a fixed filename and rename after job

The answer can be driven by how enamored you are of that particular date format.

[ray.wurlod]

Slashes in a file name are probably illegal, as they are interpreted as pathname delimiters. You may want to rethink the format of your requirement.

I would always counsel the "create the file with the base name and rename it to include the data subsequently" approach.