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 the difference between CI( Control Interval)and CA (Control Area)?

3 Answers   Infosys, TCS,

What is speed parameters in define cluster command?

0 Answers  

name a few common vsam status codes?

0 Answers   IBM,

How to open VSAM file from 3.4? i have millions of records and i dont want to use the print ch ids(/) command bcz it takes to much time. so if you have any another command to open this plz tell me.

2 Answers   HSBC,

What are the different types of VSAM files available?

3 Answers   CSC,

Tell me how many alternate indexes you can have on a dataset?

0 Answers  

what is a Base Cluster?

3 Answers   HSBC, TCS,

In the COBOL SELECT statement for a KSDS what are the three possibilities for ACCESS?

3 Answers  

Define dynamic processing?

0 Answers  

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

5 Answers   CSC,

what is the drawback of vsam dataset?? a.execution slow. b.free space. c.independent storage device. d.none of the above. let me know the answer with reason.

4 Answers   Target,

in a cobol select statement for a ksds can you tell me what are the 3 possibilities for access?

0 Answers   IBM,

For more VSAM Interview Questions Click Here
Categories