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

how can you copy to a vsam cluster?

0 Answers   IBM,

What is the purpose of idcams?

0 Answers  

How to createing new version of GDG with out loosing the data in preaves GDG version?

7 Answers   Patni, Satyam,

what is meant by s0c-07 system abend codes?

0 Answers   IBM,

What is an RBA in rrds? What does it do? What is it used for?

5 Answers   CTS,

what parameter in the define aix option is used to determine the maximum number of duplicate keys allowable ?

0 Answers   IBM,

What is the base cluster?

1 Answers   CGI,

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

0 Answers   IBM,

In vsam why we use export-import utility?

3 Answers  

how can you load a vsam data set with records ?

0 Answers   IBM,

What is a ci split?

0 Answers  

During processing of a VSAM file, some system error occurs and it is subsequently unusable . What do you do ?

1 Answers  

For more VSAM Interview Questions Click Here
Categories