Not sure what exactly you need, but have you had a look at the SQL Services in the SYSTOOLS Schema:
- GENERATE_PDF or
- SPOOLED_FILE_DATA and then write to the IFS with one of the IFS_WRITE SQL functions.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization – Education – Consulting on IBM i
Database and Software Architect
IBM Champion since 2020
"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"
"Train people well enough so they can leave, treat them well enough so they don't want to. " (Richard Branson)
"Learning is experience … everything else is only information!" (Albert Einstein)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jim Oberholtzer
Sent: Friday, 21 March 2025 15:40
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Automate spool download using ACS
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.
midrange.com
