Our client “Bruce” was discussing the RPG talent shortfall and how to get the next generation on board to write and maintain legacy RPG code dating back to the 1980s. Bruce had a System 36 manufacturing application written in fixed-format RPG. The system was solid and users were satisfied. But Bruce knew that he had to modernize the code for ease of maintenance and to expand the developer talent pool for future applications. Bruce knew that he had to modernize the code for ease of maintenance and to expand the developer talent pool for future applications. The Solution Bruce’s team…
The post RPG Trek, The Next Generation appeared first on Seiden Group. Read More
Pivoting with SQL Kent Milligan – IBM Technology Expert Labs
Now that each employee’s deduction has a unique identifier associated with it, the next step is getting those individual deduction column values into a single row for each employee.
The Partition By keyword on the Row_Number specification is what causes the seqnum column (i.e., the unique identifier) value to reset to 1 when it encounters the deductions for a different employee. Read More
Security Bulletin: IBM Db2 Web Query for i is vulnerable to arbitrary code execution due to SnakeYaml [CVE-2022-1471]
SnakeYaml is a YAML Ain’t Markup Language parser used by Db2 Web Query in the underlying WebFOCUS base product. SnakeYaml could allow arbitrary code execution as described in the vulnerability details section. Db2 Web Query has addressed the vulnerability as described in the remediation/fixes section. Read More
Robot | IBM i in 2023: It’s the 35th Anniversary Fortra
True or False: The IBM i operating system is just the AS/400 all over again.
Join IBM i CTO & Chief Architect/IBM Distinguished Engineer Steve Will and IBM Power Champion Tom Huntington to hear their unique perspective on the direction of this platform, including: Read More
Verifying GO RESTORE Option 21 was Successful
This document provides a quick way to verify if GO RESTORE Option 21 was successful. This document is not intended to verify other types of restores. Read More