Skip to main content
S
sdamery1-Visitor
1-Visitor
January 21, 2015
Solved

Unable to Create, change or delete an SQL View

  • January 21, 2015
  • 1 reply
  • 3123 views

Hello,

Here is another weird thing, I was creating a view outside implementer and it placed the view in the production library where the tables are. When I tried to promote a table change it picked up the view without source and errored out my promotion. I deleted the view and then was able to promote my table change.

Now I am ready to use the new view but when I go to create the object in IMPLEMENTER it says it is already there, yet when I try and check it out it says it doesnt exist. So now I can create change or delete the SQL VIEW?

Seems there is some control file holding on to the existence of the object but since I deleted it manually it needs updated or deleted ...something.

ANY HELP is appreciated.

Best answer by DawnBlohm

Hi Scott,

If you go into #11-Work With Objects, do you see the view listed?

If there is an entry in Work With Objects and the object truly does not exist, you can use the ICHGREP command to *DLT the reference to the object in Implementer.

Let me know if this does not resolve the problem.

Dawn

1 reply

D
DawnBlohm12-AmethystAnswer
12-Amethyst
February 3, 2015

Hi Scott,

If you go into #11-Work With Objects, do you see the view listed?

If there is an entry in Work With Objects and the object truly does not exist, you can use the ICHGREP command to *DLT the reference to the object in Implementer.

Let me know if this does not resolve the problem.

Dawn

S
sdamery1-VisitorAuthor
1-Visitor
February 3, 2015

Hello Dawn, that worked perfectly. However I have been informed that we still have some similar objects/records that are in developer libraries and NOT environments.

We tried that command to clean up those and it said it was NOT an environment. Is there a command to clean up records without source or objects? ...or even a rebuild...although that might be a last resort.

D
DawnBlohm12-Amethyst
12-Amethyst
February 3, 2015

the IDLTLIBREF command works for objects that Implementer thinks are in developer libraries, when they actually have been deleted outside Implementer.

Terms & ConditionsCookie settingsAccessibility statement