Sequentail File name has MMDDYY

[sumitgulati]

Hi,

I have a job that populates a sequential file from a table. The job is run once daily. Sequential file name is FEESAR_MMDDYY.txt, where MMDDYY should be dynamically assigned the date on which the job is run.

For example, if the job runs today then the file name would be FEESAR_101504.txt.
Tomorrow when the job is run the file name should be FEESAR_101604.txt.

One way to achieve this is to write a routine that gets you the current date in the required format. In the sequencer job call this routine first to capture the date value and then pass this value to the job that creates the sequential file.

Is there any better way to achieve it?

Regards,
-Sumit

[ogmios]

Nope that's about it. What do you find bad about it?

Ogmios

[kduke]

I would write to a standard file name and execute a DOS or UNIX command to rename the file as a after job routine. Very simple to do. Several examples of this posted this week.

[chulett]

Same thing I was going to recommend.

Either a script to do the renaming after job, or if you need to deliver the file via FTP do the 'renaming' as part of the file transfer.

[sumitgulati]

Thanks guys for your suggestions. Right now I am going with routine option because soon we would be shifting from Windows to Unix.

Thanks,
-Sumit

[ketfos]

Hi
Use the following command as after job routine in your job.

cp test.csv test`date +"%Y%m%d"`.csv

Ketfos

[ray.wurlod]

Won't work on Windows!