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
- 6243 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 |
Suppose 3 generations of a GDG exist. How would you reference the 1st generation in the JCL?
What is a sequence set?
can alternate index use in ESDS since it does not contain primary index? if yes can you explain?
what is the concept of IMPORT in vsam??
explain the information contained in ci
OPEN INPUT StudentFile READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ PERFORM UNTIL EndOfStudentFile DISPLAY StudentId SPACE StudentName SPACE CourseCode SPACE YOBirth READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ END-PERFORM CLOSE StudentFile STOP RUN what will be output
What are the different dataset organizations used in vsam?
what is meant by dirty read in vsam?
By looking into the Jcl can we identify the dataset is VSAM?
5 Answers Cognizant, Keane India Ltd,
Explain the catalog?
How to insert values for variables that are declared as COMP-3 variables in COBOL program in an already created VSAM file.
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 ?
COBOL 
