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.