IBM MAINFRAME HELP & SUPPORT FORUMS

ug123 · Joined: 01 Mar 2007 Posts: 34 Location: Chennai

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.

Sandy Zimmer · Joined: 13 Jun 2007 Posts: 438 Location: Wilmington, DE

sambasivarao · Joined: 10 Jul 2006 Posts: 37 Location: Bangalore

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.

Sandy Zimmer · Joined: 13 Jun 2007 Posts: 438 Location: Wilmington, DE

No - you cannot do it with command codes.

dick scherrer · Joined: 23 Nov 2006 Posts: 8733 Location: 221 B Baker St

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.

Anuj D. · Joined: 22 Apr 2006 Posts: 2229 Location: Phoenix, AZ

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... :D