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 |
Explain the index set?
What is VERIFY command ? when do you use this command?? What actually it does ??
name a few common vsam status codes?
What is the meaning of VSAM RETURN-CODE 28?
Define dynamic processing?
What is the maximum number of Alternate Index ???
Explain the catalog?
What is an RBA in rrds? What does it do? What is it used for?
What are the steps involved in access method services?
can i see how many records does a vsam file have without browsing or without using file-aid? and same for ps file?
what is the meaning of each of the values in shareopts(2 3)?
Assuming that the DEFINE JCL is not available, how do you get info about a VSAM file's organisation?