Thread: is there somebody with access to db2?

Hello,

I am interesting about a CONTINUE HANDLER behave, please can you
check, and send a result of following function?

  CREATE FUNCTION REVERSE(INSTR VARCHAR(4000))    RETURNS INT    DETERMINISTIC NO EXTERNAL ACTION CONTAINS SQL    BEGIN
  DECLARE RES INT;    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION      SET RES = 10;    BEGIN      SIGNAL '33333';
SETRES = 30;    END;    RETURN RES;  END;
 

Thank you

Regards

Pavel Stehule