Can a VSAM KSDS file will have a 2 unique keys?

esaccy · New User Joined: 19 Feb 2005 Posts: 22

Can a VSAM file will have 2 unique keys?
My requiement
I have a KSDS file of 400 length.
I have 2 unique keys at
first key--(146,5)
Second key---(200,6)

Is it possible to define the KSDS file with these two feilds as key?
Moreover can we read a particular record with these two fields as keys.

Binop B · Posted: Fri Sep 17, 2010 3:18 pm

Please refer to "Alternate Index" concept in the Manuals...

expat · Posted: Fri Sep 17, 2010 3:23 pm

First question - NO, only one key is allowed and it must be unique and contiguous.

Robert Sample · Posted: Fri Sep 17, 2010 3:35 pm

It is not clear what you are asking. The primary key for a KSDS must be contiguous so if you want to create a KSDS with an 11-byte key (5 bytes starting at 146, 6 bytes starting at 200), the answer is that this is not allowed. However, if you are saying that the primary key is 5 bytes starting at 146, and you want to use 6 bytes starting at 200 to merely read the KSDS, you can define those bytes as an alternate index (which can be defined to allow duplicates or to require unique keys).

dick scherrer · Posted: Fri Sep 17, 2010 7:24 pm

Hello,