var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Delete many stored procedures
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'
select 'drop procedure '||'EXAMPLE.'||procname||' ;' from syscat.procedures where procschema='EXAMPLE'
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.
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