Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

begin..end block

Status
Not open for further replies.

val02

Programmer
Jul 29, 2002
5
IN
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top