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

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

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

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

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

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