Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> VSAM
  2. Suggest New Category

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.

Question Posted / raviteja_g


Hi, I want to create alternate index on VSAM file.my file structure is ex: Ro..

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

Post New Answer

More VSAM Interview Questions

What is File Status in VSAM?

1 Answers   IBM,

What is the Difference between LDS & ESDS ?

3 Answers  

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

0 Answers  

How is record management performed in vsam?

0 Answers  

How do you calculate record size of an alternate cluster? Give your values for both unique and nonunique.

1 Answers   IBM,

What is the meaning of dynamic processing?

2 Answers  

What is the biggest disadvantage of using a vsam dataset?

0 Answers  

What are the distinctive features of a ksds, key sequenced dataset?

2 Answers  

Explain the catalog?

0 Answers  

if not using the 'commit' when closing VSAM file,what will happend

5 Answers   CSC,

there are seven idcams commands in vsam. Can you name and explain each of them?

0 Answers   IBM,

By seeing the file itself how can we identify whether it is A vsam file or flat file

7 Answers   IBM,

For more VSAM Interview Questions Click Here
Categories