Simon Hutchinson

Finding Table functions with SYSFUNCS SQL View SYSFUNCS allows me to list all the information about Scalar, Column, and Table functions all from one place

SQL View SYSFUNCS allows me to list all the information about Scalar, Column, and Table functions all from one place.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/03/find...

Retrieving the description for the Audit Journal Entry Types SQL View JOURNAL_CODE_INFO allows me to get a list of all the Audit Journal Entry Types and Journal Codes with just a simple SQL statement

#SQL View JOURNAL_CODE_INFO allows me to get a list of all the Audit Journal Entry Types and Journal Codes with just a simple SQL statement.

#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/03/retr...

March 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

Where I will be presenting this month, March 2026.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/03/marc...

Next @CTXiUG meeting is on Tuesday March 3, 6:30PM(CT), with @RPGPGM talking about Modern Data Structures.
Learn more & register for this free online event➡️ ctxiug.blogspot.com/2026/02/marc...
I hope to see you there.

#IBMi #IBMChampion #SupportOurIBMLUG #AS400 #iSeries #IBMiLUG #rpgpgm

Improvements to GENERATE_SPREADSHEET A number of significant improvements have been made to the GENERATE_SPREADSHEET scalar function

A number of significant improvements have been made to #SQL's GENERATE_SPREADSHEET scalar function.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/02/impr...

#IBMChampion for the 6th year.
Thank you, IBM & the IBM i community! 🙏

#IBMi #rpgpgm

I have just created an IBM Idea to add OVRSCOPE to the results of OVERRIDE_INFO. If you do not know this new #SQL View it is for displaying the active overrides in the current job. Please vote for this.

Thank you

ibm-power-systems.ideas.ibm.com/ideas/IBMI-I...

#IBMi #rpgpgm #IBMChampion

IBM document: IBM i 7.5 vs 7.6 comparison This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of

IBM document: IBM i 7.5 vs 7.6 comparison.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/02/ibm-...

Find all the services programs used by a program SQL Table function, PROGRAM_RESOLVED_ACTIVATIONS, that chains which service programs are called by programs and the service programs they call

#SQL Table function, PROGRAM_RESOLVED_ACTIVATIONS, that chains which service programs are called by programs and the service programs they call.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/02/find...

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

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...

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

View the results of Fortra’s 2026 #IBMi Market Place Survey.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/02/2026...

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

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...

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

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

Where I will be presenting this month, February. Come join me.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/02/febr...

End of support for small Power9 effective tomorrow End of Support for the small sized IBM Power9 servers happens tomorrow January 31, 2026.

End of Support for the small sized IBM Power9 servers happens tomorrow January 31, 2026.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/01/end-...

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

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...

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/

RPG BiFs that now convert CCSID RPG can now implicitly convert the data types of variables used in certain Built in Functions, BiFs

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-...

New ACS update, 1.1.9.11, fixes vulnerability IBM’s latest Access Client Solutions, ACS, has been released as 1.1.9.11

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-...

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

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...

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

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

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

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...

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...

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

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

Where I will be talking during January.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/01/janu...

Happy New Year 2026 to you all Wishing you an Happy 2026, and wondering what the new year will bring to us all.

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...

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

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...

Saving using the ZLIB algorithm Testing the ZLIB compression algorithm with the save commands running on a Power 10 with IBM i 7.5

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...

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

Wishing you a very Merry Christmas from RPGPGM.COM!
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/12/merr...

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

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

Determine if a number is even or odd Using SQL for an easier way to determine if a number is odd or even

Using #SQL for an easier way to determine if a number is odd or even.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/12/dete...