Re: Automate spool download using ACS

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

I'd write a stored procedure looping through a cursor opened over
https://www.ibm.com/docs/en/i/7.5?topic=services-output-queue-entries-view
for each selected row I'd pump it through something to do a
- Create or clear a db2 work file (ie crtpf qtemp/spool rcdlen(150))
- CPYSPLF to this file
- CPYTOSTMF

Quite easily done.  Really this stuff is so easy I've almost given up on CL
instead of trying to shoehorn SQL into CL.  I just use Stored Procedures.
Now, implementing that into your corporate change management system is a
hoot.  The FNG's should pick up on this stuff easily enough.

On Fri, Mar 21, 2025 at 10:40 AM Jim Oberholtzer <
midrangel@xxxxxxxxxxxxxxxxx> wrote:

> We have a monthly task where we need to download about 20 spool files to
> individual text documents.   Really easy with ACS, except it’s manual.   We
> know the user, and spool queue and of course the date we need.
>
> I could email an archive file from the system if I can get them all into
> the archive.   Various topics surrounding this topic have gone on in the
> list , but not one that actually hits his use case (Sorry Brad I know you
> can do this but they won’t pop for the small amount each year)
>
> Thoughts on the process?
>
>
> Jim Oberholtzer
> Agile Technology Architects
> --
> 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.