Re: Work with Spooled Files

After all these years even I learned something new today :-)

When did that capability become available ?

Regards,


Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com
------------------------------

message: 5
date: Wed, 28 Sep 2016 18:43:12 +0000
from: Jim It <jim_it@xxxxxxxxxxx>
subject: 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