Hi,
I want to create alternate index on VSAM file.my file
structure is ex:
RoomID pic x(7) R000001
Floor pic a((6) First
RoomNo pic x(2) FA1
Occupied(yes/no) pic a(3) Yes
Occupied Batch pic x(10). Maths
i want to create alternate index on floor,roomno fields.can
i create alternate index on both the fields.and tell me how
to create.
Answer Posted / lu
I think you could define like this:
1) define Aix ,
2)key (8,8)....
3)DEFINE the PATH
4)LOAD BLINDX
in COBOL program...
File-control.
Select ........
ACCESS is DYNAMIC
ORGANIZATION IS INDEXED
RECORD-KEY IS ROOMID-KEY
ALTERNATE KEY IS FLOOR-ROOMNO WITH DUPLICATE KEY
FILE STATUS IS TEST-FILE_STATUS.
FILE SECTION.
FD ......
01 Record-vasm
02 Roomid-key pic x(09).
02 Floor-roomno.
03 Floor pic x(06).
03 Roomno pic x(02).
02 OCCUPIED....
try it, in JCL DD you give the PATH NAME
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
if you wish to use the rewrite command how must the vsam file be opened?
how do you create an alternate index ?
How does control intervals and control areas related to each other?
What does the keyranges parameter in define cluster command do?
Explain the device independent method to indicate where a record is stored?
What is the use of KSDS,LDS,ESDS,RRDS??what is VRRDS?? How are all these useful in realtime scenario??Plz helpme out...Its a recent question in IGATE..
how do you define an altindx ? How do you use altindxs in batch, cics programs?
What makes vrrds different from vsam?
why ci and ca splits are not possible in esds and rrds?
What is the function of entry sequenced data set?
What is speed parameters in define cluster command?
Describe the uses of ams?
Define dynamic processing?
in a cobol select statement for a ksds can you tell me what are the 3 possibilities for access?
what do you mean by a vsam slot?