I have a question about databases created by SQL create collection. I created collection TEST and some programmers created a few storage procedures under OpsNav. I dropped these procedures under the SQL session (green screen). After this I dropped the whole collection, and once again created the collection with this same name. I'm wondering, in the new collection -- under OpsNav -- I found the storages procedures created earlier, and I can't remove any.
It appears to be a glitch in OpsNav. I tested the same scenario and the procedure shows in OpsNav, but I can't delete it, nor can I execute it. I would assume that the procedure isn't really there and that OpsNav just didn't refresh correctly.
MORE INFORMATION ON THIS TOPIC
The Best Web Links: tips, tutorials and more.
Ask your OS/400 questions--or help out your peers by answering them--in our live OS/400 discussion forums.
OS/400 Discussion Forum: Post your questions, and get answers from other iSeries users as well as search400 experts.
Search400's targeted search engine: Get relevant information on V5R1.
Dig Deeper on Upgrading
Related Q&A from John Brandt
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.