RE: Downloading a spool file?

There is also the GENERATE_PDF SQL Service in the SYSTOOLS Schema which allows you to convert the spoolfile into a PDF and save it directly in the IFS.
https://www.ibm.com/docs/en/i/7.5?topic=services-generate-pdf-scalar-function

Example:
VALUES SYSTOOLS.GENERATE_PDF(
JOB_NAME => '908049/QUSER/QZDASOINIT',
SPOOLED_FILE_NAME => 'PGMA',
SPOOLED_FILE_NUMBER => 2,
PATH_NAME => '/usr/listing1');

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 Rob Berendt
Sent: Friday, 2 August 2024 20:17
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Downloading a spool file?

There's also this service

SELECT * FROM TABLE(SYSTOOLS.SPOOLED_FILE_DATA(
JOB_NAME *=>*'609305/ROB/ROBS1',
SPOOLED_FILE_NAME *=>*'QPSUPRTF')) ORDER BY ORDINAL_POSITION;

That's a source listing. To remove headers you might want:

SELECT * FROM TABLE(SYSTOOLS.SPOOLED_FILE_DATA(
JOB_NAME *=>*'609305/ROB/ROBS1',
SPOOLED_FILE_NAME *=>*'QPSUPRTF')) where *substr*(spooled_data, *3*, *7*) not in( '5770WDS', 'SOURCE ', 'MEMBER ', 'SEQNBR*') ORDER BY ORDINAL_POSITION

On Fri, Aug 2, 2024 at 2:09 PM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

Any somewhat current version of IBM i can load the free 5770-TS1 IBM
Transform Services for i.

Then it becomes a simple matter to convert a spool file to a PDF.
One way is to OVRPRTF prior to it printing with something like OVRPRTF
FILE(QP1ARCY) DEVTYPE(*AFPDS) TOSTMF(&QP1ARCY) WSCST(*PDF)

Another way is for the user to use iACS to find their spool files and
then Edit, Preferences and select PDF and then click on that spool
file and download it.

On Fri, Aug 2, 2024 at 1:56 PM James H. H. Lampert via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Is there an easy way (given only terminal and FTP access to the
system) to download the contents of a spool file in a form that
desktop boxes can deal with? Something that can then be converted
into, say, a spreadsheet?

At over 2k pages, this report is not something any sane person would
send to a printer (in my mind's eye, I see a 1403 line printer
chewing through half a box of greenbar). And I'd probably die of old
age trying to copy and paste the whole thing out of a terminal session.

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

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