Loading…
COMMON NAViGATE has ended
Tuesday, May 25 • 4:00pm - 4:20pm
A few quick things you can use SQL to check for

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

Feedback form is now closed.
Using SQL allows you to keep tabs on the following: - Do I need to RGZPFM? Number of deleted records in files. What happens if I want to exclude some libraries or files? - Old spool files - Abandoned files in IFS - Check for errors on this partition & others all on one screen - WRKSYSSTS equivalent snapshot to email or log file Also creating SQL Views over data areas & for giving CL information it can only get from APIs.

Speakers
avatar for Simon Hutchinson

Simon Hutchinson

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 and IBM i Community Advocate. He is a subject matter expert for COMMON North America and... Read More →


Tuesday May 25, 2021 4:00pm - 4:20pm EDT
Breakout 5 / Morrow