Topic: Tricks with Spool Files using SQL

Date:Tuesday, February 21st, 2023
Time:6:00 PM EDT (Meeting) GoToMeeting ONLY
Speaker:Simon Hutchinson
Notes:Join the meeting remotely by GoToMeeting from your computer, tablet or smartphone.
You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.)
United States: +1 (571) 317-3129
– One-touch: tel:+15713173129,,490312093
Access Code: 968-265-957
First GoToMeeting? Let’s do a quick system check.
Presentation:Tricks with Spool Files using SQL

In the past few releases and TRs IBM has introduced a number of SQL views and table functions
that allow anyone to do things to spool files that they would have had to use APIs or complex
programming. Become the superstar at your company with the knowledge on how to do all of this with
just a few SQL statements.

About the Presenter

Simon’s experience with IBM midrange started over 30 years ago in the United Kingdom, in a pre-AS/400 world. Since immigrating to the USA, in 1992, he has worked mostly in the South West and is currently IT manager responsible for Power servers and IBM i for a large bank in Central Texas. Simon has been writing his acclaimed IBM i blog, RPGPGM.COM, for nine years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL. He was recognized by IBM as an IBM Champion for Power in 2021 and 2022, and is an IBM i Community Advocate.