Viewing the job's overrides SQL View OVERRIDE_INFO gives a list of all the file overrides for the current job

SQL View OVERRIDE_INFO gives a list of all the file overrides for the current job.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/04/view...

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

An updated version of the IBM i technical resource roadmap is now available.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/03/upda...

Using SQL to view system problems Work with your system’s problems using the PROBLEM_INFO SQL View

Work with your system's problems using the PROBLEM_INFO #SQL View.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/03/usin...

Wisconsinites join the RPGPGM.COM-unity New members of the RPGPGM.COM-unity who joined at WMCPA iCon 2026

Here are the new members of the RPGPGM.COM-unity who joined at WMCPA iCon 2026.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/03/wisc...

Reducing the amount of unnecessary Index Advisor data Automatically purging the Index Advisor using a Global variable for the time to retain the data

Automatically purging the Index Advisor using a Global variable for the time to retain the data.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/03/redu...

Limiting the amount of data SELF retains New SQL global variable introduced to help limit the amount of data kept in the SELF error log table

New SQL global variable introduced to help limit the amount of data kept in the SELF error log table.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2026/03/limi...

Attend NEUGC | NEUGC

I will be at @NEUGC in 2 weeks for their annual conference, April 7-9. I will be talking about many things #IBMiRPG & #SQL, including a 2+ hour session discussing SQL Views.
Check out all the sessions & register at ➡️ www.neugc.org/attend-neugc
I hope to see you there!

#IBMi #rpgpgm #IBMChampion

The "Big Blue" just got a strategic injection of Pink. 🎀

Officially stepping in as a 2026 IBM Champion.

My mandate: Bridge heavy enterprise reliability with zero-friction Cloud-Native velocity. We’re taking DevOps.Pink to the core.

Deploy like a queen. 👑

#IBMChampion #DevOps

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

Delighted and excited to be a part of the Ireland India Council celebration of #InternationalWomensDay with Carmel Wynne and Aparna Shukla. Many thanks for including me in such a great interview. #WomenInIT #IBMChampion

LLMs are a tool (I refuse to use the term A”I”), absolutely.

Yeah I’m in the IBM ecosystem & an #IBMChampion, but I’ve seen a lot of good feedback Project Bob. Even a senior IBM dev started using it to generate missing error message doc and it’s done a good job. It’s been shared with me.

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

I'm proud to share that I'm an #IBM #champion this year again. This is my 5th year as an #IBMChampion for #POWER. It's not the most recent photo of me, but probably the most appropriate one due to the logo :-)

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

Thank you #IBM for recognizing me as #IBMChampion in 2026 - 5th year in a row.

I will continue my efforts for making #IBMi even better and more accessible in CEAC, the Code for IBM i team and my website www.ibmi4ever.com.

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

#IBMi #rpgpgm

Add OVRSCOPE to OVERRIDE_INFO | IBM Power Ideas Portal

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

POWER Is Not Just for Databases The IBM POWER architecture is not just for database servers. While most people know it only for DB2 and SAP HANA, it is an ideal platform also for HPC or other high performance server applications, li...

I still do not know if I'll be #IBMChampion this year, but I keep talking about #IBM #Power anyway :-) Based on today's discussions, I better share this blog again: peter.czanik.hu/posts/power-...

#IBMPower #Power #Power11

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

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

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