Alternate Index of a ESDS file

subdalal · New User Joined: 27 Sep 2010 Posts: 21 Location: Boudh

We can create an Alternate Index of a ESDS file.
But for creating an Alternate Index we require a Primary key and an Alternate key.

But ESDS file does not have a Key.

Please guide me I am lost..

PeterHolland · Posted: Mon Feb 04, 2013 12:08 pm

The AIX key is just a field in the ESDS base cluster and has nothing to do
if the base is keyed.

Bill Woodger · Posted: Mon Feb 04, 2013 12:48 pm

Create a small KSDS. Create a small ESDS. Same size records on both, same data in both. Build an Alternate Index on each. "PRINT" the Alternate Indexes and look at the output. Reflect upon what you notice.

enrico-sorichetti · Posted: Mon Feb 04, 2013 1:22 pm

see here for my TESTED snippets which show how and what
www.ibmmainframes.com/viewtopic.php?t=29269&highlight=esds+aix+path

Bill Woodger · Posted: Mon Feb 04, 2013 2:46 pm

Well, enrico, that's comprehensive :-)

subdalal,

Just make sure you go through it all and understand it. If you don't understand, ask.

subdalal · New User Joined: 27 Sep 2010 Posts: 21 Location: Boudh

Thanks..@Bill, @Enrico, @Peter. I got it.