Today's date

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
Ush
Participant
Posts: 55
Joined: Tue Dec 04, 2007 3:15 am

Today's date

Post by Ush »

Hi,

I need a function/system variable similar to @Date in Server.It should do the following:
At the first call in a job, the function calls the operating system for the date. On the second and subsequent calls, the function returns the value of the first call.

Thanks.
Maveric
Participant
Posts: 388
Joined: Tue Mar 13, 2007 1:28 am

Post by Maveric »

I guess CurrentDate() function in a transformer stage would do the trick.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The DataStage macro DSJobStartTimestamp should be available in a Transformer stage. Or simply initialize a stage variable to CurrentDate() and don't derived it as each new row is processed.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply