DDWKEY0013 SIGNED NUMERIC FIELD IN KEY

Products

• Datacom
• Datacom/AD
• Datacom/DB
• DATACOM - AD

Issue/Introduction

I created a new Datacom database in datadictionary. When doing a VERIFY I'm getting the error below but when I copy it from TEST to PROD version there is no error.

DDWKEY0013 SIGNED NUMERIC FIELD IN KEY                                  

 

Environment

Release: 15.1

Resolution

The DDWKEY0013 message is just a warning that a key contains a field that is signed numeric. 
This may not be a problem.
The description for message DDWKEY0013 explains in what situation this may be a problem and how to fix it. 

DDWKEY0013
SIGNED NUMERIC FIELD IN KEY

Reason:
During the verification of a DATABASE structure, a KEY substructure was detected that contains a FIELD entity-occurrence with a TYPE attribute-value of N or D and a SIGN attribute-value of Y. Use of a signed numeric FIELD entity-occurrence 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 DATA-SENSITIVE attribute-value to Y.