Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to map the alternative index in JCL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
raghu cn

New User


Joined: 10 Dec 2007
Posts: 2
Location: Bangalore

PostPosted: Tue Dec 11, 2007 4:59 pm    Post subject: How to map the alternative index in JCL
Reply with quote

Hi..
how do you map the alternate index in JCL?
Back to top
View user's profile Send private message

ousep143

New User


Joined: 06 Oct 2007
Posts: 32
Location: India

PostPosted: Tue Dec 11, 2007 5:55 pm    Post subject: Re: alternate index
Reply with quote

Hi Raghu,

Try this one.I think it is helpful for you.

//SYSIN DD *
PATHMAP BASENAME='CLUSTER NAME',
PATHNAME='PATH NAME'
PATHKEYS='ALTERNATIVE KEY'
/*

Regards
icon_biggrin.gif





raghu cn wrote:
Hi..
how do you map the alternate index in JCL?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Tue Dec 11, 2007 6:06 pm    Post subject: Reply to: alternate index
Reply with quote

Quote:
//SYSIN DD *
PATHMAP BASENAME='CLUSTER NAME',
PATHNAME='PATH NAME'
PATHKEYS='ALTERNATIVE KEY'
/*


To what utility do those control statement refer ???
Not certainly to IDCAMS

When giving suggestions make sure You understand the environment
of the O/P, and try to imagine ( when a question is badly posed )
what the O/P reallly means...

in this case ( MVS environment ) the O/P almost certainly refers to an
ALTERNATE INDEX hierarchy for VSAM CLUSTERS...

The overall structure in such case is :

BASE CLUSTER
- the original dataset

ALTERNATE INDEX
- an index built on the base cluster, there can be as many as needed

Note: an alternate index is just a cluster itself, and can be processed
on it' s own without accessing the base cluster,
the data read might, and usually does, not have any meaning

PATH
- the entity that relates the alternate index and the base cluster
( the PATH_NAME can be the dsname of a DD statement )

Given a reasonably written program the same can read sequentially
both a bsase cluster and a path by simply changing
the dsname on the dd statement,
and the output will be ordered according to the primary or the
alternate key
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Confusion b/w index and subscript Deepak kumar25 Mainframe Interview Questions 7 Thu Aug 31, 2017 6:50 am
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us