MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Insert Failing

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> IMS
View previous topic :: View next topic  
Author Message
coolman
Intermediate


Joined: 03 Jan 2003
Posts: 283
Topics: 27
Location: US

PostPosted: Mon Apr 26, 2004 7:56 pm    Post subject: Insert Failing Reply with quote

Folks,

This is my db layout.
1) I have a root which has got a key from bytes 3 for a length of 10.
2) Now this root segment has got 1 child say child1 without any key.
3) Now child1 has got two children childx and childy which are logical twins.
childx has got a key(SSN) from byte 14 for a length of 10. Childy has not got a sequence field which is not unique but can occur multiple times
Example : (NAME,SEQ,M)

Now, when I try to access Root and Child1, I'm perfectly fine (using GN/GU/GNP calls). At present Childx and Childy are completely empty.

When I try to issue an ISRT call to insert into ChildX, I'm getting a GE status code. Looked at the manual and this is what I found:

For an ISRT call, DL/I cannot find one of the parents of the segment being inserted.

>> Well, Iam able to access the parent segment successfully.

For an ISRT call, DL/I was requested to insert a root segment outside of
the accessible range determined by a SETR statement
>> I have no idea on this.

Is there anything that I'm missing.
or, Can be there be a PSB constraint which is not allowing me to ISRT.

Please advise.

Cheers,
Coolman.
________
Toyota Y engine history


Last edited by coolman on Sat Feb 05, 2011 1:35 am; edited 1 time in total
Back to top
View user's profile Send private message
Bithead
Advanced


Joined: 03 Jan 2003
Posts: 550
Topics: 23
Location: Michigan, USA

PostPosted: Tue Apr 27, 2004 8:35 am    Post subject: Reply with quote

It is probably because of how you SSA is constructed. Make sure that you are including the root/child1 SSAs in your ISRT. Alternately, try doing a GHU on child1 then ISRT on childx.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> IMS All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group