Cannot Drop Stored Procedures 
Author Message
 Cannot Drop Stored Procedures
I've executed "DROP PROCEDURE procedurename" and my procedures no longer
appear in the Stored Procedures list of the Control Center but I can see
records for them still exist using the SYSProcedures view.  And they show up
in other DB2 Tools (like DB2 Dev Center).  What gives?


Mon, 18 Jul 2005 10:00:20 GMT
 Cannot Drop Stored Procedures

Ok, I figured it out.  From where-ever you can see the SPs right click on
them and checkout their SPECIFIC ID then execute the following command to
drop them...

DROP SPECIFIC PROCEDURE <Insert Your Schema Here>.<Insert Your Specific ID
Here>;
COMMIT;

Example:
DROP SPECIFIC PROCEDURE APP.SQL030128145417745;
COMMIT;


Quote:
> I've executed "DROP PROCEDURE procedurename" and my procedures no longer
> appear in the Stored Procedures list of the Control Center but I can see
> records for them still exist using the SYSProcedures view.  And they show
up
> in other DB2 Tools (like DB2 Dev Center).  What gives?



Mon, 18 Jul 2005 10:11:31 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. cannot drop stored procedure because it was published for replication

2. Cannot drop stored procedure because it is currently in use

3. Cannot drop stored procedure

4. Cannot drop a stored procedure

5. Cannot drop the procedure ...

6. Cannot drop a procedure

7. cannot drop the procedure

8. Drop table passing tablename in Stored procedure.

9. Dropping a recordset during a stored procedure

10. do we need to explicity drop temp tables in stored procedures

11. SQL Server 2000/SQLCommandBuilder Dropping Scale on Stored Procedure Update

12. Drop index between databases within Stored Procedure


 
Powered by phpBB® Forum Software