Deleting WebDocs Event Monitor Records with Blank To Email Addresses

 

To delete bad event monitor records that have no To email address:

1. Sign on to the iSeries with a user ID that has security-officer authority. 
2. Add RJSIMAGE to library list:

   ADDLIBLE RJSIMAGE

3. Run the following command, making sure to use all single quotes:

   DOCSQL SQLSTM('delete from rjsimage/docevent where eto = '' ''')