Simon Hutchinson
LightNews LightNews
banner
rpgpgm.bsky.social
Simon Hutchinson
@rpgpgm.bsky.social
45 followers 0 following 220 posts
#IBMiguru, #IBMChampion, #IBMiCommunity advocate, President of
CTXiUG, COMMON SME, John Earle Speaker scholar, COMMON Gold medal speaker, & founder of the renowned website RPGPGM.COM
Posts Replies Media Videos
rpgpgm.bsky.social
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
www.rpgpgm.com/2025/12/crea...
Create a program to change the size of a file, reuse deleted records, and remove deleted records
Create an RPG program to change a file’s initial size and to reuse delete records, then remove all deleted records from the file too
www.rpgpgm.com
December 4, 2025 at 11:04 AM
rpgpgm.bsky.social
How to remove delete records from all the files in a library using the RGZPFM command in one #SQL statement.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/12/remo...
Remove the deleted records from the file
How to remove delete records from all the files in a library using the RGZPFM command in one SQL statement
www.rpgpgm.com
December 3, 2025 at 11:05 AM
rpgpgm.bsky.social
Change the size and whether to reuse delete records of every file in a library with one #SQL statement.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/12/chan...
Change the files' size and reuse deleted records
Change the size and whether to reuse delete records of every file in a library with one SQL statement
www.rpgpgm.com
December 2, 2025 at 11:03 AM
rpgpgm.bsky.social
Creating generic SQL global variables to contain non-specific values for use as parameters in SQL statements.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/11/crea...
Creating generic global variables
Creating generic SQL global variables to contain non-specific values for use as parameters in SQL statements
www.rpgpgm.com
November 26, 2025 at 11:03 AM
rpgpgm.bsky.social
The WRKQRY command has not been working in IBM i 7.6. There is now a PTF to re-enable it.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/11/wrkq...
WRKQRY missing from IBM i 7.6
The WRKQRY command has not been working in IBM i 7.6. There is now a PTF to re-enable it.
www.rpgpgm.com
November 25, 2025 at 12:00 PM
rpgpgm.bsky.social
Download the new version of ACS, 1.1.9.10 from IBM.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/11/new-...
New version of ACS 1.1.9.10
Download the new version of ACS, 1.1.9.10 from IBM
www.rpgpgm.com
November 24, 2025 at 11:03 AM
rpgpgm.bsky.social
PTFs for the Fall Technology Refreshes, IBM i 7.6 TR1 and 7.5 TR7, and now available to download and install on your systems.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/11/fall...
Fall 2025 Technology Refreshes available
PTFs for the Fall Technology Refreshes, IBM i 7.6 TR1 and 7.5 TR7, and now available to download and install on your systems
www.rpgpgm.com
November 21, 2025 at 11:03 AM
rpgpgm.bsky.social
How to retrieve the name of the printer defined in a Query.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/11/retr...
Retrieving the printer name from a Query
How to retrieve the name of the printer defined in a Query
www.rpgpgm.com
November 20, 2025 at 1:08 PM
rpgpgm.bsky.social
It is always pretty cool when your #IBMi idea comes to fruition. This has become ➡️
www.ibm.com/docs/en/i/7....
Which is part of the next TR for #IBMi 7.5 & 7.6.

Thank you #IBM!

#IBMi #rpgpgm #IBMChampion
November 19, 2025 at 4:31 PM
rpgpgm.bsky.social
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 ➡ www.quser.org/content/quse...

I hope to see you there! 😎

#IBMi #rpgpgm #IBMChampion #SupportOurIBMiLUG
QUSER November 2025 | QUSER
www.quser.org
November 17, 2025 at 3:54 PM
rpgpgm.bsky.social
Deleting unwanted journal receivers that are found in QSYS.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/11/dele...
Deleting QAUDJRN's journal receivers if they are in QSYS
Deleting unwanted journal receivers that are found in QSYS
www.rpgpgm.com
November 13, 2025 at 1:23 PM
rpgpgm.bsky.social
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 ➡ www.quser.org/content/quse...

I hope to see you there! 😎

#IBMi #rpgpgm #IBMChampion #SupportOurIBMiLUG
QUSER November 2025 | QUSER
www.quser.org
November 6, 2025 at 2:58 PM
rpgpgm.bsky.social
SQL view, SQLSTATE_CODES, that returns information about every SQL state.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/11/retr...
Retrieve information about SQL state
SQL view, SQLSTATE_CODES, that returns information about every SQL state
www.rpgpgm.com
November 6, 2025 at 11:36 AM
rpgpgm.bsky.social
The events I am involved with this month, includes Central Texas IBM i User Group (CTXiUG), System i Developer's Lunch & Learn, & QUSER.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/11/nove...
November'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
www.rpgpgm.com
November 3, 2025 at 12:36 PM
rpgpgm.bsky.social
Next week, Wednesday November 5, CTXiUG welcomes Gregory Simmons as our guest speaker. He will be talking about becoming a power user with ACS.

This event is FREE & online.
ctxiug.blogspot.com/2025/10/nove...

See y’all there!

#IBMi #IBMChampion #SupportOurIBMLUG #AS400 #iSeries #IBMiLUG
November 2025 meeting
Central Texas IBM i User Group for those in Central Texas (greater Austin and San Antonio areas) interested in the IBM i and PowerSystems
ctxiug.blogspot.com
October 31, 2025 at 11:48 AM
rpgpgm.bsky.social
Overcoming an error extracting data from the Audit Journal, QAUDJRN, and how to delete the old unwanted journal receivers.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/10/dele...
Deleting the journal receivers of QAUDJRN
Overcoming an error extracting data from the Audit Journal, QAUDJRN, and how to delete the old unwanted journal receivers
www.rpgpgm.com
October 30, 2025 at 9:26 AM
rpgpgm.bsky.social
Use SQL to check if there are any certificates in my IBM I partition that are going expire in the near future.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/10/chec...
Checking for expired certificates
Use SQL to check if there are any certificates in my IBM I partition that are going expire in the near future
www.rpgpgm.com
October 23, 2025 at 10:06 AM
rpgpgm.bsky.social
Two free courses from IBM. Read their blog about them =>
community.ibm.com/community/us...

#IBMi #rpgpgm #IBMChampion
Announcing two free IBM i courses: DL06004G and DL06005G
community.ibm.com
October 19, 2025 at 6:25 PM
rpgpgm.bsky.social
Creating database check constraints to move the checking of data from programs and into the database.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/10/addi...
Adding check constraints to your database
Creating database check constraints to move the checking of data from programs and into the database
www.rpgpgm.com
October 16, 2025 at 9:53 AM
rpgpgm.bsky.social
A subfile program to display the top 10 CPU intensive jobs that automatically updates itself.
www.rpgpgm.com/2025/08/how-...

#IBMi #rpgpgm #IBMChampion
How to view the top 10 jobs using the most CPU
A subfile program to display the top 10 CPU intensive jobs that automatically updates itself
www.rpgpgm.com
October 9, 2025 at 3:21 PM
rpgpgm.bsky.social
The Fall 2025 Technology Refreshes, IBM I 7.6 TR1 and 7.5 TR7, have been announced.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/10/fall...
Fall 2025 Technology Refreshes announced
The Fall 2025 Technology Refreshes, IBM I 7.6 TR1 and 7.5 TR7, have been announced
www.rpgpgm.com
October 7, 2025 at 12:28 PM
rpgpgm.bsky.social
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
October 6, 2025 at 11:58 AM
rpgpgm.bsky.social
#IBMi events I am involved in during October.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/10/octo...
October'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
www.rpgpgm.com
October 3, 2025 at 12:14 PM
rpgpgm.bsky.social
Adding database constraints to DDS physical files using SQL and CL commands.
#IBMi #rpgpgm #IBMChampion
www.rpgpgm.com/2025/10/basi...
Basic constraints with DDS files
Adding database constraints to DDS physical files using SQL and CL commands
www.rpgpgm.com
October 2, 2025 at 11:30 AM
rpgpgm.bsky.social
Announcing 9 new (free!) Summit Lunch & Learn sessions for #IBMidevelopers! Bite-sized tips on #RPGLE, AI, #SQL, #Db2fori, #code4i, BI, #IBMi web apps, modernization, & more. Hosted by
Jon Paris, Susan Gantner, Simon Hutchinson, Patrick Behr, & Mike Pavlak

www.systemideveloper.com/pages/events...
Lunch & Learn
www.systemideveloper.com
September 26, 2025 at 12:32 PM