Alternate index

krbabu · New User Joined: 20 Feb 2004 Posts: 57

Hi,
I am declaring the alternate index in COBOl prog as
SELECT F1 ASSIGN TO ddname
ORGANIZATION IS INDEXED
RECORD KEY IS emp-no
ALTERNATE RECORD KEY IS emp-name.

my doubt is which dataset is used in JCL coorresponding ddname?Is it base cluster or alternate intex?

bluebird · Active User Joined: 03 Feb 2004 Posts: 127

if u use this pgm you'll have to code DDNAME on DDNAME statement itz should then be alternate index

krbabu · New User Joined: 20 Feb 2004 Posts: 57

i am checking the both the keys in cobol program. That means if i move the no to record key or else i move name to alter nate key. Depends on the moving statement corresponding cluster have to acccess, How can i code this .

bluebird · Active User Joined: 03 Feb 2004 Posts: 127

I think any alternate index change will propagate thru to base-cluster BASED on YOUR VSAM DEFINITION:

is this what u wanted to know ?

sivakanuri · New User Joined: 07 Jun 2004 Posts: 5 Location: hyderabad

i think the answers given above r not correct .
i think when u specify the alt-index in jcl u should use ths base cluster location and the path cluster location of the alt-index in the jcl.

//go.dd1 dd dsn=(base cluster)
//go.dd2 dd dsn=(path cluster)

bluebird · Active User Joined: 03 Feb 2004 Posts: 127

to access base cluster thru alternate index u only need to specify the PATH.

meaning changes will be propagated using the path dsname.
(u don't need to specify the base cluster)