Yes, the handling of sizes is a bit confusing in this case.
When creating a new column there is mapping from DataFlex type to native type:
DF Num 9.0 is mapped to native integer (because the max integer value (2147483647) fits in 9.0)
DF Num 10.0 is mapped to native nuneric(10.0) (because it can contain values larger than the max integer value)
When opening (or connecting to) existing column, there is a native type to DataFlex type mapping
Native integer maps to DF Num(10.0) Because the max integer value (2147483647) is 10 digits.

As IJmert mentions it would be easier if you could enter native types in the Studio, but currently not possible with odbc_drv.


The original issue has been fixed for the next version.