View previous topic :: View next topic |
Author |
Message |
ramu_mohan21 Beginner
Joined: 29 Jun 2004 Posts: 106 Topics: 41 Location: Bangalore, INDIA
|
Posted: Tue Oct 07, 2008 4:38 pm Post subject: Accessing Child segment with Specified Critieria |
|
|
Hi Board,
I have a small question. In our system there are 2 levels of database is present. Each parent occurrence having multiple child occurence. In one of the child occurence, one of the field having the value 'ABC'. 'ABC' would be present in only in one child occurrence.
My requirement is to read the parent segment occurrence and read the child occurrence which is having 'ABC' and combine the parent + child segment data and write a report. Like that I need to process the entire database.
Can you anybody suggest me to provide an efficient solution for this problem? _________________ Best Regards,
----------------
Rammohan Pabba
Software Engineer |
|
Back to top |
|
|
rk_pulikonda Beginner
Joined: 27 May 2003 Posts: 22 Topics: 2 Location: India
|
Posted: Tue Oct 07, 2008 9:51 pm Post subject: |
|
|
Give a search on path call (Command code D) in this forum.
Hope you will get answer... _________________ Thanks
-Ram |
|
Back to top |
|
|
ramu_mohan21 Beginner
Joined: 29 Jun 2004 Posts: 106 Topics: 41 Location: Bangalore, INDIA
|
Posted: Wed Oct 08, 2008 3:23 am Post subject: |
|
|
Hi,
I have another question in the above processing. I don't have a key for parent segment. I need to process all the parent occurrences. But I have a key value i.e "ABC" for one of the child occurrence. Can I use GN call with Unqualified SSA for Parent and Qualified SSA for child using the command code "D" in the parent SSA by keeping sufficient IO-Area? _________________ Best Regards,
----------------
Rammohan Pabba
Software Engineer |
|
Back to top |
|
|
|
|