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?

Anyone have any ideas?

BR
Tim