@RPGPGM profile picture
Simon Hutchinson @RPGPGM

#IBMiguru, #IBMChampion(x6), #IBMiCommunity advocate, President of @CTXiUG, @COMMONug SME, John Earle Speaker scholar, & founder of RPGPGM.COM.

Joined June 2014
  • Tweets 3,693
  • Following 76
  • Followers 1,061
428 Photos and videos
Using #SQL SYSCOLUMNS2 to find which file fields were defined by reference. rpgpgm.com/2023/07/finding-w… 💙#IBMi #rpgpgm #IBMChampion

Finding which fields were defined using a reference field

Finding with SQL which fields in a DDS file were defined using a refence field

rpgpgm.com
47
I am looking forward to this! 💙#IBMi #rpgpgm #IBMChampion #SupportOurIBMiLUG
Briteskies@BriteskiesCle
Jun 12
Join @SimonHutchinson for our #iMWUG webinar on IBM i auditing with SQL triggers and Db2 audit columns. July 14, 12–1 PM EST. Register: hubs.ly/Q04hXn-d0 #IBMi #Db2
1
56
Getting a list of all the jobs in all the job queues on my system with #SQL. rpgpgm.com/2024/02/new-view-… 💙#IBMi #rpgpgm #IBMChampion

New View for listing jobs within job queues

SQL View that lists all of the submitted jobs and the job queues they are stilling in

rpgpgm.com
39
In 2 weeks, Thursday 25 June, I'll be talking to COMMON Austria, online. To learn more & register. common.at/20-know-your-ibm-i… 💙#IBMi #rpgpgm #IBMChampion

20. Know Your IBM i Session | commonaustria

common.at
38
In zwei Wochen, am Donnerstag, den 25. Juni, spreche ich online mit COMMON Austria. Weitere Informationen und die Möglichkeit zur Anmeldung finden Sie hier. common.at/20-know-your-ibm-i… 💙#IBMi #rpgpgm #IBMChampion

20. Know Your IBM i Session | commonaustria

common.at
39
Today is the 13th birthday of RPGPGM.COM, it is 13 years since I wrote my first post for this blog. Wow! 💙#IBMi #rpgpgm #IBMChampion rpgpgm.com/2026/06/rpgpgmcom…

ACS version 1.1.9.12 available

This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of

rpgpgm.com
5
47
Next week, Wed Jun 17, I will be talking to TUG, the only Canadian #IBMi User Group. I will be talking about getting the most from #SQL when you embed it in your #IBMiRPG programs. The event is free, online, & register➡️ tug.ca/t_agenda.php #IBMi #rpgpgm #IBMChampion
1
39
Most useful way to retrieve where the cursor is positioned on a display file. rpgpgm.com/2025/05/where-on-… 💙#IBMi #rpgpgm #IBMChampion

Where on the subfile is the cursor

In a subfile how to retrieve the record format name, subfile relative record number of the record, and field name where the cursor is positioned.

rpgpgm.com
1
1
43
Every so often someone asks me what all the #IBMi object types are. This is how you can list them all. rpgpgm.com/2024/07/list-all-… 💙#IBMi #rpgpgm #IBMChampion

List all object types using SQL

Being able to get a list of all the object types from a Db2 for I,SQL, View. Includes IFS and non-IFS object types.

rpgpgm.com
45
A simple way, using #SQL, to identify “flat files”, files with no source & created just with CRTPF. rpgpgm.com/2025/06/how-to-id… 💙#IBMi #rpgpgm #IBMChampion

How to identify flat files

How to determine which files are flat-files, created with DDS source code

rpgpgm.com
80
How to handle null in #IBMiRPG. rpgpgm.com/2016/03/handling-… 💙#IBMi #rpgpgm #IBMChampion

Handling null in RPG

Nulls are becoming more common as IBM i programs encounter data coming from different sources. They are nothing to fear as RPG handles them in a simple and straight forward manner

rpgpgm.com
63
A nice mention of RPGPGM.COM in the latest (May – June) IBM Champions newsletter. community.ibm.com/community/… #IBMi #rpgpgm #IBMChampion
2
64
Who is that wise man? He is offering excellent advice! #IBMi #rpgpgm #IBMChampion
COMMON - A Users Group@COMMONug
Jun 3
You've built valuable experience throughout your career - now pass it on. The N2i Mentorship Program connects seasoned professionals with the next generation of IBM i talent. Become a COMMON Mentor: hubs.li/Q04jXhKD0
0:31
1
82
This is going to be a great event! #IBMi #rpgpgm #IBMChampion #SupportOurIBMiLUG
OCEAN Tech Users Group - All Aspects of IT@OCEANUserGroup
Jun 3
Replying to @P_Behr
@P_Behr, @RPGPGM, & @MikeyPEI think you need to attend #OCEANTechCon26 this July! It will be a great opportunity to #network with both your peers and the #IBMi Experts! #AI #SQL #APIs #Db2 #Python #ILERPG Details: tinyurl.com/OCEANTechCon26 @GarrettSchut @Wright4i
1
76
Calculate the Ordinal date, often called the Julian date, using #SQL. 💙#IBMi #rpgpgm #IBMChampion rpgpgm.com/2026/06/determini…

Determining the Ordinal date with SQL

Calculate the Ordinal date, often called the Julian date, using SQL

rpgpgm.com
45
How to use the long SQL column/field names in my #IBMiRPG program. rpgpgm.com/2018/05/how-to-sq… 💙#IBMi #rpgpgm #IBMChampion

How to SQL table's long names in RPG program

Making using the long names of columns in DDL tables easy in RPG programs

rpgpgm.com
56
In 3 weeks I will be talking with @TUG_Members , Wed Jun 17, about the best ways to incorporate, & get the most from, #SQL embedded in your #IBMiRPG programs. The event is free and online➡️tug.ca/t_agenda.php 💙#IBMi #rpgpgm #IBMChampion
68
Thank you all of you who attended my chat with @COMMONug #N2i. I hope you found something you can start using tomorrow! 💙#IBMi #rpgpgm #IBMChampion
42
I am going to have a busy month in June, making three online presentations to three different countries. I hope to see you at one of them. 💙#IBMi #rpgpgm #IBMChampion rpgpgm.com/2026/06/junes-pre…

June's presentations

My presentations this month start today, June 1! At 4:00 PM ( CT ) I am the guest speaker for COMMON N2i as part of their "N2i Getti...

rpgpgm.com
1
49
Today (Mon Jun 1) @ 4:00 PM CT I will be talking to @COMMONug #N2i about my favorite #IBMiRPG BiFs. This is all good stuff for #N2i, & those with more experience too. It is online & FREE! Register➡️ common.org/n2i-getting-start… See you there! 💙#IBMi #rpgpgm #IBMChampion

N2i - Getting Started Series

The N2i getting started series touches on many of the basics of the i, with new content being added each month.

common.org
38
Load more