This option specifies various implementation limits.
.-+---+-------------------------------------. | '-,-' | V .-7-. | >>-LIMITS--(----+-EXTNAME--(--+-n--+--)-----------------+-+--)->< | .-31-. | +-FIXEDBIN--(--+-63-+--+-----------+--)-+ | | .-31-. | | | '-,--+-63-+-' | | .-15-. | +-FIXEDDEC--(--+-31-+--+-----------+--)-+ | | .-15-. | | | '-,--+-31-+-' | | .-100-. | '-NAME--(--+-n---+--)-------------------'
If FIXEDDEC(15,31) is specified, then you may declare FIXED DECIMAL variables with precision greater than 15, but unless an expression contains an operand with precision greater than 15, all arithmetic will done using 15 as the maximum precision.
FIXEDDEC(15,31) will provide much better performance than FIXEDDEC(31).
FIXEDDEC(15) and FIXEDDEC(15,15) are equivalent; similarly, FIXEDDEC(31) and FIXEDDEC(31,31) are equivalent.
FIXEDDEC(31,15) is not allowed.
The default is FIXEDDEC(15,15).
If FIXEDBIN(31,63) is specified, then you may declare 8-byte integers, but unless an expression contains an 8-byte integer, all arithmetic will done using 4-byte integers.
FIXEDBIN(63,31) is not allowed.
The default is FIXEDBIN(31,31).
The maximum precision for UNSIGNED FIXED BINARY is one greater, that is, 32 and 64.
DEFAULT: LIMITS(EXTNAME(100) FIXEDBIN(31,31) FIXEDDEC(15,15) NAME(100))