Gee, isn't the AS/400 PrintQueue issue great? (NOT!)
We have been doing some extensive review regarding this issue - I'll fill a
few of you needful folk in, on the issues.
Both the Work with Submitted Jobs/Job Control Master(interactive) and the
Job Control Master (R9861101/R9861102) use the F986110 DS OVERRIDE function
(OVERRIDE DATABASE FILE) to point to a specific library for the F986110
table (usually, one that is shared across the LPAR).
The PDFs/CSVs/whatevers are stored in PrintQueue Library as Members. Each
Member's name is based on a naming convention using a letter prefix and the
JobNumber of the submitted job (D#####, F#####). The architecture of the
AS/400 only allows for 32K members (technically not files). BSFNs retrieve
the member (basically a saved object) based on type and jobnumber.
The Work With Submitted Jobs will allow you to QBE by the first characters
of a UBE (R42565*) to select all of the UBE's by a report name.
The Batch Application will allow you to delete based on days old, only
(everything more than ## days old will go away). You cannot target a
specific UBE using the R986110# Batch Process.
We copied the R9861101/02 (R5598611/2) and added ER to delete specific UBEs
within a shortened time frame. Basically we do the following inside our Do
Section (R55986112):
* Parse the 'Foundation Future Use 2' field for the first underscore (this
returns the Submitted UBE's Name')
* Check to see if the UBE Name is on our discard list (if parsed name =
R42##, R####, R###...)
* Check to see how old the record is (test for retention)
* Delete using the DeletePrinterFile Function (based on above criteria)
Identifying the UBEs that can be quickly deleted is the most difficult
aspect of the issue...
Good luck in your adventures!
Daniel Bohner
[email protected]
www.existinglight.net
AS/400 SP 18 XE
Daniel Bohner
[email protected]
www.existinglight.net
JDE - XE, SP 18 & AS/400 V4R5.0
JDE - B7331 & MS SQL 7x