About Me
Biography
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, awarded the John Earle Speaker Scholarship in 2023 in recognition for his contribution to the community, and Gold medal speaker.
Since its founding Simon has been the president of the Central Texas IBM i User Group (CTXiUG).
Since its founding Simon has been the president of the Central Texas IBM i User Group (CTXiUG).
Organization
Title
Interests
Title
Founder & author of RPGPGM.COM
Past Sessions
Relevance
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 ...
Many people are now integrating SQL into RPG programs & procedures. Simon will give practical examples of how you can optimize the performance of your statements & simply diagnose the feedback returned from Db2. Will include mentions of how using Views enhances this optimization process.
Have you recently taken over responsibility for a LPAR? Or are you concerned there is too much “rubbish” on your systems? Use these techniques to identify the most common wastes of space you have, & plan your cleanup efforts.
We all work in environments where data is changing, often rapidly. At times it would be nice to know what the data looked like an hour, a day, or even a week ago. With conventional files and tables this is hard, that might even involve restoring data from journals. SQL Temporal Tables alleviates ...
Simon will explain how building SQL Views should become a part of your development strategy. He will give examples of the common ways he builds and uses Views to make his own and that of his team easier and simpler. Why do the hard work yourself when something else can do it for you?
The CL programming language is under appreciated and is used by many as just a JCL. In the past few releases a lot has been added to CL that gives the IBM I programmer an alternative to doing everything with RPG or Cobol.