Code:
Create procedure MK/prc_atest    (
INOUT IO_CODE CHAR(5) ,           
INOUT IO_MSG  CHAR(132) ,         
IN ADBACTION  CHAR(3 )            
                        )         
LANGUAGE SQL                      
SPECIFIC MK/prc_atest             
..
..

Begin 
DECLARE CONTINUE HANDLER FOR 2
SQLSTATE '23505';
(Wobei 23505 für den zu ersetzenden Code steht)
oder
Code:
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION 1
SET vsqlcode = SQLCODE;
lg Andreas