An updated version of the IBM i technical resource roadmap is now available.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/03/update-to-technical-resources-roadmap.html
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

RPGPGM.COM - From AS400 to IBM i
Using SQL to view system problems

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

RPGPGM.COM - From AS400 to IBM i
Here are the new members of the RPGPGM.COM-unity who joined at WMCPA iCon 2026.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/03/wisconsinites-join-rpgpgmcom-unity.html
Wisconsinites join the RPGPGM.COM-unity

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

RPGPGM.COM - From AS400 to IBM i
Automatically purging the Index Advisor using a Global variable for the time to retain the data.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/03/reducing-amount-of-unnecessary-index.html
Reducing the amount of unnecessary Index Advisor data

Automatically purging the Index Advisor using a Global variable for the time to retain the data

RPGPGM.COM - From AS400 to IBM i
New SQL global variable introduced to help limit the amount of data kept in the SELF error log table.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/03/limiting-amount-of-data-self-retains.html
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

RPGPGM.COM - From AS400 to IBM i

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 ➡️ https://www.neugc.org/attend-neugc
I hope to see you there!

#IBMi #rpgpgm #IBMChampion #SupportOurIBMiLUG

Attend NEUGC | NEUGC

NEUGC
SQL View SYSFUNCS allows me to list all the information about Scalar, Column, and Table functions all from one place.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/03/finding-table-functions-with-sysfuncs.html
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

RPGPGM.COM - From AS400 to IBM i
#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
https://www.rpgpgm.com/2026/03/retrieving-description-for-audit.html
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

RPGPGM.COM - From AS400 to IBM i
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

RPGPGM.COM - From AS400 to IBM i