Determine Precision and Scale

For numeric and decimal datatypes, each combination of precision and scale is a distinct SAP ASE datatype.

If you perform arithmetic on two numeric or decimal values:

SAP ASE determines the precision and scale of the results:

Operation

Precision

Scale

n1 + n2

max(s1, s2) + max(p1 -s1, p2 - s2) + 1

max(s1, s2)

n1 - n2

max(s1, s2) + max(p1 -s1, p2 - s2) + 1

max(s1, s2)

n1 * n2

s1 + s2 + (p1 - s1) + (p2 - s2) + 1

s1 + s2

n1 / n2

max(s1 + p2 + 1, 6) + p1 - s1 + p2

max(s1 + p2 -s2 + 1, 6)