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



Joined: 18 Jan 2005
Posts: 42

Points: 389

Post Posted: Mon Sep 12, 2005 7:53 am Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Windows
Hii,
I have 3 decimal fields and all other are char fields.When i view it in unix it give garbage in all decimal field and other char fields are fine.When I view the file in Datastage Sequential File Stage I view all the records properly.I think the problem is in Decimal fields,So i put the DecimaltoString Convertor in the transformer.But then it fills all zeros in the decimal field and shows blank space when viewed in VI Editor.

Please tell me how to implement it So i conver Decimalto String without loosing Data.
Input is Decimal[15,2].Output can be a string of any length.
kumar_s

Premium Poster


since February 2006

Group memberships:
Premium Members, Heartland Usergroup

Joined: 16 Jun 2005
Posts: 5233

Points: 26291

Post Posted: Mon Sep 12, 2005 8:24 am Reply with quote    Back to top    

Hi,
May i know what sort of data you see in vi editor....
if you can able to see all records properly through datastage, then i hope u should not get any error.
Ensure the delimiter are set properly.
Can also try decimaltodecimal....

regards
kumar
Rate this response:  
Not yet rated
Sainath.Srinivasan

Premium Poster
Participant

Group memberships:
Heartland Usergroup

Joined: 17 Jan 2005
Posts: 3337
Location: United Kingdom
Points: 14194

Post Posted: Mon Sep 12, 2005 9:45 am Reply with quote    Back to top    

DataStage does not interpret the values when you view it.

Check whether you are viewing the same file.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 51677
Location: Canberra, Australia
Points: 280650

Post Posted: Mon Sep 12, 2005 3:44 pm Reply with quote    Back to top    

View it with a hex editor and a companion who understands the rules for storage of decimal data types. You will find that it's not "garbage". So string_from_decimal (in a Modify stage) or DecimaltoS ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong
currently hiring: Sydney and Melbourne
Rate this response:  
Not yet rated
jayantthakore
Participant



Joined: 18 Jan 2005
Posts: 42

Points: 389

Post Posted: Mon Sep 12, 2005 10:12 pm Reply with quote    Back to top    

I am viewing the correct file.
The data I view is "^L?" for a field "23.4". .Delimiters are also in place to view it as a CSV.
I have tried the String to Decimal format.Can you give the complete format to be written.
Wat is the function used in a modify Stage??

Thanks for response..
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 51677
Location: Canberra, Australia
Points: 280650

Post Posted: Tue Sep 13, 2005 1:29 am Reply with quote    Back to top    

You're not viewing with a hex editor, or you're not showing us the hex representation (which should be eight bytes long). As to your question, you did not read my prior response very well: Q ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong
currently hiring: Sydney and Melbourne
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