Spool File Scan Utility

[JesseH]

We have hundreds of spool files that we need to scan to find a particular string. Is there any utility that can scan all the spool files in an outqueue for a string?

Thanks

 

[plevey]

I've never come across the utility you are looking for but CPYSPLF might do the trick. Create a simple CL program to do the following:
Use WRKOUTQ to print the contents of the OUTQ. Use CPYFSPLF to copy this spooled file to a database file F1. Use a loop to RCVF F1 and programatically get the contents of the OUTQ. Using the details so retrieved, repeat the CPYSPLF process to dump each SPLF to a database file F2. Use QUERY or SQL to scan F2 for the string. Hope this helps.