I am fetching a decimal field(10,2) as sum(skd_hrs) and loading into a fixed width sequential file as Decimal(10,2) . The problem is the value for example 89.55 is getting round of to 90.00 and so on .All the values are getting round off .Other then sum(column) i am not using any logic .
[quote="chulett"]So what stages are you using in your job? And this sum() you are fetching is using a 'group by' in your source sql I assume, yes? ...[/quote]
Stages used are DB2 Stage ,lookups ,Transformer and sequential Files.
YES I m using 'group by' in source sql
Is your output column to the sequential defined as Decimal(10,2) or as a string?
How about doing an explicit conversion in your transform stage using DecimaltoString() and writing a varchar to the sequential file (assuming you are currently writing a decimal field)? That explicit conversion is better than the implicit one done int he sequential file stage.
The issue got resolved . Actually at the Data Base lavel the type is decimal(12,2) and before loading i had given decimal(10,2) so it was round offing . I gave decimal(10,2 ) everywhere and its working fine now .