IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Why Alternate Indexes are used


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mohanmaruthi

New User


Joined: 29 Sep 2005
Posts: 4
Location: hyderabad

PostPosted: Wed Oct 05, 2005 9:58 pm
Reply with quote

heloo... I am bit confused of using the Alternate Index???

How it is use full..( i know it is used to get the record ather then primary key.

but.. when I created the AIX cluster, it just gives me the data. and the index... but how it is use full??can any one let me know about, AIX, PATH,
BLDINDEX

I know the meaning of them, but cannot corelate all of them..
Thank you
Back to top
View user's profile Send private message
nikyojin

New User


Joined: 05 Oct 2005
Posts: 94

PostPosted: Fri Oct 07, 2005 2:49 pm
Reply with quote

ALternate Index provides an additional path to access the Vsam file.
Quote:
AIX

While declaring an alternate index the characteristics of the alternate key to be considered is stated.
Quote:
PATH

The path provides a physical path to relate the Alternate Index with the Main cluster.
Quote:
BLDINDEX

Physically records are populated into the alternate Index file when this step is carried out.Each alternate key is associated with one or multiple main keys.

The main purpose of AIX is to access the same file in multiple ways without creating separate copies.
In the program the file can be accessed using the alternate index in the same manner as primary index.AIX key should be declared initially.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Add column to existing records using ... JCL & VSAM 2
No new posts Issue in KWIKKEY utility while creat... JCL & VSAM 2
This topic is locked: you cannot edit posts or make replies. VSE COBOL - File Status 46 when readi... COBOL Programming 8
No new posts ALTERNATE RECORD KEY usage for KSDS AIX COBOL Programming 1
No new posts DO we have alternate syntax for IFTHEN? Compuware & Other Tools 8
Search our Forums:

Back to Top