Re: How to Release all spool jobs

On Friday 09 July 2004 02:33, Mike Berman wrote:
> HI I have an outq that for the time being, I have a problem, there are
> thousands of spool files that have to be moved into this outq. Problem
> #1. But once they are there, well they've been HELD in the job, so at
> least if there was some command or via an API to unhold an entire outq?

Hi Mike

Have a look at CHGSPLFA FILE(*SELECT) which lets you do global changes to 
spooled files based on user, print device, form type & user data. If that 
doesn't do what you need you could roll your own using the list spooled 
file API, QUSLSPL. There's an Open List of Spooled Files API as well, for 
when the numbers get really high (check the list archives).

There are a couple of commands available on my free software site that would 
do what you need, or serve as examples of using the Spooled File APIs. 
MOVOUTQ - Move Output Queue, tackles the first issue. There is code in my 
CVS repository for another tool, ACTOUTQ - Action Output Queue, that will 
hold, save, release or delete matching spooled files. I've not packaged 
that yet, but there are only a few source members needed for it.

http://dbg400.homeip.net/cgi-bin/viewcvs.cgi/*checkout*/dbg400/QCMDSRC/ACTOUTQ.cmd
http://dbg400.homeip.net/cgi-bin/viewcvs.cgi/*checkout*/dbg400/QPNLSRC/ACTOUTQ.pnlgrp
http://dbg400.homeip.net/cgi-bin/viewcvs.cgi/*checkout*/dbg400/QCLSRC/DBG197CL.clp
http://dbg400.homeip.net/cgi-bin/viewcvs.cgi/*checkout*/dbg400/QRPGLESRC/DBG197R4.rpgle

Note that both commands rely on an existing install of WRKUSROUTQ (which in 
turn relies on DBG/400). Details & downloads from: 
http://www.dbg400.net/movoutq.html

Regards, Martin
-- 
martin@xxxxxxxxxx  AIM/Gaim: DBG400dotNet  http://www.dbg400.net   /"\
DBG/400 - AS/400 & iSeries Open Source/Free Software utilities     \ /
Debian GNU/Linux | ASCII Ribbon Campaign against HTML mail & news   X
                                                                   / \