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.
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
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. . .
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.