Mastodawn

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

RPGPGM 5d ago

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

RPGPGM Mar 5

#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

RPGPGM Mar 2

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

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

RPGPGM Feb 26

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

RPGPGM Feb 26

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

RPGPGM Feb 25

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

💙 #IBMi #rpgpgm

RPGPGM Feb 24

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

Add OVRSCOPE to OVERRIDE_INFO | IBM Power Ideas Portal

RPGPGM Feb 23

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

IBM document: IBM i 7.5 vs 7.6 comparison

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 Feb 19

#SQL Table function, PROGRAM_RESOLVED_ACTIVATIONS, that chains which service programs are called by programs and the service programs they call.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/02/find-all-services-programs-used-by.html

Find all the services programs used by a program

SQL Table function, PROGRAM_RESOLVED_ACTIVATIONS, that chains which service programs are called by programs and the service programs they call

RPGPGM.COM - From AS400 to IBM i

About me	https://www.rpgpgm.com/about
Twitter	https://twitter.com/RPGPGM
Facebook	https://www.facebook.com/RPGPGM
LinkedIn	https://www.linkedin.com/in/simonhutchinson3