Append Current time stamp for existing column

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
vijaykatneni2
Participant
Posts: 16
Joined: Thu Jul 26, 2007 12:38 pm

Append Current time stamp for existing column

Post by vijaykatneni2 »

Hi,

Does anyone have idea how to append the current timestamp for a existing Target column in transformer stage.

Thanks in advance.

Thanks & Regards,
Vijay Katneni.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Almost certainly someone does. But without telling us the data type of the target column, it's impossible to advise.

On the other hand, if you want the column name to have a timestamp appended dynamically, that's a whole different bucket of fish, and I would venture to say that it's impossible.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

In other words, you'll need to be more explicit. Examples are always good. Well... as long as they are good examples. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
dspxlearn
Premium Member
Premium Member
Posts: 291
Joined: Sat Sep 10, 2005 1:26 am

Post by dspxlearn »

Did you try out this before posting:

Code: Select all

CurrentTimestamp()
Thanks and Regards!!
dspxlearn
dspxlearn
Premium Member
Premium Member
Posts: 291
Joined: Sat Sep 10, 2005 1:26 am

Post by dspxlearn »

Did you try out this before posting:

Code: Select all

CurrentTimestamp()
Thanks and Regards!!
dspxlearn
Post Reply