Hi All,

Plz tell the way to delete 400 stored procedures at a time

Is is a correct way to do:

db2 " drop procedures select * from syscat.procedures where procschema = 'EXAMPLE' "
I just want to remove 400 SP with procschema = 'EXAMPLE'

Thx much

Kevin

select 'drop procedure '||'EXAMPLE.'||procname||' ;' from syscat.procedures where procschema='EXAMPLE'

--Rahul Singh

Kevin,
Rahul's post will only generate a script that you will have to run. You can use the Control Center to drop all of the stored procedures in one opration.

Andy

if you are using DB2 V9 for LUW
there is a new procedure SYSPROC.ADMIN_DROP_SCHEMA through which you can drop **all** objects in a schema

--Rahul Singh