Re: SPOOLED_FILE_DATA table function

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Always glad to have helped, my friend!

Happy New Year!

*Regards*

*Vern Hamberg*

IBM Champion 2025 <cid:part1.DWKxgvfN.N3DO6Dti@centurylink.net> CAAC 
(COMMON Americas Advisory Council) IBM Influencer 2023


On 1/2/2026 9:35 AM, Dan Bale via MIDRANGE-L wrote:
> The Schemas tool!  Thanks Vern!  Somehow I forget to look in there.  I blame it on the rush to get out early on NYE.
>
> That's a heckuva lot easier than the "manual" method.
>
> - Dan Bale
>
> -----Original Message-----
> From: MIDRANGE-L<midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Vern Hamberg via MIDRANGE-L
> Sent: Wednesday, December 31, 2025 3:35 PM
> To:midrange-l@xxxxxxxxxxxxxxxxxx
> Cc: Vern Hamberg<vhamberg@xxxxxxxxxxxxxxx>
> Subject: Re: SPOOLED_FILE_DATA table function
>
> Hi Dan
>
> Just curious, because I suspect you know that you can get the source using the ACS Schemas tool (some might not, and I haven't looked at Simon's article yet) - I went to the SYSTOOLS library, found the table function, right-clicked it, clicked on the *Generate SQL* option - there are options for saving to PC file or IFS or source file
>
> *Regards*
>
> *Vern Hamberg*
>
> IBM Champion 2025<cid:part1.7gD71REH.O5Bb0TNm@centurylink.net> CAAC (COMMON Americas Advisory Council) IBM Influencer 2023
>
> *** 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. ***