Simon Hutchinson
LightNews LightNews
banner
rpgpgm.bsky.social
Simon Hutchinson
@rpgpgm.bsky.social
45 followers 0 following 240 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
When an unexpected bug happens in #SQL scalar function REGEXP_REPLACE, the TRANSLATION scalar function can be used instead.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/02/usin...
Using SQL TRANSLATE in place of REGEXP_REPLACE
When an unexpected bug happens in SQL scalar function REGEXP_REPLACE, the TRANSLATION scalar function can be used instead
www.rpgpgm.com
February 12, 2026 at 2:37 PM
rpgpgm.bsky.social
View the results of Fortra’s 2026 #IBMi Market Place Survey.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/02/2026...
2026 Fortra survey published
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
February 9, 2026 at 12:33 PM
rpgpgm.bsky.social
Additional parameters added to the SEND_MESSAGE SQL procedure now allows me to send messages to any message queue.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/02/send...
SEND_MESSAGE can now send message to any message queue
Additional parameters added to the SEND_MESSAGE SQL procedure now allows me to send messages to any message queue
www.rpgpgm.com
February 5, 2026 at 10:38 AM
rpgpgm.bsky.social
The #IBMi Community Calendar has been updated for this month.

If you are involved with an #IBMi user group and you would like your events added to the calendar, please contact me with its details.

ibmicommunity.blogspot.com

#IBMi #AS400 #SupportOurIBMiLUG
IBM i Community
IBM i Community Calendar for upcoming events in North America
ibmicommunity.blogspot.com
February 3, 2026 at 12:40 PM
rpgpgm.bsky.social
Where I will be presenting this month, February. Come join me.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/02/febr...
February'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
February 2, 2026 at 11:35 AM
rpgpgm.bsky.social
End of Support for the small sized IBM Power9 servers happens tomorrow January 31, 2026.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/01/end-...
End of support for small Power9 effective tomorrow
End of Support for the small sized IBM Power9 servers happens tomorrow January 31, 2026.
www.rpgpgm.com
January 30, 2026 at 2:22 PM
rpgpgm.bsky.social
Examples of how to create JSON data, with and without labels, and then how to consume this data into a RPG data structure array.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/01/bett...
Better examples for creating and consuming JSON
Examples of how to create JSON data, with and without labels, and then how to consume this data into a RPG data structure array
www.rpgpgm.com
January 29, 2026 at 11:59 AM
rpgpgm.bsky.social
I am one of the starting speakers at this year's COMMON #Focus2026. Come join me as I share my experiences on February 17 at 8:30 AM (CT).
Hope to see y'all there.
www.common.org/focus/
January 28, 2026 at 2:40 PM
rpgpgm.bsky.social
RPG can now implicitly convert the data types of variables used in certain Built in Functions, BiFs.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/01/rpg-...
RPG BiFs that now convert CCSID
RPG can now implicitly convert the data types of variables used in certain Built in Functions, BiFs
www.rpgpgm.com
January 22, 2026 at 2:50 PM
rpgpgm.bsky.social
IBM's latest Access Client Solutions, ACS, was released this week as 1.1.9.11.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/01/new-...
New ACS update, 1.1.9.11, fixes vulnerability
IBM’s latest Access Client Solutions, ACS, has been released as 1.1.9.11
www.rpgpgm.com
January 16, 2026 at 12:00 PM
rpgpgm.bsky.social
Use #SQL to retrieve from all the Querys in a library the files they use into an output file.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/12/list...
Another way to list files defined in Querys
Use SQL to retrieve from all the Querys in a library the files they use into an output file
www.rpgpgm.com
January 15, 2026 at 11:16 AM
rpgpgm.bsky.social
Next week, Tue Jan 13, 6:30 PM (CT), CTXiUG welcomes Simon Hutchinson as our guest speaker, and he will be talking about Modern RPG Arrays Features. It will be a shame if you miss it. This event is online & FREE➡️
ctxiug.blogspot.com/2025/12/janu...

#IBMi #IBMChampion #SupportOurIBMLUG
January 2026 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
January 8, 2026 at 6:39 PM
rpgpgm.bsky.social
A new way to list the columns and their values I will be inserting into a SQL table or DDS file with a SQL Insert statement.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/01/a-ne...
A new way to list columns for SQL insert
A new way to list the columns and their values I will be inserting into a SQL table or DDS file with a SQL Insert statement
www.rpgpgm.com
January 8, 2026 at 10:23 AM
rpgpgm.bsky.social
There were 126 recipients of RPGPGPM.COM-unity ribbons last year! If you see me a conference this year ask me for one, and you will be one of the 2026 inductees. 😎
more.rpgpgm.com/rpgpgmcom-un...

#IBMi #rpgpgm #SupportOurIBMiLUG
RPGPGM.COM-unity pictures
What does the ribbon represent? (RPGPGM.) COM-unity : We are all part of the IBM i community (RPGPGM.COM-) unity : We need to...
more.rpgpgm.com
January 3, 2026 at 9:47 PM
rpgpgm.bsky.social
Where I will be talking during January.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/01/janu...
January'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
January 2, 2026 at 11:04 AM
rpgpgm.bsky.social
Wishing you an Happy 2026, and wondering what the new year will bring to us all.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/01/happ...
Happy New Year 2026 to you all
Wishing you an Happy 2026, and wondering what the new year will bring to us all.
www.rpgpgm.com
January 1, 2026 at 11:03 AM
rpgpgm.bsky.social
Using the PRTCMDUSG command and other methods to get a list of all the source members that contain a certain string.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/12/find...
Find where a command is used in programs
Using the PRTCMDUSG command and other methods to get a list of all the source members that contain a certain string
www.rpgpgm.com
December 31, 2025 at 11:03 AM
rpgpgm.bsky.social
Testing the ZLIB compression algorithm with the save commands running on a Power 10 with IBM i 7.5
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/12/savi...
Saving using the ZLIB algorithm
Testing the ZLIB compression algorithm with the save commands running on a Power 10 with IBM i 7.5
www.rpgpgm.com
December 24, 2025 at 12:48 PM
rpgpgm.bsky.social
Wishing you a very Merry Christmas from RPGPGM.COM!
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/12/merr...
Merry Christmas to everyone
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
December 19, 2025 at 11:38 AM
rpgpgm.bsky.social
Tuesday January 13, 6:30 PM (CT), @CTXiUG welcomes @RPGPGM Simon Hutchinson as our guest speaker. He is a great speaker & it would be a shame if you miss it. This event is online & FREE➡️
ctxiug.blogspot.com/2025/12/janu...

See y’all there!

#IBMi #IBMChampion #SupportOurIBMLUG #AS400 #iSeries
January 2026 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
December 17, 2025 at 3:25 PM
rpgpgm.bsky.social
Using #SQL for an easier way to determine if a number is odd or even.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/12/dete...
Determine if a number is even or odd
Using SQL for an easier way to determine if a number is odd or even
www.rpgpgm.com
December 17, 2025 at 11:04 AM
rpgpgm.bsky.social
Improvement to the #IBMiRPG compile listing to show the complete variable name, rather than just the first few characters.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/12/impr...
Improvement to RPG compile listing
Improvement to the RPG compile listing to show the complete variable name, rather than just the first few characters
www.rpgpgm.com
December 16, 2025 at 11:04 AM
rpgpgm.bsky.social
In #IBMi 7.6 TR1 and 7.5 TR7 three new date formats have been introduced that will make solving 2040 issue easier.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/12/new-...
New date formats for RPG
In IBM i 7.6 TR1 and IBM i 7.5 TR7 three new date formats have been introduced that will make solving 2040 issue easier
www.rpgpgm.com
December 11, 2025 at 11:50 AM
rpgpgm.bsky.social
Create an #IBMiRPG program to change a file’s initial size and to reuse delete records, then remove all deleted records from the file too.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/12/crea...
Create a program to change the size of a file, reuse deleted records, and remove deleted records
Create an RPG program to change a file’s initial size and to reuse delete records, then remove all deleted records from the file too
www.rpgpgm.com
December 4, 2025 at 11:04 AM
rpgpgm.bsky.social
How to remove delete records from all the files in a library using the RGZPFM command in one #SQL statement.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/12/remo...
Remove the deleted records from the file
How to remove delete records from all the files in a library using the RGZPFM command in one SQL statement
www.rpgpgm.com
December 3, 2025 at 11:05 AM