Numeric Data Validation

Numeric data that contains illegal digits (for example, values other than 0 through 9, excluding the sign field for signed numbers) are flagged as bad. If the da_options column of the corresponding DATAITEMS control table entry has the DAOPT_Allow_Nulls bit (1) set, DATABridge stores a value of NULL for numeric items that have bad digits.

The configuration parameter allow_nulls defines the default value for this bit, which can be altered by user scripts. If the bit is zero, the NULL or bad numeric data is stored as either all 9s or all 0s based on the value of the configuration parameter, null_digit_value (default value is 9). For more information, see allow_nulls and null_digit_value.