How to declare VSAM keys

dipanshu · New User Joined: 16 Jan 2006 Posts: 53 Location: pune

Hi,

INPUT-OUTPUT SECTION.
FILE-CONTROL.
SELECT PPIMSTR
ASSIGN PPIMSTR
ORGANIZATION IS INDEXED
RECORD KEY IS M-ENO
ACCESS MODE IS SEQUENTIAL
STATUS X01-PPIMSTR-STATUS.

In the above code I given record key as ENO,
Confusion: If the vsam having two keys say EID and ENO then how to declare?

Thanks
Dipanshu

ofer71 · Posted: Mon Feb 20, 2006 10:27 am

As far as I know, you can have only one Prime Index in a KSDS file, and one Alternate Index.

The RECORD KEY clause specify only the Prime Index.

O.

sbalajibe · New User Joined: 15 Aug 2005 Posts: 62

hi ofer71,

u can have 255 alternate index for a vsam file....

and the key is represented with ALTERNATE KEY IS caluse...

thanks
Balaji