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]%'