The CheckPrecision38Limit() function

Verifies that an input numeric value is within the 38-digit limit of a numeric. Netezza Performance Server storage limits require that a numeric cannot have more than 38 combined digits before and after the decimal point.

Description

The function has the following syntax:
CNumeric128 const& CheckPrecision38Limit(CNumeric128 const& value)
where value specifies a fixed-point numeric value.

Returns

The function returns a reference to the input 128-bit numeric value or throws an error.

Throws

The function throws the error Numeric value requires more than 38 digits if the input numeric value has more than 38 digits.