Previous Topic: DDWKEY0022Next Topic: DDWKEY0029


DDWKEY0023

SIGNED UNCONVENTIONAL FIELD IN KEY

Reason:

During the verification of a DATABASE structure, a KEY substructure was detected that contains a FIELD entity-occurrence with TYPE attribute-value of N or D and a TYPE-SIGN attribute-value of U or Q. Use of unconventional signed numeric FIELD entity-occurrences in a key can cause the data records to be sorted and retrieved in a different sequence than expected.

Action:

This is a warning message only. No action is required if this manner of sorting and retrieval is acceptable. To obtain a logical sorting sequence, change the KEY entity-occurrence DATASENSITIVE attribute-value to Y.