RESIGNAL
From SQL PL Guide for DB2
RESIGNAL statement
The RESIGNAL statement is similar to the SIGNAL statement, but it can only be used inside a CONDITION HANDLER.
It can used to issue an error or a warning in a handler, or it can used to reissue the same condition that caused the handler to be invoked. Then, the original SQLSTATE and SQLCODE will be overidden.
Syntax:
RESIGNAL SQLSTATE [VALUE] <sqlstate> [SET MESSAGE_TEXT = <variable> or <diagnostic string constant>] or RESIGNAL <condition name> [SET MESSAGE_TEXT = <variable> or <diagnostic string constant>]
Example:
...comming soon...