Posted: Thu Mar 11, 2010 4:11 am
That's right.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.
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.
![Smile :)](./images/smilies/icon_smile.gif)