View previous topic :: View next topic
|
Author |
Message |
dbamain
New User
Joined: 28 Jun 2005 Posts: 12
|
|
|
|
hai,
how can we retrieve both parent(seg20a) and the child(seg20g) segment using ssa.I don't know how to give the call.please help me. |
|
Back to top |
|
|
somasundaran_k
Active User
Joined: 03 Jun 2003 Posts: 134
|
|
|
|
If it's a qualified SSA move the search/key values to the parent and child. Then issue a call ..Something like
CALL 'CBLTDLI' USING GU
YOUR PCB
YOUR SEGMENT
PARENT SSA
CHILD SSA.
hth
-Som |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
There can be more than one child for a parent....
First you give a GU Call for Parent, If you have values specified for the Key of Parent Segment.
If Parent Found for that key value....Give a GNP Call on Child Seg, until End Of DB.
Corrections are wel come.
Regards,
Priyesh. |
|
Back to top |
|
|
somasundaran_k
Active User
Joined: 03 Jun 2003 Posts: 134
|
|
|
|
Priyesh
Quote: |
I don't know how to give the call.please help
|
What I had given is a sample/general CALL statement. The process you mentioned is correct but the original poster didn't mention that the parent segment is the root segment. So this parent can be a child of another parent, then the process also has to be modified accordingly. In other terms it's all depend on the DB schema.
Regds
-Som |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
Hi Som,
Quote: |
So this parent can be a child of another parent, then the process also has to be modified accordingly |
You are correct....It depends exactly whats the structure.
I just replied considering it as Root segment as in notations it is mentioned like seg20a & seg20g. Well, it may be other way too.
I m agree with you.
Regards,
Priyesh. |
|
Back to top |
|
|
Suthagar
New User
Joined: 01 Jul 2005 Posts: 26 Location: Chennai
|
|
|
|
Hi,
I just wanted to know, can we able to pass a single qualified SSA to retrieve the both parent and the child by using the concatenated key(provided those are unique keys).
I think we can do that.
Please correct me if I am wrong/Right also.
Thanks,
Suthagar.S |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
Hi Suthagar,
I think We can.....Yes.
Regards,
Priyesh. |
|
Back to top |
|
|
|