Re: Work with Spooled Files

Dave,


you can combine a couple of the DB2 for i Services to deliver a list of spoolfiles.



Select
E.CREATE_TIMESTAMP,
E.SPOOLED_FILE_NAME,
E.USER_NAME,
E.USER_DATA,
E.STATUS,
E.SIZE,
E.TOTAL_PAGES,
E.COPIES,
E.FORM_TYPE,
E.JOB_NAME,
E.DEVICE_TYPE,
E.OUTPUT_PRIORITY,
E.FILE_NUMBER,
E.SYSTEM
From
TABLE(QSYS2.OBJECT_STATISTICS('*ALL', 'LIB')) AS L
Cross Join
TABLE(QSYS2.OBJECT_STATISTICS(L.OBJNAME, 'OUTQ')) AS Q
Cross Join
TABLE(QSYS2.OUTPUT_QUEUE_ENTRIES(L.OBJNAME, Q.OBJNAME, '*NO')) AS E
Where
E.USER_NAME = 'QSECOFR'



Jim