Can we attach Timestamp to a Output File

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
vinodn
Charter Member
Charter Member
Posts: 93
Joined: Tue Dec 13, 2005 11:00 am

Can we attach Timestamp to a Output File

Post by vinodn »

Hi All,

Can we attach Timestamp to a Output File generated by Sequential File Stage.

Is it possible.

Thanks in Advance
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Yes.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
vinodn
Charter Member
Charter Member
Posts: 93
Joined: Tue Dec 13, 2005 11:00 am

Post by vinodn »

ray.wurlod wrote:Yes.
Hi Ray,

Can I know how It can be done
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

You can either pass the Timestamp as a job parameter and include that in your file name option (#Dir##FileName##TimeStamp#) the sequential file stage or use

Code: Select all


mv <Dir>/<FileName> <Dir>/<FileName>`date '+%Y-%m-%d:%H:%M:%S'`

in the job parameter grid option for after job ExecSH option.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Post Reply