Name: Tricks with Spool Files using SQL
Start: 2025-05-22T11:15:00-0700
End: 2025-05-22T12:15:00-0700

Unlock the Power of IBM i at POWERUp 2025!

Join us in Disneyland, California, for POWERUp 2025, the premier conference for IBM i professionals. Whether you’re an experienced expert or just starting your IBM i journey, this event offers unparalleled education, hands-on workshops, and valuable networking opportunities. Stay ahead of the curve with insights from industry leaders, explore the latest innovations, and connect with a thriving community that shares your passion for IBM i. Don’t miss this opportunity to expand your knowledge, grow your skills, and power up your career!

Thursday May 22, 2025 11:15am - 12:15pm PDT

South Ballroom A

Evaluation Survey

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:

Identity old spool files on your system
Largest spool files on your system
Who has the most spool files on your system
Which output queues have the most
Use SQL procedure to customize and delete spool files from output queues
Convert any spool file to PDF with no 3rd party tools
Create database tables from spool files, & create them to be reusable templates

Speakers

Simon Hutchinson

Founder & author, RPGPGM.COM

Simon Hutchinson has been writing his highly acclaimed IBM i blog, RPGPGM.COM, for eleven 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 five times, and IBM i Community Advocate. He is a subject matter expert for COMMON, awarded... Read More →

Tricks with spool files using SQL pdf

Thursday May 22, 2025 11:15am - 12:15pm PDT
South Ballroom A 1150 Magic Way, Anaheim, CA 92802

Programming: General

Attendees (45)

G
S
R
J
S
B
View All →

COMMON POWERUp 2025

Simon Hutchinson

Attendees (45)

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