Lennart wrote:
RAISE_ERROR ('77000', 'TOTAL_ERROR_CNT MAX_THRESHOLD')
RAISE_ERROR() is the choice to raise an exception _within_ an SQL statement.
Commonly it's used as part of COALESCE or CASE-expression.
Within SQL PL the SIGNAL statement performs the same function.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab