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
- 6247 Views
- I also Faced
- E-Mail Answers
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 |
Under IDCAMS , multiple functions can be executed, each of which returns a cond code. What will be the condition code returned to the operating system ?
What is a ca split?
What is an alternate index?
What is the VSAM-code field?
Is CA(Control Area) is part of CI(Control Interval)
What is the difference between lds and esds?
explain in brief what are the 3 types of vsam files?
What is Base Cluster ?
there are seven idcams commands in vsam. Can you name and explain each of them?
is it necessary that all versions of the gdg have to be of the same record length?
in a cobol select statement, can you tell what is the organization for a ksds?
What are the distinctive features of a ksds, key sequenced dataset?
COBOL 
