Re: Quick question: mass-delete of spool files?

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

You mean like this?

select spooled_file_name, job_name, file_number,
'DLTSPLF FILE(' *CONCAT* SPOOLED_FILE_NAME *CONCAT* ') JOB(' *CONCAT*
JOB_NAME *CONCAT* ') SPLNBR(' *CONCAT* FILE_NUMBER *CONCAT* ')' as cmd,
qcmdexc(
    'DLTSPLF FILE(' *CONCAT* SPOOLED_FILE_NAME *CONCAT* ') JOB(' *CONCAT*
    JOB_NAME *CONCAT* ') SPLNBR(' *CONCAT* FILE_NUMBER *CONCAT* ')') as
 cmd_result
from qsys2.OUTPUT_QUEUE_ENTRIES
where job_name like '%/QPADEV0001';

In Run SQL Scripts you can save that as a template for easy reuse.  See
Edit, Examples, Save as new example.

On Thu, Jul 25, 2024 at 1:47 PM James H. H. Lampert via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> Is there a quick way, from a command line, to delete several hundred
> spool files sharing a common file name and job name (but different job
> numbers)?
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.