DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Deepa
Participant



Joined: 10 Dec 2005
Posts: 7

Points: 127

Post Posted: Sat Jan 21, 2006 7:29 am Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Unix
Additional info: DS EE 7.5 version
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

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 39270
Location: Denver, CO
Points: 200571

Post Posted: Sat Jan 21, 2006 8:13 am Reply with quote    Back to top    

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 usin ...

_________________
-craig

If you try and take a cat apart to see how it works, the first thing you have on your hands is a non-working cat. -- Douglas Adams
Rate this response:  
Not yet rated
kumar_s

Premium Poster


since February 2006

Group memberships:
Premium Members, Heartland Usergroup

Joined: 16 Jun 2005
Posts: 5235

Points: 26302

Post Posted: Mon Jan 23, 2006 12:39 am Reply with quote    Back to top    

Hi,

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

-Kumar
Rate this response:  
Not yet rated
makreddy
Participant



Joined: 14 Sep 2005
Posts: 21
Location: hyderabad
Points: 129

Post Posted: Mon Jan 23, 2006 1:33 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours