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...


Link to the DB2 Information Center: DB2 9.7 DB2 10.1 DB2 10.5