Tricks with Spool Files Using SQL
An Educational Presentation by Simon Hutchinson

Who Should Attend:

• All IBM i programmers and operators

IBM has introduced a number of SQL Views and table functions in the past few IBM i operating system releases and Technology Refreshes. These functions allow anyone to do things with spool files that previously required using Application Program Interfaces (APIs) or writing complex programs.

During this presentation, you'll learn how to use SQL to work with spool files in a partition, delete spool files, copy spool files to Adobe PDF in the Integrated File System (IFS), and extract information from spool files. Please take advantage of this free opportunity to learn how to use the latest SQL functions and become a superstar at your company.

Speaker Bio:

NGS is proud to sponsor this presentation by independent IBM i expert, Simon Hutchinson. Simon is the founder of the highly acclaimed IBM i blog, RPGPGM.COM, where he shares his knowledge and detailed examples of how to use RPG, SQL, and CL on IBM i. He's an IBM Champion for Power, IBM i Community Advocate, subject matter expert, Gold Medal speaker for COMMON North America, and a past recipient of the John Earle Speaker Scholarship. Simon regularly speaks to IBM i user groups around the world. He isn't an NGS customer, but we respect his work and are happy to help him share his knowledge with IBM i professionals.