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...

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.

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

if you wish to use the rewrite command how must the vsam file be opened?

1203


how do you create an alternate index ?

1120


How does control intervals and control areas related to each other?

1071


What does the keyranges parameter in define cluster command do?

1119


Explain the device independent method to indicate where a record is stored?

968


What is the use of KSDS,LDS,ESDS,RRDS??what is VRRDS?? How are all these useful in realtime scenario??Plz helpme out...Its a recent question in IGATE..

8825


how do you define an altindx ? How do you use altindxs in batch, cics programs?

1118


What makes vrrds different from vsam?

1302


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

1213


What is the function of entry sequenced data set?

1141


What is speed parameters in define cluster command?

1110


Describe the uses of ams?

1054


Define dynamic processing?

1062


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

1247


what do you mean by a vsam slot?

1047