PL39544: SQLCODE-501 AND -507 IN DB2 V2.1 AND V1.3 MESSAGE AND CODE MANUALS STATE SQLCODE803 WILL CLOSE THE CURSOR. BUT IT DOESN'T.

APAR status

• Closed as documentation error.

Error description

• SQLCODE-501 AND -507 IN DB2 V2.1 AND V1.3 MESSAGES AND CODES
  STATE THAT SQLCODE-803 WILL FORCE THE CURSOR TO CLOSE. SO,
  USER WON'T BE ABLE TO FETCH, CLOSE, UPDATE OR DELETE ON THE
  CURSOR AFTER SQLCODE-803 IS ISSUED. HOWEVER, THE USER COULD
  ACTUALLY DO FETCH, CLOSE, UPDATE OR DELETE ON THE CURSOR AFTER
  SQLCODE803 IS RECEIVED.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL                                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  SQLCODE501 AND SQLCODE507 IN THE DB2 MESSAGES AND CODES
  SC2641133 FOR V1R3 AND SC2643790 FOR V2R1 LIST SQLCODE803 AS
  ONE OF THE SQL CODES THAT WILL FORCE THE CURSOR TO CLOSE.
  HOWEVER, THIS IS NOT CORRECT.
  

Problem conclusion

• A PUBLICATION CHANGE WILL BE MADE TO THE DB2 MESSAGES AND CODES
  FOR SQLCODE501 AND SQLCODE507 TO REMOVE SQLCODE803 FROM THE
  LIST OF SQL CODES THAT WILL FORCE THE CURSOR TO CLOSE AS
  FOLLOWS:
  .
     -501 ...
     PROGRAMMER RESPONSE: ....
   | ... SQL CODES -404, -652, -679, -901, -904, -909, -910,
     -911, AND -913 WILL FORCE THE CURSOR TO CLOSE.
  .
     -507 ...
     PROGRAMMER RESPONSE: ...
   | ... SQL CODES -404, -652, -679, -901, -904, -909, -910,
     -911, AND -913 WILL FORCE THE CURSOR TO CLOSE.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels