Happy 7th birthday RPGPGM.COM

Another year has passed and this blog has reached its seventh anniversary. We are living in interesting times with IBM i, and over the years I have been fortunate to write about many things, that in my opinion, have made significant improvements to programming with this operating system. As well as a whole lot of cool additions to Db2 for i (SQL). I have learn a lot from what I have written about, and I am sure that I write better code than I use to.

The past year has been an exciting time, not only for this blog but for me too. I would include the following as my personal high points, in no particular order:

• Achieving IBM's "IBM Community Member Contributor Level 1" badge.
  
• Presented at OCEAN's TechCon 2019.
• Recorded a video that was shown at this year's COMMON Insight "virtual conference".
• Reached, and passed, the 600 posts milestone.

Each year I like to pick my favorite posts from the past 12 months. My picks this time are:

• Delete many spool files with one command
• Using SQL to determine which subsystems are active or not
• Equivalent of DSPPGM and DSPSRVPGM using SQL part 1
• New table function to break apart values in columns and fields
• Using SQL to list directories and files in IFS
• Using SQL to compare files for differences

I want to thank all you, the readers of this blog. Without you there would be no point in me spending my time writing all of this.

A special thank you to all of you who have sent me feedback and encouragement. This has kept me inspired to keep writing.

I have to give thanks to the folks at RZKH. Their generosity of giving me space on their IBM i partitions, and keeping them up to date, allows me to be able to research, play, and create the code I use for blog posts. A big vielen Dank to all of them.

Here's to another year of RPGPGM.COM! We will have to see all the interesting things the next year will bring.