This is regarding SQL stored procedures. The guide says this about handler
declaration in SQL procedures:
"handler declaration can specify a SQL-procedure-statement.
SQL-procedure-statement is a set of statements that execute when the
handler receives control."
But I don't understand how a 'set of statements' can be specified as a
SQL-procedure-statement when UDB does not allow nested compound
statements.
Also, any idea why I cannot use the following in SQL procedure:
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION GOTO ERROR_HANDLE;
The above line gives an error during CREATE PROCEDURE: SQL0104N - An
unexpected token GOTO was found; expected tokens may include SET.
Thanks.
Raquel.