Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Retrive Perticular Record from IMS DB

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
creator.abhishek

New User


Joined: 07 May 2006
Posts: 32
Location: Pune

PostPosted: Thu Apr 26, 2007 11:38 am    Post subject: Retrive Perticular Record from IMS DB
Reply with quote

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..
Back to top
View user's profile Send private message

pingte

Active User


Joined: 03 Dec 2005
Posts: 120
Location: india

PostPosted: Thu Apr 26, 2007 1:30 pm    Post subject: Re: Retrive Perticular Record
Reply with quote

probably you can use a qualified SSA to retreive a particular record.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Thu Apr 26, 2007 1:37 pm    Post subject: Re: Retrive Perticular Record
Reply with quote

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 )
Back to top
View user's profile Send private message
rameshfoa

New User


Joined: 05 Apr 2007
Posts: 27
Location: chennai

PostPosted: Fri Apr 27, 2007 10:59 am    Post subject:
Reply with quote

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..
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Fri Apr 27, 2007 1:36 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Repeat part of record multiple times Learncoholic DFSORT/ICETOOL 4 Tue Aug 29, 2017 11:33 am
No new posts Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 6 Wed Jul 26, 2017 7:35 pm
No new posts Need to write record of PS File in ex... Chandan1993 JCL & VSAM 1 Wed Jun 07, 2017 1:35 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us