#rpgpgm — Public Fediverse posts

Using the IBM command GENCMDDOC to create help panel groups and HTML for my commands.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/05/generating-help-text-using-ibm-i-command.html

The RPGPGM.COM-unity continues to grow as I handed out more ribbons at COMMON PowerUp to people who were eager to join.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/05/powerup-attendees-rally-to-join.html

Getting the individual values from a list parameter passed to a #IBMiRPG program from a IBMi command.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/05/determining-number-of-entries-in-list.html

Presentations I will be making this month, May.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/05/may-presentations.html

Discovering if you are falling behind with your IBM i group PTFs by using a Db2 for i (SQL) View.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/04/checking-if-there-are-updates-for-your.html

Checking the status of the Electronic Service Agent, ESA, using CL command and SQL View. Giving an example program of how to monitor is the ESA fails.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/04/checking-electronic-service-agent.html

A new version of ACS, 1.1.9.12, has been made available for download.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/04/acs-version-11912-available.html

Retrieving information about group PTFs, their status and when they were applied, using the SQL View GROUP_PTF_INFO.

#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/04/track-group-ptfs-with-sql.html

Today another milestone was reached for RPGPGM.COM… its 1,100 post!

Thank you to all you readers, & especially those who give me feedback.

#IBMi #rpgpgm #IBMChampion

I handed out more ribbons at the @NEUGC conference last week. Check the newest members of the RPGPGM.COM-unity.
I'll be at @COMMONug #PowerUp2026, if you are there ask me for a ribbon & join the community.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/04/new-englanders-flock-to-join-rpgpgmcom.html

Three new columns have been added to the RECORD_LOCK_VIEW that split out the job user, job name, and job number into their own columns.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/04/new-job-columns-added-to-record-lock.html

Addition of new columns to the OBJECT_LOCK_INFO View makes finding locks by user profile or jobs easier.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/04/new-columns-added-to-object-lock-view.html

SQL View OVERRIDE_INFO gives a list of all the file overrides for the current job.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/04/viewing-jobs-overrides.html

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

Work with your system's problems using the PROBLEM_INFO #SQL View.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/03/using-sql-to-view-system-problems.html

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

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

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

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

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

#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

Where I will be presenting this month, March 2026.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/03/march-presentations.html

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

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

💙 #IBMi #rpgpgm

I have just created an IBM Idea, for IBM i, to add a column for 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

https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-4821

💙 #IBMi #rpgpgm #IBMChampion

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

Improvement to the #IBMiRPG compile listing to show the complete variable name, rather than just the first few characters.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2025/12/improvement-to-rpg-compile-listing.html

Create an #IBMiRPG program to change a file’s initial size and to reuse delete records, then remove all deleted records from the file too.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2025/12/create-program-to-change-size-of-file.html

Tomorrow, Tuesday November 18 at 2:00 PM (CT), I am talking to @quser, for 2+ hours about getting the most from #SQL with your #IBMiRPG.

All are welcome. Register at ➡ https://www.quser.org/content/quser-november-2025

I hope to see you there! 😎

💙 #IBMi #rpgpgm #IBMChampion #SupportOurIBMiLUG

On Tuesday November 18 at 2:00 PM (CT) I am talking to @quser, giving two hours about getting the most from #SQL with your #IBMiRPG.

All are welcome. Register at ➡ https://www.quser.org/content/quser-november-2025

I hope to see you there! 😎

💙 #IBMi #rpgpgm #IBMChampion #SupportOurIBMiLUG

Wow! I was not expecting this mention at TechXchange! 😮

Thanks to Jeff Yanoviak for sharing this.

(As of my last report to IBM Champions I have written 70 posts in 2025)
#IBMi #rpgpgm #IBMChampion #TechXchange

How to increment numbers of various sizes that are held in a character field in #IBMiRPG.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2025/05/increment-number-held-in-character-field.html