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 / 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 |
What is File Status in VSAM?
Explain the index set?
What is a path?
What are the different dataset organizations used in vsam?
if you wish to use the rewrite command how must the vsam file be opened?
How to declare the EMP Name, EMP No., DOB in VSAM KSDS file? Please explain.....
Explain the biggest disadvantage of using a vsam dataset?
What is control interval?
what parameter in the define aix option is used to determine the maximum number of duplicate keys allowable ?
How vsam datasets are cataloged?
What is the purpose of relative record data set used in vsam?
How many Alternate Indexes you can have on a dataset?