Numeric to decimal Data Type problem

[kd813]

Hi,

I am reading data as numeric(9,3) and the data is like 1.22,1.00,0.00.1.234,1.230
and want the output data in the below format as
1.22,1,0,1.234,1.23

how to achieve this?

Thanks,
kd813

[Abburi]

Hi,

I am reading data as numeric(9,3) and the data is like 1.22,1.00,0.00.1.234,1.230
and want the output data in the below format as
1.22,1,0,1.234,1.23

how to achieve this?

Thanks,
kd813

Hi,

are you talking about remove null/0 values which are placed after decimal point, say 1.00 to 1, is it ? Can you provide some more info for better understanding

[ds_developer]

Where are you putting the data...in a database, in a sequential file? The solution depends on your target.

John

[kd813]

Where are you putting the data...in a database, in a sequential file? The solution depends on your target.

John

I m putting it in a sequential file

[ray.wurlod]

The easiest solution is to use a server job or a "BASIC Transformer" stage in a parallel job. Simply add 0 to the number; DataStage BASIC returns the shortest possible string for each arithmetic result.

[JoshGeorge]

Read it as 'Real' (9,3) you will get the output you asked for.

[kd813]

if i m reading it as real(9,3)
then the output is like
1.0123000E+01 for input 10.123

[JoshGeorge]

Just write what ever you read from the source as 'Real' to a peek or a file with final source value as VARCHAR and see the result.

[kd813]

going further its required to perform some mathematical operations on the data so its not feasible to store it as varchar