Decimal values in exponential form

[eze_ke]

Hi All,
I want to know can we read the decimal data in exponential form like 1.7088E7.. in datastage where source column is defined as decimal.

I defined the above column as decimal as we are using this values in calculations

Thanks
Eze ke

[ray.wurlod]

In server jobs the answer is yes; for parallel jobs I don't know. Why not try it and let us all know?

[eze_ke]

Hi,

I designed the job in which one of the columns is decimal; I'm using this column in calculations.
This column values from the Source are coming in exponential form like 1.7088E7.
Job is not running in parallel.
Can any one explain me how to read the decimal values in exponential form in datastage.
Note need to perform calculations on this column)


Thanks
eze_ke

[dsusr]

Hi All,
I want to know can we read the decimal data in exponential form like 1.7088E7.. in datastage where source column is defined as decimal.

I defined the above column as decimal as we are using this values in calculations

Just try to use the data format double and since datastage normally writes the double data in exponential form.
I haven't tried it but i think it will work fine as i have faced a similar kind of issue earlier.