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.
RESIGNAL SQLSTATE [VALUE] <sqlstate> [SET MESSAGE_TEXT = <variable> or <diagnostic string constant>]
RESIGNAL <condition name> [SET MESSAGE_TEXT = <variable> or <diagnostic string constant>]
Link to the DB2 Information Center: DB2 9.7 DB2 10.1 DB2 10.5