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

One of the biggest drawbacks of STRSQL is it's lack of support without
having to CAST some of the stuff Run SQL Scripts easily handles. I don't
believe you're handling CLOB, etc so you may be ok.
Worst case is having to CAST the command string.

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

On 7/25/24 10:48 AM, Brad Stone wrote:

Would this work?

DLTSPLF FILE(FILENAME) JOB(JOBNUM) SPLNBR(*ANY)

No; Rob is correct, and it just gives a stack of "duplicate job" messages.

I said "the same job *name* with different *job* numbers"; not "the same
*job* with different *spool* numbers."

Neither does Birgitta's solution help much; the stored procedure doesn't
have a parameter for job name.

If Rob's solution will work in a STRSQL session, it may be the ticket.

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