Your application may handle certain error conditions returned in VSAM. You can simulate this in an FBE by setting EXRET = P. This will result in return code = 08 being passed to your application program.
SET EXSQLCA TO ADDRESS OF SQLCA.
The
formatted SQL error message is written to the DD statement
VIDDMP in CICS and VIDDMPD
in a batch job. No data is returned to your application program when your exit sets EXRET = P. If CICS VT tracing is active, a return code of 0020 is shown in the trace point 8 record.
CICS VT builds the RPLFDBWD, which is translated by your application program into language specific return and reason codes. EXRET=P will result in return code 08 and reason code DB in your application program.