IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

retrieval of parent and child segment


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
dbamain

New User


Joined: 28 Jun 2005
Posts: 12

PostPosted: Wed Jun 29, 2005 3:48 pm
Reply with quote

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
View user's profile Send private message
somasundaran_k

Active User


Joined: 03 Jun 2003
Posts: 134

PostPosted: Thu Jun 30, 2005 2:47 am
Reply with quote

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
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Thu Jun 30, 2005 4:31 pm
Reply with quote

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
View user's profile Send private message
somasundaran_k

Active User


Joined: 03 Jun 2003
Posts: 134

PostPosted: Thu Jun 30, 2005 7:22 pm
Reply with quote

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
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Thu Jun 30, 2005 7:28 pm
Reply with quote

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
View user's profile Send private message
Suthagar

New User


Joined: 01 Jul 2005
Posts: 26
Location: Chennai

PostPosted: Fri Jul 01, 2005 12:00 pm
Reply with quote

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
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Fri Jul 01, 2005 3:48 pm
Reply with quote

Hi Suthagar,

I think We can.....Yes.

Regards,

Priyesh.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts How to: PK does not exist in several ... DB2 5
No new posts IMS SEGMENT READ ISSUE IMS DB/DC 0
No new posts Inserting records into the empty segm... IMS DB/DC 1
No new posts REORG to reduce segment size new DBD IMS DB/DC 2
No new posts How to find if segment is read in any... IMS DB/DC 12
Search our Forums:

Back to Top