EXIT HANDLER FOR SQLEXCEPTION

[oana12]

Hi,
I have this procedure
CREATE PROCEDURE t (
IN PUSERID INTEGER,
IN PDATE TIMESTAMP,
, OUT PSQLCODE INTEGER)

RESULT SETS 0 LANGUAGE SQL
BEGIN NOT ATOMIC
DECLARE SQLCODE INT;
DECLARE CONTINUE HANDLER FOR NOT FOUND
SET AT_END = 1;
DECLARE EXIT HANDLER FOR SQLEXCEPTION
SET PSQLCODE = SQLCODE;
SET PSQLCODE = 0;
update b
set value=bvalue
where userid=puserid
and date=pdate;
commit;
end;

When I execute this procedure it is failling with SQLCODE=0.
If I execute only the update statement it is ok. Why in procedure is not executed and is finished with SQLCODE exit number?
In my table I have 2.500.000 records.

Thanks.

 

[sathyarams]

It is very difficult to guess ..

Try using the exception handler example you find in

http://www.db2click.com/scripts.htm

...

This should help you to easily identify the root cause of error

Cheers
Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp