ADD date to target files

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
karry450
Participant
Posts: 201
Joined: Wed Nov 14, 2007 11:31 pm
Location: HYD

ADD date to target files

Post by karry450 »

Hi Team,

I am writing data to files and I want to append sysdate to target filenames is there any easy way who can help me out.

Thanks
kandyshandy
Participant
Posts: 597
Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore

Post by kandyshandy »

I don't know your easy way but it is possible. Get sysdate and pass it as a parameter to the job that creates the file.... Got to use sequence ;)
Kandy
_________________
Try and Try again…You will succeed atlast!!
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

If you wish you can handle the same in unix also
pandeeswaran
BradMiller
Premium Member
Premium Member
Posts: 87
Joined: Mon Feb 18, 2008 3:58 pm
Location: Sacramento, CA

Post by BradMiller »

When you say you are writing data to files, are you using the Sequential File stage? If so, you can just append the system date parameter to the end of your file name: /path/FileName_#DSJobStartDate#.txt
Post Reply