AS400

1215 pts.
Tags:
IBM DB2
In DDS, Unique is file level keyword. Is there any specific key word for field level?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi,

Yes, there are plenty of field level keywords – for example :-

COLHDG
TEXT
EDTCDE
EDTWRD
REFFLD
VALUES

Regards,

Martin Gilbert.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • rajeshece
    A UNIQUE A R REC1 PFILE(FILE1) A K Num A K Age In the Above code, Num and Age Combination is unique. Like Num Age 1 1 1 2 2 1 2 2 But i want to be like Num Age 1 1 2 2 Here num is unique and Age is Unique. Combinations is also unique Is there ant specific keyword for this condition
    1,215 pointsBadges:
    report
  • Gilly400
    Hi, There's no specific keyword for this condition. One solution would be to build 2 logical files - the first logical with only NUM as key and UNIQUE specified and the second logical with only AGE as key and UNIQUE specified :- LF1 :- A UNIQUE A R RECL1 PFILE(FILE1) A K Num LF2 :- A UNIQUE A R RECL2 PFILE(FILE1) A K Age You'll have to make sure that your applications handle errors caused by trying to add duplicate keys to these logicals. Regards, Martin Gilbert.
    23,730 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following