Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Status code of NI immaterial of ISRT or REPL call

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
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    Post subject: Status code of NI immaterial of ISRT or REPL call
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    Post subject: Re: Status code of NI immaterial of ISRT or REPL call
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    Post subject: Re: Status code of NI immaterial of ISRT or REPL call
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    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 0 Thu Jan 12, 2017 12:02 pm
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
This topic is locked: you cannot edit posts or make replies. session stuck in TPX with status ACL amitc23 CA Products 1 Tue Dec 13, 2016 12:53 pm
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts What is the code in CLIST to enable t... jackzhang75 CLIST & REXX 1 Fri Dec 02, 2016 3:02 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us