Default Timestamp Format in Datastage EE

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
Deepa
Participant
Posts: 7
Joined: Sat Dec 10, 2005 5:22 am

Default Timestamp Format in Datastage EE

Post by Deepa »

Hi All,

We have some columns in our job with datatype as timestamp in target stage. We have given length 26 scale 6 with extended option checked with microseconds.
1. We have current timesatmp() function in the tranformer stage for assigning value to the target column.
2. Secondly we have tried passing the value to the column through parameter where we are giving a run time value like 2006-01-21-02.03.09.111111.

We are passing the microseconds values and the extended option for microseconds is checked as well. But the target column is getting a value like 2006-01-21-02.03.09.000000 only. that is microseconds are not being passed via datasatge. Although proper values (with microseconds) are loaded into the table via insert sql.
Actually the Dtastage EE project and system default format for timesatmp is %yyyy-%mm-%dd %hh:%nn:%ss and it has no microseconds. This is why DSPX is dropping the microseconds values.

Plz let me know how can we change this default format to take in microseconds as we want to retain the microsecond values as we have some routines which take timestamp value from the table and work.

Thanks
Deepa
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Search the forum for 'microseconds' and you should find some recent conversations on this very topic. From what I recall reading, this is an issue with the base product and needs to be dealt with using some custom code.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Hi,

Also its not mandate that timestamp or date field need to be defined with lenght. DataStage can handle by itself.

-Kumar
makreddy
Participant
Posts: 21
Joined: Wed Sep 14, 2005 10:40 pm
Location: hyderabad
Contact:

Post by makreddy »

Hi,
I faced similar problem with DB2 API stage. So the turn around is tead the timestamp is string and load it, as DB2 API stage can handle even if the meat datas are different.

Thanks
Aravind
Aravind
Post Reply