Q
Problem solve Get help with specific problems with your technologies, process and projects.

Why can't I drop procedures in OpsNav?

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.


This was last published in May 2002

Dig Deeper on Upgrading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close