Hello,

We are having problems trying to drop a SP. When I try to drop it via
the java based CC, it all looks OK, but a refresh still shows it is
there. There is nothing in the error - log.

Could some one inform me the coorect SQL syntax on how to drop a
Stored Procedure please.

db2 v.8
aix 5.2

thanks
DT

It's "db2 drop procedure <procname>".

When you say it's 'still there' do you mean you're still picking up an
old class/library? Classes and libraries are cached until 'certain'
points in time. The only way to be sure of flushing all old classes/libs
is to recycle db2. You can look in the catalogs (sysibm.sysroutines) to
see if your stored proc is still in existance on the database.

DT wrote: