Spool Services

These views and functions provide information about spooled files.

DELETE_OLD_SPOOLED_FILES procedure
The DELETE_OLD_SPOOLED_FILES procedure deletes spooled files according to filtering criteria. It can optionally return a preview of the files that meet the filtering criteria without performing the delete.
GENERATE_PDF scalar function
The GENERATE_PDF scalar function generates a PDF file in the integrated file system containing the content of a spooled file.
OUTPUT_QUEUE_ENTRIES table function
The OUTPUT_QUEUE_ENTRIES table function returns one row for each spooled file in an output queue.
OUTPUT_QUEUE_ENTRIES view
The OUTPUT_QUEUE_ENTRIES view returns one row for each spooled file in every output queue. This view uses the QSYS2.OUTPUT_QUEUE_ENTRIES table function with DETAILED_INFO => 'YES'.
OUTPUT_QUEUE_ENTRIES_BASIC view
The OUTPUT_QUEUE_ENTRIES_BASIC view returns one row for each spooled file in every output queue. This view uses the QSYS2.OUTPUT_QUEUE_ENTRIES table function with DETAILED_INFO => 'NO'.
OUTPUT_QUEUE_INFO view
The OUTPUT_QUEUE_INFO view returns one row for each output queue.
PRINTER_FILE_INFO view
The PRINTER_FILE_INFO view returns many attributes of IBM i printer files.
SPOOLED_FILE_DATA table function
The SPOOLED_FILE_DATA table function returns the content of a spooled file.
SPOOLED_FILE_INFO table function
The SPOOLED_FILE_INFO table function returns a list of spooled files on the system.

Parent topic: IBM i Services