RE: SPOOLED_FILE_DATA table function

It's been so long since I've dealt with overprinting. Isn't this the same behavior when using CPYSPLF? Or maybe it's only DSPSPLF?

Found this in the documentation:
This function is provided in the SYSTOOLS schema as an example of how spooled file data can be returned by embedding the CPYSPLF CL command in an SQL table function. Similar to other Db2 for i provided tools within SYSTOOLS, the SQL source can be extracted and used as a model for building similar helper functions, or to create a customized version within a user-specified schema.

I don't have any quick means of generating a spool file with overprinting, so this is all WAG, but I wonder whether SPOOLED_FILE_DATA's usage of CPYSPLF uses CTLCHAR(*NONE) and this might cause overprinting to be ignored when copying the spool file. My advice to you would be to find a spool file with overprinting and see if the CPYSPLF output is different using CTLCHAR(*NONE) vs. CTLCHAR(*FCFC). If you get all the lines with the latter, extract the SQL source for SPOOLED_FILE_DATA into a newly named source, change CPYSPLF to use CTLCHAR(*FCFC), create the table function as SPOOLED_FILE_DATA_FCFC.

- Dan Bale

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of smith5646midrange@xxxxxxxxx
Sent: Wednesday, December 31, 2025 11:41 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: SPOOLED_FILE_DATA table function

I have some reports that contain overstamped lines (same line printed twice) which is used for bolding or underlining certain fields in the line. When I use the SQL function SPOOLED_FILE_DATA, it drops these lines. Is this a flaw/bug in SPOOLED_FILE_DATA or am I doing something wrong with my SQL? I am running 7.3.

*** CONFIDENTIALITY NOTICE: The information contained in this communication may be confidential, and is intended only for the use of the recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ***