Mastodawn

RPGPGM 1d ago

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

Track Group PTFs with SQL

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

RPGPGM.COM - From AS400 to IBM i

RPGPGM 2d ago

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

RPGPGM 3d ago

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

New Englanders flock to join the RPGPGM.COM-unity

New Englanders join the RPGPGM.COM-unity at the NEUGC conference in 2026

RPGPGM.COM - From AS400 to IBM i

RPGPGM Apr 9

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

New Job columns added to the Record Lock View

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

RPGPGM.COM - From AS400 to IBM i

RPGPGM Apr 8

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

New columns added to the Object Lock View

Addition of new columns to the OBJECT_LOCK_INFO View makes finding locks by user profile or jobs easier

RPGPGM.COM - From AS400 to IBM i

RPGPGM Apr 2

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

Viewing the job's overrides

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

RPGPGM.COM - From AS400 to IBM i

RPGPGM Mar 27

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

RPGPGM Mar 26

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

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

RPGPGM Mar 25

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

RPGPGM Mar 19

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