IBM Mainframe Forum

Question:
Is there any way for an index to include fields from two segments -- data fields from one segment and the key field from its (root) parent?

Details:
Imagine an IMS HIDAM database with two segments. Segment "A" is the root segment and segment "B" is its child. If segment "B" has data fields BF1, BF2 and its parent segment "A" has a key of AKEY, I need an index into segment "B" with a key of BF1, AKEY, BF2.

If possible, I would like to avoid replicating A's key into segment "B" (unless that data is automatically inserted and maintained by IMS).

Hi all,

Sorry for bumping this thread... I also have the same doubt.

I tried this quiet a while back and all i got is only a return code of 'GE'.

After trying for a long time, I just made a GU call followed by that a GN call to the child segment.

Can anyone please shed some light on this?

Hello,

Suggest you talk with your ims dba.