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

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

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
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➡️ https://ctxiug.blogspot.com/2026/02/march-2026-meeting.html
I hope to see you there.

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

A number of significant improvements have been made to #SQL's GENERATE_SPREADSHEET scalar function.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/02/improvements-to-generatespreadsheet.html
Improvements to GENERATE_SPREADSHEET

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

RPGPGM.COM - From AS400 to IBM i

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.