Arvee,

At 10:39 11.09.2002 +0000, you wrote:

>I use WHEN statement to check SQLCODE but if seems not to work.
>When executed the SP, it omit all statements in the body to end.

how do you know this? We need more information. From what you've been
telling us so far the answer may be as simple as not having committed your
changes, but as we do not know how 'it doesn't work' we cannot tell you
what to fix.

Set