View previous topic :: View next topic
|
Author |
Message |
raghu cn
New User
Joined: 10 Dec 2007 Posts: 2 Location: Bangalore
|
|
|
|
Hi..
how do you map the alternate index in JCL? |
|
Back to top |
|
|
ousep143
New User
Joined: 06 Oct 2007 Posts: 32 Location: India
|
|
|
|
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
raghu cn wrote: |
Hi..
how do you map the alternate index in JCL? |
|
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
|
|