MVSFORUMS.com

Elenita · Posted: Tue Nov 30, 2004 2:29 pm Post subject: VSAM Alternate Index

Is it possible to create an alternate index on a VSAM file with a key that is made up of non-contiguous fields?
_________________
Elenita

kolusu · Posted: Tue Nov 30, 2004 6:00 pm Post subject:

Elenita,

You CANNOT create an alternate index with non-contigous fields. one alternative is to you can code a program which will take the keys and put them together in one string and put that string somewhere(usually at the end) on the record.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Elenita · Posted: Wed Dec 01, 2004 8:16 am Post subject: VSAM Alternate Index

Thanks -- I was afraid of that, but may be able to use your suggestion.

Elenita
_________________
Elenita

warp5 · Posted: Thu Dec 02, 2004 2:05 am Post subject:

Are you sure you need to do this? The overhead might be high. What are your requirements?

Elenita · Posted: Thu Dec 02, 2004 8:06 am Post subject:

Trying to access a VSAM file based on two non-contiguous fields.
_________________
Elenita

warp5 · Posted: Fri Dec 03, 2004 1:54 am Post subject:

Why? How often? Random? Sequential? Terse answers, terse questions. Your answer did not supply any new information of value.