how to pass current date as filename in datastage server

vsandu · Participant Joined: 09 Aug 2010 Posts: 13 Points: 280

Hi ,

I want update my file name abcd_curdate.txt, once we ran the job
for ex : if we ran today abcd_20092012.txt
how we can achive please suggest on this
i am using server job and batch job, not parllel and sequence
thanks in advance

pnpmarques · Participant Joined: 15 Jun 2005 Posts: 26 Points: 226

If you do not want to pass the date as parameter to the job (calculated in a sequence for example), then my sugestion is to rename the file in the "after job subroutine" (Job properties).

ray.wurlod · Posted: Thu Sep 20, 2012 5:42 am

Agreed. Use ExecSH as the after-job subroutine, and use mv as the command, with `date +%Y%m%d` as the date part of the file name.

chulett · Posted: Thu Sep 20, 2012 7:15 am

The batch job could very easily get the current date and pass it as a parameter... or you could rename the file after job. Both ways are perfectly valid.

rameshrr3 · Posted: Tue Sep 25, 2012 11:10 am

I'm currently using an approach similar to Ray's suggestions to archive files ( cpio+gzip) once they are created using unix date command with its format modifiers. works like a charm

mobashshar · Posted: Tue Sep 25, 2012 12:45 pm

Hi,
Just use this #DSJobStartDate# at the end of the file name. So in your case the exact name for the file will be as follows:
abcd_#DSJobStartDate#.txt

Hope this helps.

chulett · Posted: Tue Sep 25, 2012 1:32 pm

As long as you don't mind the delimiters it brings to the party. I prefer an unformatted YYYYMMDD date so it sorts 'properly'.

uzl · Posted: Wed Sep 26, 2012 2:18 am

I use a User Variables Activity in my sequence. Here i define the variable current_date as Oconv(@DATE,'D-YMD[4,2,2]') :'_':Oconv(@TIME,'MTS.'). This variable I pass to the job in the Job Activity that follows the User Variables Activity .