#ibmi — Public Fediverse posts

The latest, August 2026, IBM i roadmap from IBM.

https://www.rpgpgm.com/2026/10/latest-ibm-i-roadmap.html

#IBMi #rpgpgm #IBMChampion

Three IBM critical vulnerabilities, rated up to CVSS 9.9, hit IBM i, Db2 Mirror and Maximo AI Service, including remote code execution. Patch now.

#IBM #IBMi #Maximo #Db2 #CVE202696119 #CVE202696012 #CVE202690920 #RemoteCodeExecution #CyberSecurity

https://securityonline.info/ibm-critical-vulnerabilities-ibm-i-db2-maximo/?utm_source=mastodon&utm_medium=jetpack_social

Tuesday, November 11, 6:30 PM CT, we welcome Simon Hutchinson (@rpgpgm) for 2 presentations:
- Designing your own commands
- Using #SQL triggers to track file changes on #IBMi

Register➡️https://ctxiug.blogspot.com/2026/10/november-meeting.html

#SupportOurIBMiLUG

I was looking at the list of companies who are sending people to IBM TechXchange 2026, and who do I find?

If you are going to be there, and you see me please say "Hi". There could be a ribbon in your future 😉

#IBMi #rpgpgm #IBMChampion

Copy a JSON array from a CLOB to the IFS, and directly copy from IBM i file directly to IFS file as JSON.

https://www.rpgpgm.com/2026/08/copying-json-in-clob-to-ifs-file.html

#IBMi #rpgpgm #IBMChampion

Do you remember using the RPG Debugging Template with old versions of the RPG programming language?

https://www.rpgpgm.com/2026/10/who-remembers-rpg-debugging-template.html

#IBMi #rpgpgm #IBMChampion

What I will be doing in October.

https://www.rpgpgm.com/2026/10/what-i-am-doing-in-october.html

#IBMi #rpgpgm #IBMChampion

End of Standard Support for #IBMi 7.4 is today.

https://www.rpgpgm.com/2026/09/end-of-support-for-ibm-i-74.html

#IBMi #rpgpgm #IBMChampion

CL versus #SQL: Which is better for creating a list of users with *ALLOBJ authority?

https://www.rpgpgm.com/2026/07/making-list-of-users-with-allobj.html

#IBMi #rpgpgm #IBMChampion

Control how the cursor progresses from one field to another in a subfile when the tab key is pressed.

https://www.rpgpgm.com/2026/09/controlling-action-of-cursor-in-subfile.html

#IBMi #rpgpgm #IBMChampion

Creating a CL program to copy a million records at a time to an IFS file, that can then be sent to another system without error.

https://www.rpgpgm.com/2026/09/chopping-up-file-that-is-too-big.html

#IBMi #rpgpgm #IBMChampion

New version of IBM's Access Client Solutions, ACS, 1.1.9.16, is available for download and installation.

https://www.rpgpgm.com/acs

#IBMi #rpgpgm #IBMChampion

Using Db2 for i scalar functions and table function to extract the job name, number, and user from the qualified job name.

https://www.rpgpgm.com/2026/09/separating-parts-of-qualified-job-name.html

#IBMi #rpgpgm #IBMChampion

Using the Db2 for i (SQL) scalar function CHECK_COMMAND_SYNTAX to validate a command string.

https://www.rpgpgm.com/2026/09/validating-cl-commands-with-sql.html

#IBMi #rpgpgm #IBMChampion

Events in September 2026 I am involved with.

https://www.rpgpgm.com/2026/09/septembers-presentations.html

#IBMi #rpgpgm #IBMChampion

If you're interested in hobbyist #IBM i (née System i / AS/400) hardware and installation, this is a great watch: https://youtu.be/mUwJk81YatA

Check out the rest of clabretro's channel too - lots of #retrocomputing content, focussing on 90s/early 2000 enterprise hardware and software.

#IBMi #retrocomputing #as400 #IBMPower #powerpc

Data journal readers are a better way to retrieve information from journals.

https://www.rpgpgm.com/2026/08/creating-and-using-data-journal-reader.html

#IBMi #rpgpgm #IBMChampion

New version of IBM's Access Client Solutions, ACS, 1.1.9.15, is available for download and installation.

https://www.rpgpgm.com/2026/08/acs-11915-available-now.html

#IBMi #rpgpgm #IBMChampion

IBM Redbook about modernizing your IBM i applications from the database to the front-end has been published.

https://www.rpgpgm.com/2026/08/ibm-redbook-covers-modernization-in.html

#IBMi #rpgpgm #IBMChampion

On Tuesday, Sept 8 at 6:30 PM CT, CTXiUG welcomes Marina Schwenk for:

“Modern RPG What Does That Mean?”

Come learn what modern RPG really means and how you should be using it today!

Online meeting, everyone is welcome.
https://ctxiug.blogspot.com/2026/08/september-2026-meeting.html

#IBMi #rpgpgm #IBMChampion

Example program showing how to convert RPG packed, zoned, and integer number types to a hexadecimal value, and then back again using SQL.

https://www.rpgpgm.com/2026/08/convert-number-to-hexadecimal-with-sql.html

#IBMi #rpgpgm #IBMChampion

IBM patches an IBM Db2 Mirror RCE flaw, CVE-2026-17186, rated CVSS 9.9, plus 17 more bugs in Db2 Mirror for i. Patch now.

#IBM #Db2Mirror #IBMi #RCE #CVE #CyberSecurity #Vulnerability #InfoSec

https://securityonline.info/ibm-db2-mirror-rce-cve-2026-17186/?utm_source=mastodon&utm_medium=jetpack_social

If you are using #SQL SELF are you aware of this? It will save you having to purge the file yourself.

https://www.rpgpgm.com/2026/03/limiting-amount-of-data-self-retains.html

#IBMi #rpgpgm #IBMChampion

IBM i でsshほかTCP/IPサーバージョブ（デーモン）を開始する方法
https://qiita.com/gomAnomalocaris/items/5554003e62ce3a51ef9e?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #IBMi

New version of IBM ACS, 1.1.9.14, fixes a number of security vulnerabilities is now available to download.

https://www.rpgpgm.com/2026/08/acs-release-11914-out-now.html

#IBMi #rpgpgm #IBMChampion

PowerVS IBM i 日記(111): PowerVS上でのPower9のEOLが発表-2027年12月31日
https://qiita.com/6onoda/items/1471950a0270046de95a?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #IBM #IBMi #ibmcloud #IBM_Cloud #powervs

Обработка ошибок и исключений в RPG на IBM i

Продолжение цикла статей "что такое RPG и как с ним работать. Предыдущие статьи Современный RPG — что может и зачем нужен Способы работы с БД DB2 в языке RPG на платформе IBM i

https://habr.com/ru/articles/903516/

#ibmi #rpg #rpgle #исключения #ошибки

Change to QCMDEXC #SQL scalar function that enables a job log entry that list the actual command performed and whether it was successful.

https://www.rpgpgm.com/2026/08/qcmdexc-scalar-function-can-write-to.html

#IBMi #rpgpgm #IBMChampion

Copying data from a pipe delimited file in the IFS to columns in a Db2 Table.

https://www.rpgpgm.com/2026/08/handling-pipe-separated-data-into-db2.html
#IBMi #rpgpgm #IBMChampion

The RPGPGM.COM-unity continues to grow with these people, from the west coast of the USA, becoming the latest members.

https://www.rpgpgm.com/2026/07/rpgpgmcom-unity-on-west-coast.html

#IBMi #rpgpgm #IBMChampion

Find CVE, Common Vulnerabilities and Exposures, information by the release of IBM i by using a simple #SQL statement.

https://www.rpgpgm.com/2026/07/it-is-now-so-easy-to-view-cve-using-sql.html
#IBMi #rpgpgm #IBMChampion

IBM Bob Premium Package for i のライセンス適用
https://qiita.com/sugata/items/31b62ccf520a08f49077?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #IBMi #IBMBob

The PTFs for IBM i 7.6 TR2 and 7.5 TR8 are released today, Friday July 24 2026.

https://www.rpgpgm.com/2026/07/first-technology-refreshes-of-2026.html
#IBMi #rpgpgm #IBMChampion

Yesterday #IBM made several #POWER related announcements. Most of those are related to #IBMi (~AS/400), #AI, automation and #COBOL. There is great news for #Linux users too: IBM Power S1112 brings #Power11 technology to an entry-level systems.

https://community.ibm.com/community/user/blogs/brandon-pederson1/2026/07/07/ibm-power-advancing-autonomous-it-ai-ready-infrast

IBM Bob Premium Package for i — スキル・ツール・ワークフロー ガイド (2026/7版)
https://qiita.com/amogi23/items/1cc98872465621dc55b6?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #IBMi #IBMBob

Yesterday was the 38th anniversary of the AS/400, the ancestor of the modern IBM Power servers and IBM i operating system.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/06/another-anniversary-for-ibm-i-and-ibm.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

#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

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

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

Wishing you a very Merry Christmas from RPGPGM.COM!
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2025/12/merry-christmas-to-everyone.html

Using #SQL for an easier way to determine if a number is odd or even.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2025/12/determine-if-number-is-even-or-odd.html

In #IBMi 7.6 TR1 and 7.5 TR7 three new date formats have been introduced that will make solving 2040 issue easier.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2025/12/new-date-formats-for-rpg.html

How to remove delete records from all the files in a library using the RGZPFM command in one #SQL statement.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2025/12/remove-deleted-records-from-file.html

Change the size and whether to reuse delete records of every file in a library with one #SQL statement.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2025/12/change-files-size-and-reuse-deleted.html

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

🚨 HIGH severity: CVE-2025-36367 affects IBM i 7.2–7.6. Missing SQL services authorization lets low-priv users escalate to root. Restrict access, audit privileges, monitor closely. Patch pending. https://radar.offseq.com/threat/cve-2025-36367-cwe-862-missing-authorization-6422a3cf #OffSeq #IBMi #CVE2025_36367 #PrivilegeEscalation #Security