The largest IBM i-related conference event in the world, bringing together the community of users, IBM, industry experts and solution providers.
Back To Schedule
Wednesday, April 26 • 8:00am - 9:00am
278: Tricks with Spool Files using SQL

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

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.

Learning Objectives:
1. How to find the biggest/oldest spool files on your systems.
2. How to delete old spool files.
3. How to extract data from a spool file into spreadsheet format
4. How to build views over spool files, even when they are not there
5. How to copy one spool file to PDF
6. How to copy many spool files to PDF

avatar for Simon Hutchinson

Simon Hutchinson

Simon Hutchinson has been writing his highly acclaimed IBM i blog, RPGPGM.COM, for over ten years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL. His work has led him to be recognized by IBM as an IBM Champion for Power and IBM i Community Advocate. He is a subject matter expert for COMMON North America... Read More →

Wednesday April 26, 2023 8:00am - 9:00am MDT
Governors Square 14
  • Session Level Intermediate
  • Audience Any IBM i programmer looking for a simple way to handle output from spool files with using APIs or 3rd party tools