DSXchange

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

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.

Hi,

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

-Kumar

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