Retrive Perticular Record from IMS DB

creator.abhishek · New User Joined: 07 May 2006 Posts: 32 Location: Pune

Hi all,

I phased one problem.. want to share with you all..
Suppose there are two segments only in database. Child B has three records
B1, B2, B3 then how can i get only B3 by single Call only..

I am thinking it should be by using command code L, which is for last occurrence, Not sure...

If there is three field only.. and want only third one in single call statement then..

pingte · Active User Joined: 03 Dec 2005 Posts: 120 Location: india

probably you can use a qualified SSA to retreive a particular record.

enrico-sorichetti · Posted: Thu Apr 26, 2007 1:37 pm

Did You read the manual

What does the manual say ??

I guess we should feel honored for being trusted more than the official docs :-)

Just remember to define in Your DBD both a forward and backward pointer
otherwise all the calls accessing the last occurrence of a segment will have to follow the forward chain ( bad for performance )

rameshfoa · New User Joined: 05 Apr 2007 Posts: 27 Location: chennai

Yes u are rite...u can retrieve last segment record using command code 'L' and another question...do u want to retrieve third field only???...that is not possible....through IMS u can retrieve only the segment records not individual fields..

guptae · Posted: Fri Apr 27, 2007 1:36 pm

Hi Abhishek,

You can retrieve last segment by using L command code But u can't retrieve third field only because in IMS smallest block of information which u can retrieve is SEGMENT only.