#ibmi — Public Fediverse posts

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

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

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

Обработка ошибок и исключений в 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

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

Create a program to alert if the elapsed CPU total percentage reaches a threshold, you get to set the threshold.

https://www.rpgpgm.com/2026/07/program-to-alert-when-elapsed-cpu.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

New IBM Power server, the smallest with the Power11 chip, has been announced.

https://www.rpgpgm.com/2026/07/new-model-of-ibm-power-announced.html
#IBMi #rpgpgm #IBMChampion

Next week is #OCEANTechCon26 conference. A 2 days event, the Thursday July 23 online, & Friday July 24 in person in Costa Mesa, CA. I will be there on the Friday, & be one of many excellent speakers presenting that day.

This is THE biggest event in the western USA. If you can make it, you will not be disappointed with the information you will learn.

Learn more & register➡️https://oceanconference2026.s3.us-east-1.amazonaws.com/index.html

I hope to see you there.

#IBMi #rpgpgm #IBMChampion #SupportOurIBMiLUG

More information about the IBM Bob Premium Package for i.
https://www.rpgpgm.com/2026/07/more-information-regarding-ibm-bob.html

#IBMi #rpgpgm #IBMChampion

Use SQL to call an API on an external website, and retrieve and format the JSON data from it.

#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/07/using-sql-to-retrieve-information-from.html

Tuesday July 14 @CTXiUG welcomes Gregory Simmons as our speaker. He will be talking about 3 part name in SQL, a fascinating subject.

Meeting is online & free. Learn more => https://ctxiug.blogspot.com/2026/06/july-2026-meeting.html

Looking forward to seeing you there!

#IBMi #AS400 #SupportOurIBMiLug

Retrieve data from the previous row of a file, table, view, etc. using SQL.

#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/06/retrieving-value-of-column-from.html

IBM i Migrate While Active RedBook gives example of how to use the IBM Migrate While Active tool, MWA, to copy your partitions to another system.
#IBMi #rpgpgm #IBMChampion

https://www.rpgpgm.com/2026/06/migrate-while-active-redbook.html

IBM Bob Premium Package for i is announced and released.

#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/06/ibm-bob-premium-package-for-i-released.html

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

Create a program to generate an alert when the percentage of CPU utilization for a job exceeds a given value.
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/06/program-to-alert-when-jobs-cpu.html

Today I was awarded the last badge of the 2026 series: IBM Influencer 2026

Thank you #IBMChampion

#IBMi #rpgpgm

Yesterday was the 13th birthday of RPGPGM.COM, it is 13 years since I wrote my first post for this blog. Wow!
#IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/06/rpgpgmcom-becomes-teenager.html

Calculate the Ordinal date, often called the Julian date, using #SQL.

💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/06/determining-ordinal-date-with-sql.html

I am going to have a busy month in June, making three online presentations to three different countries. I hope to see you at one of them.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2026/06/junes-presentations.html