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

Status code of NI immaterial of ISRT or REPL call


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

New User


Joined: 08 Jul 2005
Posts: 31

PostPosted: Fri Mar 09, 2007 3:09 pm
Reply with quote

Hello,

Iam executing a program which reads records from a GSAM input file and then issues a GHU call to see if it exists in the database, if the status is blanks then it issues a REPL call and updates the record. Otherwise isert it by giving an ISRT call. The problem is everytime we execute for all inputs we're getting a status code of NI immaterial of ISRT or REPL call. is there a way to resolve this? how tough is to rebuild the sec index ??? need help pls.
Back to top
View user's profile Send private message
Suthagar

New User


Joined: 01 Jul 2005
Posts: 26
Location: Chennai

PostPosted: Tue Mar 13, 2007 7:38 pm
Reply with quote

Hello folk,

The retrun code NI will be coming for the below reasons.

"There is a duplicate segment in a unique secondary index. While IMS was inserting or replacing a source segment for a secondary index defined with a unique sequence field, the insertion of the secondary index segment was attempted but was unsuccessful because an index segment with the same key was found. One possible cause for a duplicate segment in the index is that the index DBD incorrectly specified a unique key value--secondary index only. A data management open error occurred when opening the index data set. ".

Hope the return code NI was not immaterial and also Hope the above reason helps your query.

Thanks,
Suthagar Shanmugam
Back to top
View user's profile Send private message
Sasi Kiran Patha
Warnings : 2

New User


Joined: 19 Nov 2006
Posts: 73
Location: Hyederabad

PostPosted: Mon Mar 19, 2007 12:28 pm
Reply with quote

Hi,

Please clarify if we can update a GSAM file contents.

As far as my reading, GSAM file can only be read or inserted.

Regards,
Sasi Patha.
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 run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts Job completes in JES, but the status ... IBM Tools 1
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts Error while running web tool kit REXX... CLIST & REXX 5
Search our Forums:

Back to Top