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 meant by BUFND & BUFNI..?

1 Answers  

what do you mean by a vsam slot?

0 Answers   IBM,

How to rename one vsam file as well as it's index?

4 Answers   BEA,

What is the purpose of having vsam data space?

0 Answers  

HOW TO SORT RECORDS IN VSAM FILE?

3 Answers  

how to view clusters that has more than 10000 records

2 Answers  

what is the purpose of the verify function of idcams?

0 Answers   IBM,

What does a file status of 02 on a VSAM indicate?

1 Answers   IBM,

Define base cluster?

0 Answers  

why ci and ca splits are not possible in esds and rrds?

0 Answers   IBM,

What are the common vsam error conditions and codes?

0 Answers  

What is an alternate index and path ?

2 Answers   Infosys, TCS,

For more VSAM Interview Questions Click Here
Categories