HIi all,
Trying to execute the following code within a procedure:

DECLARE CONTINUE HANDLER FOR SQLSTATE 'WW033' GOTO create_batch;

.....some code....

create_batch:
.....final code ...


Which gives me an error saying that GOTO is not allowed here. Can anyone
tell me what I am doing wrong. I've looked through the references and some
books and I can't see why it won't accept this.

cio
Derek.

"Derek Clarkson" <dclarkson (AT) waterwerks (DOT) com.au> wrote

When you create a HANDLER, you must specify the body of the handler
immediately. You can't branch to an arbitrary piece of code. If you want
this code to be executed both in the success and failure cases (as I have
assumed), you need to specify it twice.

CREATE PROCEDURE SOME_ROUTINE
LANGUAGE SQL
BEGIN

DECLARE CONTINUE HANDLER FOR SQLSTATE 'WW033'
BEGIN
.... final code ...
END

.... some code ...
.... final code ...

END

--
Matt Emmerton
DB2 OLTP Performance
IBM Toronto Lab