Lmst

#ibmi

#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

When an unexpected bug happens in #SQL scalar function REGEXP_REPLACE, the TRANSLATION scalar function can be used instead.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/02/using-sql-translate-in-place-of.html

View the results of Fortra’s 2026 #IBMi Market Place Survey.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/02/2026-fortra-survey-published.html

Additional parameters added to the SEND_MESSAGE SQL procedure now allows me to send messages to any message queue.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/02/sendmessage-can-now-send-message-to-any.html

The #IBMi Community Calendar has been updated for this month.

If you are involved with an #IBMi user group and you would like your events added to the calendar, please contact me with its details.

https://ibmicommunity.blogspot.com/

💙 #IBMi #AS400 #SupportOurIBMiLUG

Where I will be presenting this month, February. Come join me.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/02/februarys-presentations.html

End of Support for the small sized IBM Power9 servers happens tomorrow January 31, 2026.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/01/end-of-support-for-small-power9.html

IBM AS/400 and green screen vets: isn't AI code generation and vibe coding basically the new LANSA or SYNON?

#as400 #IBM #LANSA #synon
#AIvibecoding #vibecoding #codegeneration #AIcodegeneration #rpgiii #ibmirpg #ibmi

Examples of how to create JSON data, with and without labels, and then how to consume this data into a RPG data structure array.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/01/better-examples-for-creating-and.html

RPG can now implicitly convert the data types of variables used in certain Built in Functions, BiFs.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/01/rpg-bifs-that-now-convert-ccsid.html

IBM's latest Access Client Solutions, ACS, was released this week as 1.1.9.11.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/01/new-acs-update-11911-fixes-vulnerability.html

Use #SQL to retrieve from all the Querys in a library the files they use into an output file.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2025/12/listing-files-defined-in-querys.html

ALERT: ACS 1.1.9.11 has been released due to CVE-2025-66516. Please update ASAP!

"IBM strongly recommends upgrading to 1.1.9.11, and discontinuing use of versions 1.1.9.8 through 1.1.9.10."
"Fixes will only be provided for the latest update."

https://www.ibm.com/resources/mrs/assets?source=swg-ia

#IBMi #ACS #Security

Next week, Tuesday January 13, 6:30 PM (CT), @CTXiUG welcomes Simon Hutchinson as our guest speaker, and he will be talking about Modern RPG Arrays Features. He is a great speaker & it would be a shame if you miss it. This event is online & FREE➡️
https://ctxiug.blogspot.com/2025/12/january-2026-meeting.html

See y’all there!

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

A new way to list the columns and their values I will be inserting into a SQL table or DDS file with a SQL Insert statement.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/01/a-new-way-to-list-columns-for-sql-insert.html

There were 126 recipients of RPGPGPM.COM-unity ribbons last year! If you see me a conference this year ask me for one, and you will be one of the 2026 inductees.
http://more.rpgpgm.com/rpgpgmcom-unity

💙 #IBMi #rpgpgm #SupportOurIBMiLUG