Why does Detector display a -253 error code when the application displays a -302 error code

Products

• Detector for DB2 for z/OS

Issue/Introduction

Why does Detector for Db2 for z/OS (PDT) display a -253 error code when the application displays a -302 error code. 

Resolution

Detector displays the SQL Error that it finds in the Db2 control block. In this case, a -253 SQL error appeared in the control block,
therefore, Detector displayed it instead of a -302 error. It is possible that Db2 changed the SQLCODE from -253 to -302 during post SQL processing.