DSF Return Codes › BDV

BDV

BAD DEFAULT VALUE

Reason:

A default value was specified on a simple FIELD entity-occurrence with DEFAULT-INSERT=0, but the value is inconsistent with the data type for the FIELD entity-occurrence. The following are examples:

• A default value is allowed for binary fields (type B) when the length is two or four only. The value for these fields can be an integer, that is, they cannot contain a decimal point. See the CA Datacom/DB SQL User Guide for more information on allowable values for numeric fields.
• If the FIELD entity-occurrence is defined as a variable character data type, the length specified in the first two bytes of the value must agree with the number of characters that follow. For example, 03xxx is valid, but 03xxxx is not.
• If the semantic-type is SQL-DATE, SQL-TIME, or SQL-STMP, the date, time, or timestamp must be keyed in one of the formats described in the CA Datacom/DB SQL User Guide.

Action:

Correct the attribute-value for DEFAULT-INSERT or change the data type value.