Multiple-Segment Index



IBM's hierarchical database management system with a Database Manager (IMS DB) and a Transaction Manager(IMS DC)

Multiple-Segment Index

Postby Dave McCulloch » Sat May 02, 2009 2:14 am

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).
Dave McCulloch
 
Posts: 1
Joined: Sat May 02, 2009 2:08 am
Has thanked: 0 time
Been thanked: 0 time

Re: Multiple-Segment Index

Postby marun » Sat Jul 11, 2009 2:18 pm

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? :?
marun
 
Posts: 8
Joined: Fri Jun 20, 2008 9:59 am
Has thanked: 0 time
Been thanked: 0 time

Re: Multiple-Segment Index

Postby dick scherrer » Mon Jul 13, 2009 1:11 am

Hello,

Suggest you talk with your ims dba.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to IMS DB/DC

 


  • Related topics
    Replies
    Views
    Last post