Page 1 of 1
Decimal values in exponential form
Posted: Fri Dec 16, 2005 10:46 am
by 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
Posted: Fri Dec 16, 2005 2:25 pm
by 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?
Posted: Fri Dec 16, 2005 4:22 pm
by 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
Re: Decimal values in exponential form
Posted: Sat Dec 17, 2005 5:15 am
by dsusr
eze_ke wrote: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.