Re: forced execution of ILE condition handler

On 06-Nov 08:18 -0800, Needles,Stephen J wrote:

I'm trying to force an error that will flow through the registered
ILE Condition Handler (CEEHDLR).

I've a Condition Handler that we wrote in-house to perform actions
to support error diagnosis and communicate errors that occur in our
application.

It responds well to CPF msgs and the like, but it ignores SQL
errors. I would like to cause the registered Condition Handler to be
invoked at will.

The SQL operates by return-code, SQLCODE and SQLSTATE, not escape messaging to diagnose a failure. A condition handler is not directly useful to deal with return-code based invocations; i.e. the code should instead review the return-code, to decide how to react.

I've tried using the QMHSNDPM API to send an escape message
expecting this to trigger the Condition Handler with no success.

The external message queue does not support having "escape or command messages" being sent to that message queue, and that is what the snipped code snippet seems to do, so I suppose the return code in the QMHSNDPM API should be reviewed.

If the use of that Send Program Message API is within the program that should be interrupted for the condition, try using '*' to send the error to itself, instead of '*EXT'.

<<SNIP>>