hi

db2 8.2 in win.

I have this sp:
-------------------------------
create procedure()
language sql
begin atomic
declare ..... (my variables)
declare continue handler for sqlexeption, sqlwarning, not found
begin
set retcode = sqlexception;
end;
for v1 as
select ....
do
insert
GET DIAGNOSTIC EXCEPTION 1 SQLDESCRIP = MESSAGE_TEXT;
end for
end
-------------------------------


the problem is: SQLDESCRIP never return a value o description.
the questionis: any know how work this MESSAGE_TEXT???

TIA
abel-

You need to do it this way:

create procedure()
language sql
begin atomic
declare ..... (my variables)
declare continue handler for sqlexeption, sqlwarning, not found
begin
GET DIAGNOSTIC EXCEPTION 1 SQLDESCRIP = MESSAGE_TEXT;
set retcode = sqlexception;
end;
for v1 as
select ....
do
insert
end for
end
-------------------------------

The manual say that the GET DIAGNOSTIC needs to be in the condition handler.

HTH

Andy

Perfect!!!!!
this work fine!!!

very, very thanks.
Abel.