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
- 6170 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
explain how do you define a gdg in vsam?
what do you mean by a shareoptions parameter (shr) in define cluster command?
Explain the significance of the shareoptions parameter?
What are the building blocks used in vsam datasets?
explain how can you initialize a vsam file before any operation?
name the utility program closely associated with vsam?
What is a ca split?
Define a path?
what do you mean by the cobol record key clause in vsam?
what are the codes returned by the ams (access method services) command during the execution in vsam?
how can you load a vsam data set with records ?
What is the purpose of idcams?
Tell me how many alternate indexes you can have on a dataset?
What is a ci split?
what do you mean by gdg in vsam?
