OMW Cleanup

When installing ESUs, an OMW project is created. If you have installed a lot of ESUs those projects can make it very annoying when trying to find other legitimate projects that you have access to. Yes, you can filter the OMW Project display, but I kinda find that annoying too. Anyway, I created a very simple SQL that I run once in a while to clean up my OMW:

DELETE FROM sy811/f98221
WHERE PUOMWUSER ='userid'
AND PUOMWPRJID LIKE 'JJ%'

Of course the syntax will need to be adjusted if using a database other than an IBM iSeries.

Deleting User Overrides

Once in a while my power-user wants to delete some User Overrides because they created some that they want everyone to use. Well, the UO app usually works pretty well, until your get some can not be deleted with the normal process. Here is the process that I go through:

1. Open a “Fat Client” in the environment in which want to delete the UO
2. Fastpath to UO
3. Use the QBE to find the UOs that you would like to delete
4. Highlight them and click delete
5. NOTE: If some of them do not delete and give you an error like “The object is in an open project”:
* Run a SQL statement similar to the following from the green screen to select the records desired and then delete them:

SELECT * FROM copy811/f98950 WHERE UOUSER <> '*PUBLIC' and
UOOBNM='Pxxxx' and UOFMNM='WxxxxA' and UOVERS='XJDE0016'