Version 4.2.6 for Mainframes
 —  Database Management System Interfaces  —

NDB - Incompatibilities and constraints

This section lists the known incompatibilities and constraints against DB2 when using Natural for DB2 to access data from DB2.


Data Type DECIMAL or NUMERIC

Most SQL database systems support packed decimal numbers with a maximal precision of 31 digits and a scale (fractional part of the number) of up to 31 digits. The scale has to be positive and not greater than the precision. Natural allows only a precision of 29 digits and the scale could not be greater than 7.

Top of page