45 pts.
 Operation sequence for member MSTITA not valid
big spool files generated. joblog generated the below error.
Cause . . . . . :   An update or delete was requested before a get for update
                                       for member MSTITA file MSTITA in library MM510LIB. Recovery  . . . :
                                       Either change the operation sequence in the program or delete the existing
                                       program and compile it again.  Then try the request again. Possible choices
                                       for replying to message . . . . . . . . . . . . . . . :   C -- The request
                                       is canceled. I -- Ignore the request and continue processing.
No problem in the compilation. Could you please help me on this


Software/Hardware used:
ASKED: July 30, 2011  9:06 AM
UPDATED: March 31, 2012  7:36 PM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

The message says what to do:

  • Either change the operation sequence in the program or delete the existing program and compile it again. Then try the request again.

Most likely, you have a UPDATE or a DELETE statement that is being executed without first executing a READ statement. Make sure that the logic reads a record before it tries to update or delete each record.

Tom

 110,135 pts.