In NUMERIC data type, precision (P) is the number of digits in a number, and scale (S) is the number of digits to the right of the decimal point in a number. For example, the number 123.45 has a precision of 5 and a scale of 2.
Length (L) for a numeric data type is the number of bytes that are used to store the number.
In OpenAccess SDK, the default maximum precision of a numeric data type is 127, and the scale varies between zero and precision (0 <= S <= P).
• Maximum precision (P) is 127
• Maximum scale (S) is 127
• Mantissa (M = P - S) can range from 0 to 124
The following examples describe valid and invalid numeric ranges for NUMERIC (P, S):
Valid Numeric ranges
NUMERIC (127, 127) --> P = 127, S = 127, M = 0
NUMERIC (127, 3) --> P = 127, S = 3, M = 124
NUMERIC (124, 0) --> P = 124, S = 0, M = 124
Invalid Numeric ranges
NUMERIC (127, 0/1/2) --> P = 127, S = 0/1/2, M = 127/126/125
NUMERIC (126, 0/1) --> P = 126, S = 0/1, M = 126/125
