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



Joined: 29 Dec 2007
Posts: 41

Points: 459

Post Posted: Sat Mar 01, 2008 8:02 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi ,
I am having data as below .....

abcd123457020080301470789

field delimiter is none .fixed width file .

actual metadata is as follows :

1st field 1-4 ---- abcd --- char

2nd field 5-11 ---- 1234570 -- number

3rd field 12-19 ---- 20080301 --- date

4th field 20-22 ----- 470 -- decimal (3,1) actual value is 47.0

5th field 23-25 ----- 789 ---number ----

While reading this file from a sequential file , If i am giving metadata as char for all fields , then only I am able to view data otherwise no .
When I am using char for all above fiels then 4th field is displaying like 470 instead of 47.0 .offcourse i can user transformer or modify and do necessary changes ..Other than that , Is there any way to handle it ??
The problem is I have some 150-180 fields , Its very difficult to again convert them in transformer stage .So , It should be handled in sequential file . I request you all to help me out in this problem .

Thanks in advance

_________________
gikjpjj
kumar_s

Premium Poster


since February 2006

Group memberships:
Premium Members, Heartland Usergroup

Joined: 16 Jun 2005
Posts: 5245

Points: 26379

Post Posted: Sat Mar 01, 2008 10:19 am Reply with quote    Back to top    

You can specify the Integer (Number) and not as Decimal or without precision.

_________________
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
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