My first guess would be that you and your client are using different versions of ODBC driver.

>H, I am having a problem with decimals.
>
>Basically in DB2 I made a table like this:
>
>drop table uw.test;
>create table uw.test (n1 decimal(9,4),n2 decimal(9,3),n3 decimal(9,3),n4 decimal(9,4),n5 decimal(9,4));
>insert into uw.test values (1.900,1.900,1.900,1.900,1.900);
>
>Then on 1 client I select the table with ODBC using:
>
>sqlexec(h,'select * from uw.test','test')
>
>then if I do a
>?n1
>
>It returns 1.000 the decimals are missing!!
>
>If I browse the table I see the values as 1.9 in all the field
>except when I tab into each field the value changes to 1.0 if I retype the value then it stays in the field the next time I tab.
>
>This only happens on "their" clients on my PC this works fine?
>