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
Default Timestamp Format in Datastage EE
Moderators: chulett, rschirm, roy