Hi All
In oracle we define the pl/sql block as
begin
--sqls
exception
--exception handling
end
I.e. we use begin..end to help us handle the exceptions for particluar sql seperately.. Can begin ..end in DB2 used for similiar purpose? Is it advisable to multiple have begin ..end with declare handler.... in DB2.
Basically i want to handle insert exception for 2 insert stmts. seperately...
thanks and regards
vallabh
In oracle we define the pl/sql block as
begin
--sqls
exception
--exception handling
end
I.e. we use begin..end to help us handle the exceptions for particluar sql seperately.. Can begin ..end in DB2 used for similiar purpose? Is it advisable to multiple have begin ..end with declare handler.... in DB2.
Basically i want to handle insert exception for 2 insert stmts. seperately...
thanks and regards
vallabh