Column generator to generate timestamp

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
bakul
Participant
Posts: 60
Joined: Wed Nov 10, 2004 2:12 am

Column generator to generate timestamp

Post by bakul »

Hi,

I need to generate 2 columns of type timestamp and add them to input data stream.

The value of the timestamp fields should be current timestamp.

Does column generator provide a Generator type to create current timestamp? For dates, it does provide an option of 'use current date'. I see no similar option for timestamp.

Is there a way to achieve this?

Regards,
Bakul
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I'm too far away from the docs, just add a transform stage, create the column and fill it using the builtin values for the current timestamp (CurrentTimestamp and CurrentTimestampMS).
bakul
Participant
Posts: 60
Joined: Wed Nov 10, 2004 2:12 am

Post by bakul »

Yes, that's what we have done.

Just wanted to check if it is possible in column generator thereby avoiding use of transformer.
Regards,
Bakul
Post Reply