Alternate index for ESDS in batch mode.

mf_user · Active User Joined: 05 Jan 2006 Posts: 76

Hi,

Is it possible to create an alternate index on an ESDS VSAM cluster? An interviewer says that we can create alternate index on ESDS so that we can access the ESDS file randomly in a batch COBOL program !!

Please help me.

Thanks in advance.

vikasc4 · New User Joined: 11 Dec 2005 Posts: 36

hi,

Yes it is very much possible to create the alternate index on ESDS.
you can create the Alternate index of ESDS same as in the case of KSDS.

regards
Vikas

senthils · Posted: Wed Feb 01, 2006 3:37 pm Post subject:

yes vikas we can create an AIX for an ESDS but I dont think it is possible to access the file via AIX in batch mode. In CICS its possible.

vikasc4 · New User Joined: 11 Dec 2005 Posts: 36

No Santhils, you can use Alternate index in batch mode also. Only in jcl you have to give the path of the Alternate index.

senthils · Posted: Wed Feb 01, 2006 5:29 pm Post subject:

Thats new for me vikas, but I have some doubts regarding this.

1. How do we code the SELECT clause in pgm(ORGANIZATION, ACCESS MODE ETC.)?
2. How do we access the records randomly? Do we have to pass the RBA as the key or something else?

Please clarify these doubts vikas.

vikasc4 · New User Joined: 11 Dec 2005 Posts: 36

Hi Senthils,

You can use Alternate index in batch mode but for that you must have a assembler program which relate the RBA of records with the alternate key.This assembler program comes with the installation and check out with your Administer that your installation have this program or not.

You are right that you can not use Alternate index directly in batch program but can be used in CICS region.

I am trying to find out other detail about using alternate index for ESDS and will get back to you if find something.

CORRECT ME IF I AM WRONG

REGARDS
VIKAS

senthils · Posted: Thu Feb 02, 2006 12:10 pm Post subject:

OK vikas

richie_techin · New User Joined: 21 Jan 2006 Posts: 17 Location: india

u can create alternate index in ESDS only in online transaction.