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

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

I don't recall having any asterisks around my concat in the example.

In Run SQL Scripts there is an icon on the lower right to run to the end or
some such thing.

Another trick is to total up the cmd_result column and just show the
total.  That will get it to run to the end.  But you might be better off to
do a
select cmd_result, count(*) ...
...
group by cmd_result to get a count of how many were successfully deleted
and how many failed.  Why would it fail?
- Not authorized?
- someone deleted it during the run?
One query I had similar to this I ran this week dealt with the IFS and the
cmd was having issues due to strange characters in the ifs name.  So
basically I had 7,000 plus good ones and about 2 dozen problem names I had
to use a manual generic delete to blast them.  Even a 4 in WRKLNK would
fail.

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

> Thanks, Rob.
>
> As much as I value running things "with the training wheels attached"
> until I have confidence that they won't blow up, I don't think
> commenting out part of the command is necessary in this case.
>
> But there were a few things that *did* have to change.
>
> STRSQL didn't like "*CONCAT*"; it worked fine with "CONCAT" instead.
>
> And of course, you need to reformat to fit the 68-character line. This
> gives:
>
> ===> 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 '%/WTCPVERIFY' and
>       spooled_file_name = 'QPRINT'
>
>
> And finally, you do have to go through the result-set. You don't need to
> page down; you can do a "+1000" a few times. But in STRSQL, if it
> doesn't display, it doesn't happen (which supplies a set of training
> wheels in and of itself).
> --
> 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.