| View previous topic :: View next topic |
| Author |
Message |
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
 Posted: Tue Jan 31, 2006 10:27 am Post subject: Alternate index on ESDS VSAM cluster. |
 |
|
Hi,
Is it possible to have an alternate index on a ESDS cluster. One interviewer tells me that it is possible to access records randomly if you have alternate index on an ESDS VSAM cluster.  
Please throw some light on this topic.
Thanks in advance.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12383
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
| Posted: Wed Feb 01, 2006 9:44 am Post subject: |
|
|
The link was very helpful. I got the answer that the alternate index of an ESDS can be used only with CICS-COBOL (online) programs.........
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
|
bablack
Beginner
Joined: 04 Dec 2002
Posts: 71
Topics: 0
Location: Little Falls, NJ
|
| Posted: Wed Feb 01, 2006 5:01 pm Post subject: |
|
|
I don't know where in that manual you got the impression that only a CICS program can use an AIX on an ESDS, not true.
An AIX can be used by any program, in any environment, to access a ESDS randomly (directly) by a key.
_________________
Bruce A. Black
Senior Software Developer
Innovation Data Processing |
|
| Back to top |
|
|
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
| Posted: Thu Feb 02, 2006 8:16 am Post subject: |
|
|
Hi Black,
Can you please provide me a small COBOL batch program where we can access an alternate index of ESDS to randomly process the records.
This will be very useful.
Thanks for your time.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12383
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
bablack
Beginner
Joined: 04 Dec 2002
Posts: 71
Topics: 0
Location: Little Falls, NJ
|
| Posted: Thu Feb 02, 2006 8:54 am Post subject: |
|
|
| mf_user wrote: |
Can you please provide me a small COBOL batch program where we can access an alternate index of ESDS to randomly process the records.
|
Sorry, I am not a COBOL programmer, but accessing a ESDS by key through an alternate index is exactly the same as accessing a KSDS by key, as far as the program is concerned.
To access by key, you have to define and build the AIX, and then define a PATH which connects the AIX to the base cluster. In the JCL for the step, you specify the name of the path on the DD statement instead of the name of the cluster, e.g.,
//FILE1 DD DSN=pathname,DISP=SHR
everything else is automatic.
_________________
Bruce A. Black
Senior Software Developer
Innovation Data Processing |
|
| Back to top |
|
|
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
| Posted: Fri Feb 03, 2006 3:34 am Post subject: |
|
|
Ok Mr. Black. I will try to work it out.
Thanks for the quick reply.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
