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
What are the steps involved in access method services?
What does the keyranges parameter in define cluster command do?
Explain the function of the relative record data set?
Would you specify freespace ce for an esds?
What are the different parameters that are used in vsam?
what is the probability of a complete system distortion under high end low performing multiprocessor job?
Why is it required to have a keyed directed retrieval?
What is control area?
how do you define an altindx ? How do you use altindxs in batch, cics programs?
What is a ca split?
What are the access method services used in vsam?
we can define the ksds cluster by two ways by using the file-aid or by using the idcams utility. Explain them.
name the utility program closely associated with vsam?
How to get the last record in vsam file in cluster? And how can u get the ksds file records into cobol program?
what do you mean by the repro command?