RE: SPOOLED_FILE_DATA table function

[Michael Mayer <michael.mayer@xxxxxxxxxxxxx>]

Kind of like this:

CPYSPLF FILE(spooled file name) TOFILE(*TOSTMF) JOB(123456/xxxxxx/yyyyyy) 
SPLNBR(1) TOSTMF('/tmp/name.pdf') WSCST(*PDF)                

Or you can use ACS, locate the spooled file, right click it the download where you want -
desktop, IFS, etc and use the PDF format.

MM             

Respectfully, 
Michael Mayer
IBM i on Power System Admin
ERMCO-ECI
2225 Industrial Rd
Dyersburg, Tennessee 38024
Cell, Office and Text Messages: 518.641.8906
Email: michael.mayer@xxxxxxxxxxxxx
https://www.ermco-eci.com   
https://ermcopower.com/
IBM i Award Winning Blog Site: https://ibmireference.blogspot.com
Awarded IBM 2024/2025 Advocate, Contributor, Influencer and IBM i Ready Badges.     
 

   2. RE: SPOOLED_FILE_DATA table function (smith5646midrange@xxxxxxxxx)


----------------------------------------------------------------------


message: 2
date: Fri, 2 Jan 2026 12:58:03 -0500
from: smith5646midrange@xxxxxxxxx
subject: RE: SPOOLED_FILE_DATA table function

So TS1 has a function that will copy a spoolfile from an outq and generate a .pdf in the IFS?  Do you know the command because I am unaware of it.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Friday, January 2, 2026 5:49 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SPOOLED_FILE_DATA table function

If you have 5770-TS1 loaded (a freebie) you get this PDF generation for free.  Ignoring it because it's a tool someone else wrote would be like ignoring CPYSPLF because someone else wrote that.

On Thu, Jan 1, 2026 at 4:31?PM <smith5646midrange@xxxxxxxxx> wrote:

> Unfortunately, everyone jumped on the "underline" and not the "bold".  
> :( The case I am dealing with is they are using it for bold print.  If 
> they want to highlight a value, they reprint the line (no advance) 
> with only that value included and that specific value is bolded.
>
> The exercise was to take a normal spoolfile sitting in an OUTQ and 
> reproduce it as a .pdf in an IFS folder for later download.  Yes, 
> there are already tools to do this but you don't learn anything by 
> using a tool that someone else wrote.  I was just trying to use the 
> SQL "not so new" tools that are being created for us by IBM.  It seems 
> this particular function is lacking some of the capabilities of CPYSPLF like FCFC information.
>
> However, now that I have retrieved the code and see it is doing the 
> same CPYSPLF under the covers, I have to wonder...why bother other 
> than to learn how to create my own function.