Home > database >  DB2 delete a stored procedure
DB2 delete a stored procedure

Time:10-05

1 question: a stored procedure do not have this problem (the other stored procedures) don't know why I deleted after, never really deleted
2, phenomenon: in toad for db2 tool to delete statements can be executed repeatedly drop procedure. PRAJNA PRO_IMPORTQUREY_INFO
And DROP SPECIFIC PROCEDURE PRAJNA. SQL170912100212600;
But with SQL queries after deleting the select * from syscat.tables PROCEDURES where procname='PRO_IMPORTQUREY_INFO' also can check the data,
The stored procedure at present there are problems, should be invalid with tools Aler procedure in modified complains, lead to can't rebuild and modify the stored procedure, need to change the name of the stored procedure again
3, always can't find the reason, online help you a great god, and what method can delete the stored procedure, thank you


  •  Tags:  
  • DB2
  • Related