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
- 6145 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
What makes vrrds different from vsam?
we can define the ksds cluster by two ways by using the file-aid or by using the idcams utility. Explain them.
why ci and ca splits are not possible in esds and rrds?
Using alternate indexes in batch program?
what is buffering and how does it apply to vsam files ?
How does control intervals and control areas related to each other?
Explain the biggest disadvantage of using a vsam dataset?
explain how many ways you can load data in a vsam cluster?
there are seven idcams commands in vsam. Can you name and explain each of them?
What is a base cluste?
what how do you initialize a vsam file before any operation? A vsam with alternate index?
in a cobol select statement for a ksds can you tell me what are the 3 possibilities for access?
Explain the significance of the shareoptions parameter?
What is a lds (linear data set)?
to use the rewrite command, how should the vsam file be opened?
