All,

When selecting data via a database link from Oracle 8.1.7 to AS/400
via heterogeneous services, the numbers are truncated so decimals are
lost.

Remarkable is that when I select the column * 100, i do see the
decimals in the last two digits. But when I select the column * 100
into an Oracle table then 00 is stored so the decimals are lost again.

Any suggestions? Could it be a regional settings/decimal notation
issue? I've tried some changes there (as in the Netherlands the
default decimal separator is comma, but with no success. Any other
suggestions?

TIA
Marc