Data Insertion Issue with Float datatype

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sohasaid
Premium Member
Premium Member
Posts: 115
Joined: Tue May 20, 2008 3:02 am
Location: Cairo, Egypt

Post by sohasaid »

chulett wrote: it's not always gospel as the viewer has issues of its own. Use it as a general check of correctness but when you really really need to know what's in there, use another tool.
That's right.
Just for the record, sqlplus & Toad were viewing (REAL,FLOAT,DOUBLE) data correctly, but DataStage viewer & DbVisualizer tool have some problems with showing the same datatypes data.
Also, DataStage viewer shows data of REAL correctly when reading it as DECIMAL (x, y).

Thanks, chulett. :)
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”