You may want to look at some of the online or plug-in SQL formatters. They'll make your statements sooooo much easier to read.
I used to use SQL Workbench/J for my work. So many options and each statement can be in its own tab for reference. Also, easy to format and copy/paste into a source member for embedded SQL, QRYDFN's, etc.
I was connecting to IBM I, MS-SQL, and Oracle at the time.
I recall seeing ACS having some formatting options? Not sure and never delved into it.
Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of James H. H. Lampert via MIDRANGE-L
Sent: Thursday, July 25, 2024 2:01 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: James H. H. Lampert <jamesl@xxxxxxxxxxxxxxxxx>
Subject: Re: Quick question: mass-delete of spool files?
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.
midrange.com
