Hello DB2 Gurus,
I need a favour. How can I handle exceptions in DB2, I am very new to the db2. I know about exception handling. but dont know how I can do it in db2. I want to drop the primary key on a table. I dont want to fail the stored_proc if the primary key doesnt not exist.
Oracle code:
begin
alter table table_a drop primary key;
exception
when others then
----print something
end;
How can i do the same in db2. Please help.
Regards
G
I need a favour. How can I handle exceptions in DB2, I am very new to the db2. I know about exception handling. but dont know how I can do it in db2. I want to drop the primary key on a table. I dont want to fail the stored_proc if the primary key doesnt not exist.
Oracle code:
begin
alter table table_a drop primary key;
exception
when others then
----print something
end;
How can i do the same in db2. Please help.
Regards
G