An integer expression between 1 and 127, inclusive, that specifies the number of digits in the expression. The default
setting is 30.
An integer expression between 0 and 127, inclusive, that specifies the number of digits after the decimal point. The
scale value should always be less than, or equal to, the precision value. The default setting is 6.
The defaults can be changed by setting the appropriate creation parameter.
The INT function takes the integer portion of its argument. The storage is based on the value being stored, not on the maximum
precision and scale allowed in the column.
If you are using a precision of 20 or less and a scale of 0, it may be possible to use one of the integer data types (BIGINT,
INTEGER, SMALLINT, or TINYINT) instead. Integer values require less storage space than NUMERIC and DECIMAL values with a similar
number of significant digits. Operations on integer values, such as fetching or inserting, and arithmetic operators, typically
perform better than operations on NUMERIC and DECIMAL values.
If you create a column or variable of a DECIMAL data type with a precision or scale that exceeds the precision and scale settings
for the database, values are truncated to the database settings. So, if you notice truncated values in a column or variable
defined as DECIMAL, check that precision and scale do not exceed the database option settings.