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

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

Of course, after reading James initial question you'd have to add the
following to the where clause
and spooled_file_name = 'enterNameHere'

For testing:
change this:
...as cmd,
qcmdexc(
    'DLTSPLF FILE(' *CONCAT* SPOOLED_FILE_NAME *CONCAT* ') JOB(' *CONCAT*
    JOB_NAME *CONCAT* ') SPLNBR(' *CONCAT* FILE_NUMBER *CONCAT* ')') as
 cmd_result

to this:
...as cmd
-- , qcmdexc(
--      'DLTSPLF FILE(' *CONCAT* SPOOLED_FILE_NAME *CONCAT* ') JOB('
*CONCAT*
--      JOB_NAME *CONCAT* ') SPLNBR(' *CONCAT* FILE_NUMBER *CONCAT* ')') as
 cmd_result
until your reach your comfort level

On Thu, Jul 25, 2024 at 2:15 PM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

> 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.