Page 1 of 1
Using an existing alternate VSAM index in COBOL.
Posted: Wed Jun 01, 2016 2:14 pm
by Anup Apte
Hi,
We have a KSDS VSAM dataset. This is an existing dataset and had been in use for many years. I need to write a new program in which I want to use this file and the alternate index that is defined for this file. What is the way to view the definition of alternate index of this existing alternate index using CICS?
Re: Using an existing alternate VSAM index in COBOL.
Posted: Wed Jun 01, 2016 2:22 pm
by enrico-sorichetti
see here
http://www.redbooks.ibm.com/abstracts/s ... .html?Open
for the explanation of BASE Cluster, ALTERNATE Index, PATH
Re: Using an existing alternate VSAM index in COBOL.
Posted: Wed Jun 01, 2016 6:42 pm
by Robert Sample
What is the way to view the definition of alternate index of this existing alternate index using CICS?
You don't -- you use IDCAMS LISTCAT in a batch job to see the definition, just as you don't see the definition of the base cluster in CICS but rather in batch.
Re: Using an existing alternate VSAM index in COBOL.
Posted: Tue Jun 07, 2016 12:04 pm
by Anup Apte
Robert Sample wrote:What is the way to view the definition of alternate index of this existing alternate index using CICS?
You don't -- you use IDCAMS LISTCAT in a batch job to see the definition, just as you don't see the definition of the base cluster in CICS but rather in batch.
Thanks. I thought it's there somewhere defined in CICS resources.
Re: Using an existing alternate VSAM index in COBOL.
Posted: Tue Jun 07, 2016 12:13 pm
by Anup Apte
Doing some more research on this topic, I came to know that if we create a RDO definition and point it at the AIX, then we can access the file as if it were the base cluster throgh this definition. Is it the usual way of daoing this or it's just a user preference?
Re: Using an existing alternate VSAM index in COBOL.
Posted: Tue Jun 07, 2016 1:33 pm
by enrico-sorichetti
Looks like you are confusing AIX with PATH
if the ddname/definition points to the AIX then You will get the AIX data ( keys/pointers to the bas cluster )
if the ddname/definition points to the PATH then You will get the base cluster data
read again - if You ever did - the redbook I pointed to in order to understand the differences
Re: Using an existing alternate VSAM index in COBOL.
Posted: Wed Jun 08, 2016 2:29 pm
by Anup Apte
enrico-sorichetti wrote:Looks like you are confusing AIX with PATH
if the ddname/definition points to the AIX then You will get the AIX data ( keys/pointers to the bas cluster )
if the ddname/definition points to the PATH then You will get the base cluster data
read again - if You ever did - the redbook I pointed to in order to understand the differences
May be. I'll just go though them again to confirm.
Re: Using an existing alternate VSAM index in COBOL.
Posted: Wed Jun 08, 2016 9:28 pm
by enrico-sorichetti
[font=Tahoma, Arial, Helvetica, sans-serif]May be. I'll just go though them again to confirm.[/font]
may be what ?
