$NUMERIC_CHECK

Check whether the size of the Numeric data type falls inside the limits set for the packing code.

Arguments

• ON—Uniface checks that the value to be stored in the DBMS for a Numeric data type, falls within the upper and lower limit set by the Uniface packing code. If it does not, an error occurs when leaving the field and the data is not stored.
• OFF—Uniface does not perform the Numeric check. This can cause incorrect data to be stored. Data that falls outside the limits of the Uniface packing code for that field is truncated according to the storage format for the external DBMS connector.

Defaults

Description

$NUMERIC_CHECK determines if Uniface checks the limits set by the Uniface packing code before storing a Numeric data type in the DBMS. This check does not apply to data type Float.

When the setting is not present, Uniface behaves as if $NUMERIC_CHECK is ON.