Simon Hutchinson
LightNews LightNews
banner
rpgpgm.bsky.social
Simon Hutchinson
@rpgpgm.bsky.social
44 followers 0 following 210 posts
#IBMiguru, #IBMChampion, #IBMiCommunity advocate, President of
CTXiUG, COMMON SME, John Earle Speaker scholar, COMMON Gold medal speaker, & founder of the renowned website RPGPGM.COM
Posts Replies Media Videos
rpgpgm.bsky.social
Tomorrow, Tuesday November 18 at 2:00 PM (CT), I am talking to @QUSER, for 2+ hours about getting the most from #SQL with your #IBMiRPG.

All are welcome. Register at ➡ www.quser.org/content/quse...

I hope to see you there! 😎

#IBMi #rpgpgm #IBMChampion #SupportOurIBMiLUG
QUSER November 2025 | QUSER
www.quser.org
November 17, 2025 at 3:54 PM
rpgpgm.bsky.social
Deleting unwanted journal receivers that are found in QSYS.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/11/dele...
Deleting QAUDJRN's journal receivers if they are in QSYS
Deleting unwanted journal receivers that are found in QSYS
www.rpgpgm.com
November 13, 2025 at 1:23 PM
rpgpgm.bsky.social
On Tuesday November 18 at 2:00 PM (CT) I am talking to @QUSER, giving two hours about getting the most from #SQL with your #IBMiRPG.

All are welcome. Register at ➡ www.quser.org/content/quse...

I hope to see you there! 😎

#IBMi #rpgpgm #IBMChampion #SupportOurIBMiLUG
QUSER November 2025 | QUSER
www.quser.org
November 6, 2025 at 2:58 PM
rpgpgm.bsky.social
SQL view, SQLSTATE_CODES, that returns information about every SQL state.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/11/retr...
Retrieve information about SQL state
SQL view, SQLSTATE_CODES, that returns information about every SQL state
www.rpgpgm.com
November 6, 2025 at 11:36 AM
rpgpgm.bsky.social
The events I am involved with this month, includes Central Texas IBM i User Group (CTXiUG), System i Developer's Lunch & Learn, & QUSER.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/11/nove...
November's presentations
This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of
www.rpgpgm.com
November 3, 2025 at 12:36 PM
rpgpgm.bsky.social
Next week, Wednesday November 5, CTXiUG welcomes Gregory Simmons as our guest speaker. He will be talking about becoming a power user with ACS.

This event is FREE & online.
ctxiug.blogspot.com/2025/10/nove...

See y’all there!

#IBMi #IBMChampion #SupportOurIBMLUG #AS400 #iSeries #IBMiLUG
November 2025 meeting
Central Texas IBM i User Group for those in Central Texas (greater Austin and San Antonio areas) interested in the IBM i and PowerSystems
ctxiug.blogspot.com
October 31, 2025 at 11:48 AM
rpgpgm.bsky.social
Overcoming an error extracting data from the Audit Journal, QAUDJRN, and how to delete the old unwanted journal receivers.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/10/dele...
Deleting the journal receivers of QAUDJRN
Overcoming an error extracting data from the Audit Journal, QAUDJRN, and how to delete the old unwanted journal receivers
www.rpgpgm.com
October 30, 2025 at 9:26 AM
rpgpgm.bsky.social
Use SQL to check if there are any certificates in my IBM I partition that are going expire in the near future.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/10/chec...
Checking for expired certificates
Use SQL to check if there are any certificates in my IBM I partition that are going expire in the near future
www.rpgpgm.com
October 23, 2025 at 10:06 AM
rpgpgm.bsky.social
Two free courses from IBM. Read their blog about them =>
community.ibm.com/community/us...

#IBMi #rpgpgm #IBMChampion
Announcing two free IBM i courses: DL06004G and DL06005G
community.ibm.com
October 19, 2025 at 6:25 PM
rpgpgm.bsky.social
Creating database check constraints to move the checking of data from programs and into the database.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/10/addi...
Adding check constraints to your database
Creating database check constraints to move the checking of data from programs and into the database
www.rpgpgm.com
October 16, 2025 at 9:53 AM
rpgpgm.bsky.social
A subfile program to display the top 10 CPU intensive jobs that automatically updates itself.
www.rpgpgm.com/2025/08/how-...

#IBMi #rpgpgm #IBMChampion
How to view the top 10 jobs using the most CPU
A subfile program to display the top 10 CPU intensive jobs that automatically updates itself
www.rpgpgm.com
October 9, 2025 at 3:21 PM
rpgpgm.bsky.social
The Fall 2025 Technology Refreshes, IBM I 7.6 TR1 and 7.5 TR7, have been announced.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/10/fall...
Fall 2025 Technology Refreshes announced
The Fall 2025 Technology Refreshes, IBM I 7.6 TR1 and 7.5 TR7, have been announced
www.rpgpgm.com
October 7, 2025 at 12:28 PM
rpgpgm.bsky.social
Wow! I was not expecting this mention at TechXchange! 😮

Thanks to Jeff Yanoviak for sharing this.

(As of my last report to IBM Champions I have written 70 posts in 2025)
#IBMi #rpgpgm #IBMChampion #TechXchange
October 6, 2025 at 11:58 AM
rpgpgm.bsky.social
#IBMi events I am involved in during October.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/10/octo...
October's presentations
This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of
www.rpgpgm.com
October 3, 2025 at 12:14 PM
rpgpgm.bsky.social
Adding database constraints to DDS physical files using SQL and CL commands.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/10/basi...
Basic constraints with DDS files
Adding database constraints to DDS physical files using SQL and CL commands
www.rpgpgm.com
October 2, 2025 at 11:30 AM
rpgpgm.bsky.social
Announcing 9 new (free!) Summit Lunch & Learn sessions for #IBMidevelopers! Bite-sized tips on #RPGLE, AI, #SQL, #Db2fori, #code4i, BI, #IBMi web apps, modernization, & more. Hosted by
Jon Paris, Susan Gantner, Simon Hutchinson, Patrick Behr, & Mike Pavlak

www.systemideveloper.com/pages/events...
Lunch & Learn
www.systemideveloper.com
September 26, 2025 at 12:32 PM
rpgpgm.bsky.social
Adding unique, primary key, and foreign key constraints to a DDL Table.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/09/basi...
Basic constraints with SQL tables
Adding unique, primary key, and foreign key constraints to a DDL Table
www.rpgpgm.com
September 25, 2025 at 9:34 AM
rpgpgm.bsky.social
Get your copy of IBM's Db2 for i catalog poster.
#IBMi
www.rpgpgm.com/2025/09/get-...
Get your copy of the Db2 poster
Get your copy of IBM’s Db2 for i catalog poster
www.rpgpgm.com
September 22, 2025 at 10:07 AM
rpgpgm.bsky.social
End of Support for IBM i release 7.4 is formally announced.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/09/eos-...
EoS for 7.4 announced
End of Support for IBM i release 7.4 is formally announced
www.rpgpgm.com
September 19, 2025 at 12:05 PM
rpgpgm.bsky.social
Extracting the same piece of information from multiple versions of the same spool file with SQL.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/09/extr...
Extracting the same data from multiple spool files with SQL
Extracting the same piece of information from multiple versions of the same spool file with SQL
www.rpgpgm.com
September 18, 2025 at 9:55 AM
rpgpgm.bsky.social
Updates have been made for this month, September, in the #IBMi Community Calendar. See what’s is going on in the #IBMi community here.
➡ ibmicommunity.blogspot.com

#SupportOurIBMiLUG #rpgpgm #IBMChampion
September 15, 2025 at 5:23 PM
rpgpgm.bsky.social
Feeling happy to learn that I was a Gold Medal speaker for my presentation at COMMON Navigate 2024 in Toronto. 🥇

#IBMi #rpgpgm #IBMChampion
September 15, 2025 at 12:58 PM
rpgpgm.bsky.social
Fortra "state of the IBM i" survey opens today. Please take part so that your information is include in this great resource.
#IBMi
www.surveymonkey.com/r/Fortra-pow...
2026 IBM i Marketplace Survey
Take this survey powered by surveymonkey.com. Create your own surveys for free.
www.surveymonkey.com
September 15, 2025 at 10:09 AM
rpgpgm.bsky.social
Using #SQL scalar function to capture the remainder from a division operation, and compare it to how RPG does it.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/09/calc...
Calculating the remainder using SQL
Using SQL scalar function to capture the remainder from a division operation, and compare it to how RPG does it
www.rpgpgm.com
September 11, 2025 at 9:29 AM
rpgpgm.bsky.social
The people from Norway who have joined the RPGPGM.COM-unity.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/09/rpgp...
RPGPGM.COM-unity i Norge
The people from Norway who have joined the RPGPGM.COM-unity
www.rpgpgm.com
September 9, 2025 at 10:08 AM