Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 6095 Views
- I also Faced
- E-Mail Answers
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
Define free space?
explain in brief how you can create a vsam file?
What is a lds (linear data set) and what is it used for?
Why is master catalog used in vsam?
What is recovery parameters in define cluster command?
What is the main function of key-sequenced data set?
What are the different dataset organizations used in vsam?
what do you mean by idcams? Explain its purpose?
How is record management performed in vsam?
What is the purpose of control intervals in vsam?
how do you create an alternate index ?
explain in brief what are the 3 types of vsam files?
what is the meaning of dynamic processing in vsam?
difference between vsam and database tables
explain in brief how are different versions of gdg named?
