concatenating the target file with the system date

santhoshrao.kuttuva · Post by **santhoshrao.kuttuva** » Tue May 12, 2009 6:43 am

Hi all

i have a requirement as when my job gets run the target file which i specified should return with the current system date.

for eg., i have to get the target file name as " sample 20090405.txt"

Pleas eadvice ... Thanks in advance...

nagarjuna · Post by **nagarjuna** » Tue May 12, 2009 6:56 am

Hi ,

Parameterise the target file name and get the value for that parameter from transformer or from OS .

dinakaran_s · Post by **dinakaran_s** » Tue May 12, 2009 7:17 am

Hi,

Use the Sequencer jobs to run the job and now you can use the below function to define as paramter for the job.

Ereplace(Oconv(@DATE,"D-YMD[4,2,2]"),'-','')

This function will return the system date without '-' (e.x. YYYYMMDD).

Let me know i foyu need anything more.

throbinson · Post by **throbinson** » Tue May 12, 2009 7:43 am

Try using a DS Macro. If the format is acceptable it would be somewhat simpler then the other suggestions.
sample#DSJobStartDate#.txt

chulett · Post by **chulett** » Tue May 12, 2009 7:47 am

The other typical piece of advice is to write to a static filename and then rename it with the date/timestamp after job. A simple script/batch can do the trick.