Passing pattern as a Job parameter

[news78]

I have a datastage job that reads a file using a Sequential File stage and processes it. Now the file name is dynamic and follows a pattern: feedata_<month>_1_<yyyy>.txt
e.g.
feedata_January_1_2007.txt


Does datastage provide any option so that I can provide feedata_<month>_1_<yyyy>.txt as job parameter and it replaces the date part and proceeds ahead?

I checked the folder stage but seems its only for wildcards and processing multiple files. I searched the forums, and one option is to replace(in a shell script) the pattern before invoking the datastage job.

Thanks for your help.

[DSguru2B]

Do you want to replace the Month part and the yyyy part automatically or provide parameter values to them. The latter is easy. But for the former you will have to do OCONV() on Date() to get Month as you require and the OCONV() on Date() with conversion code "DY[4]" for yyyy, in the derivation of job parameter in a job activity in a sequence job.
I hope I was'nt confusing

[ray.wurlod]

It ought to be possible, but you would need to guarantee that only one file matches the regular expression if you are planning to use it as the filename property directly.

Otherwise, specify a filter command of cat feedata_*_1_????.txt and use /dev/null as the file name. The stage will read stdout from the filter command, and ignore the file name property.

[news78]

It ought to be possible, but you would need to guarantee that only one file matches the regular expression if you are planning to use it as the filename property directly.

Otherwise, specify a filt ...

Yes only one file will match the pattern. If so is there any way to achive this?
In case I use a filter, can I use a sed command somthing like:

#jobparam_filename#|sed -e "s/month/date/"

where date will be appropriate pattern.

[DSguru2B]

Ray already did give you a much simpler solution.