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
 
Is there any possible way to retrieve all the child segments

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

New User


Joined: 01 Mar 2007
Posts: 39
Location: Chennai

PostPosted: Thu Aug 14, 2008 5:30 pm    Post subject: Is there any possible way to retrieve all the child segments
Reply with quote

Is there any possible way to retrieve all the child segments in single ims db call

The requirement is I have one root segment and 3 types of child segments under one root segment. Each child is having exactly 3 occurrences.
Normally if we want to retrieve all these occurrences we should use 10 db calls. Is there any possible way to reduce the calls.

Or can we have one db call to retrieve all the occurences of each child segment. Our ultimate aim is to reduce db calls.

Could anyone please let me know is this possible or not.
Back to top
View user's profile Send private message

Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Thu Aug 14, 2008 5:42 pm    Post subject:
Reply with quote

No.
Back to top
View user's profile Send private message
sambasivarao

New User


Joined: 10 Jul 2006
Posts: 47
Location: Bangalore

PostPosted: Fri Aug 15, 2008 7:47 pm    Post subject:
Reply with quote

Hi,

I think it is possible by using Command codes we can do.

The major pupose of Command codes is to reduce the no.of calls and improve the performance.

Thanks and Regards,
Sambasiva.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Fri Aug 15, 2008 8:07 pm    Post subject:
Reply with quote

No - you cannot do it with command codes.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Aug 15, 2008 8:48 pm    Post subject:
Reply with quote

Hello,

Quote:
The major pupose of Command codes is to reduce the no.of calls and improve the performance.
Footballs do not have feathers.

Like your statement, mine is also basically true though neither has anything to do with the original question. . .

Quote:
I think it is possible by using Command codes we can do.
If you want to post a reply such as this, you need to actually test the solution on your system and post the tested result here. Untested suggestions only add clutter and are often misleading to others who read the topic later.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Aug 18, 2008 11:36 am    Post subject:
Reply with quote

dick scherrer wrote:
Quote:
The major pupose of Command codes is to reduce the no.of calls and improve the performance.
Footballs do not have feathers.
I'm loving it... icon_biggrin.gif
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 Need to retrieve Julian_date Suganya87 DB2 4 Wed Aug 17, 2016 7:27 pm
No new posts How to define PCB for paired segments ashok_uddaraju IMS DB/DC 4 Tue Jun 14, 2016 11:40 pm
No new posts Retrieve current year or month using ... vnktrrd DFSORT/ICETOOL 15 Tue Mar 15, 2016 4:14 pm
No new posts Summing up child-values in self-refer... Auryn DB2 1 Sun Feb 14, 2016 6:02 pm
No new posts retrieve line commands from the data ... Pedro TSO/ISPF 6 Sat Oct 17, 2015 5:41 am

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