While trying to delete an object the other day, I received the ever-helpful “Object exists in an active project” error. Since our developers have created a few hundred OMW projects, I didn’t want to go searching through every project to see where this object was. I realize that I should have been able to look at the News/Status tab and get the info, but it didn’t seem to be working.
Anyway, I used the following SQL to get the info (iSeries syntax):
select * from sy811/f98222 where POOMWOBJID like '[object_name]%'