Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Build alternate index to access record via alternate key

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
Author Message
sumivel

New User


Joined: 13 Sep 2005
Posts: 17

PostPosted: Tue Nov 01, 2005 4:04 pm    Post subject: Build alternate index to access record via alternate key
Reply with quote

in my ksds vsam file ....

vsam-rec
05 KEY-FLD
10 REGN X(9).
10 NRIC X(8).

The primary key is KEY-FLD and alternate key is NRIC.

i've defined the vsam cluster with keys(17,0)

and in my cobol program i'm using the alternate key to
access single record in this vsam file.
is there a need to build an alternate index for this vsam file.
Back to top
View user's profile Send private message
References
gigs

New User


Joined: 08 Aug 2005
Posts: 25

PostPosted: Thu Nov 03, 2005 5:12 pm    Post subject: Re: Build alternate index to access record via alternate key
Reply with quote

Sure, you have to BLDINDEX and also to DEFINE PATH otherwise you can't access VSAM file using AIX .
Back to top
View user's profile Send private message
paulstephen

New User


Joined: 20 Oct 2005
Posts: 23
Location: Chennai

PostPosted: Thu Nov 03, 2005 5:54 pm    Post subject:
Reply with quote

I think the build index would be required only if you a creating alternate index to an existing VSAM file (ie) which has some records.
Correct me if im wrong
Back to top
View user's profile Send private message
sumivel

New User


Joined: 13 Sep 2005
Posts: 17

PostPosted: Thu Nov 03, 2005 8:25 pm    Post subject: Re: Build alternate index to access record via alternate key
Reply with quote

yes...i built index for existing vsam file..it worked....thanks a lot
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1