DSXchange

Hi,

I am reading from db2 table having column datatype of type double 8.

When i import table definitions the DataStage takes this as double 53.

When i query the table for the column i see values like

100
6.94391376623802
0.638014075806097


But when i see extracted data in a sequential file in unix i see data for

100 like this 1.00000000000000000E+02
0 like this 0.00000000000000000E+00


Help is appreciated how i get this as 100 and 0 as i see it in database.

First suggestion would be an exact search here for "scientific notation".

Did search but could not find anything suitable for my needs.

I am thinking the only way i can do is to convert to a decimal.

I would like to know which function can be used. And what should be the length and precision of decimal in order not to truncate any data.

Appreciate help on this.

These representations ARE decimal.

I like then without the scientific notations.

Like this format 100 or 0.78558

Not with 10000E+2

Appreciate help.

"CAST " it.

I have a similar issue..can somebidy tell me if we can use a environment variable or some configuration setting , where we can fix this double column and the data read is corrrected.

Its not easy to cast every column in a job as we have lot of jobs in the project.

It's not difficult, it's merely tedious.