Hi all

I am migrating a huge oracle database to DB2. I have got many software which makes my work easy.

The only problem I am facing is that I could not get the DB2 equivalent of EXCEPTION HANDLING in DB2.

Any help on this topic will be appreciated.

regards
sw_flintstone

Go to the SQL Reference Volume 2, "Chapter 2. SQL Control Statements." Look at the following syntax elements and see if this is what you are looking for:

condition-declaration
return-codes-declaration
handler-declaration
etc