DSXchange

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

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

ds_developer wrote: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

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

I have to specify null value to a column as the default value
@NULL system variable could be used for this is DS server version but this variable is not coming in paralle.
How could this be achieved?