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.
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.