iSee SQL Everywhere

Speaking of hidden gems, this one is a gem within the gem. Imagine being able to find and review all the SQL that is coded within your programs (*PGM) and service programs (*SRVPGM). You not only discover the SQL statements and how they are being presented to the database, you can leverage this capability for real-time impact analysis, and so much more! This episode leverages the power of some database statistical catalogs, along with an SQL interface into the SQL Parser, that provides an amazing view of the SQL used within your applications.

Tim Rowe

Business Architect Application Development & Systems Management for IBM i

Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.

Scott Forstie

Db2 for i Business Architect

Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.

Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.