• Guru: Creating An RPG Stored Procedure With Parameters

  January 20, 2025 Mike Larsen

  There are times we need to build processes that will be used across different platforms. An example is a pricing routine. When a system needs to get pricing, we need to make sure the price the customer pays is the same regardless of how the order was created in our system.

  One way to create this functionality is using web services. Another way we can provide this functionality is through stored procedures. This series of tips will focus on different ways we can build stored procedures on IBM i.

  For the first part, I created an RPG program (Figure 1) …

  Read more

• What’s New on PHP? Seiden Delivers the Goods

  October 23, 2024 Alex Woodie

  PHP has been around so long on the IBM i server that it’s practically a legacy technology at this point (not that that’s a bad thing). But if you haven’t looked at PHP lately, you might be surprised at what’s going on with the newer releases. PHP guru Alan Seiden recently brought us up to speed with the Web development language with a webinar sponsored by TUG.

  Seiden has been involved with PHP on IBM i for about 20 years. He was playing around with the open source language even before IBM and Zend worked together to bring the first …

  Read more

• Surprise! It’s 2024 Fall TR Time for IBM i

  October 9, 2024 Alex Woodie

  IBM announced the Technology Refreshes (TRs) for IBM i version 7.5 and 7.4 yesterday, bringing a host of new capabilities to the proprietary operating system. As expected, the surprise update covers a range of IBM i facilities, including Db2, Navigator, ACS, PowerHA, and the development tools.

  Navigator gets several more enhancements with the new TRs, including: a new dashboard with software licensing information; Web-based administration of network facilities; support for monitoring of Java 11 and Java 17 jobs; enhancements to the Performance Data Investigator (PDI); and new options for working with audit journals, among other capabilities.

  IBM also includes the …

  Read more

• IBM i PTF Guide, Volume 26, Number 38

  October 7, 2024 Doug Bidwell

  There is a hodge podge of stuff that you need to deal with this week when it comes to patching your IBM i system.

  First, there is a security vulnerability. Read all about it in Security Bulletin: Vulnerability in Node.js affects IBM Rational Developer for i RPG and COBOL + Modernization Tools, Java Edition (CVE-2024-36138), which you can find out more about at this link. The issue can be fixed by loading an interim fix. IBM strongly recommends addressing the vulnerability now by upgrading to Node.js 18.20.4. Please follow Upgrading the Node.js that is used by Cordova or NodeRed …

  Read more

• IBM Bolsters Run SQL Scripts In ACS 1.1.9.6

  August 12, 2024 Alex Woodie

  IBM last week shipped a new release of Access Client Solutions (ACS) that contains several user-requested updates for Run SQL Scripts (RSS), the popular tool that allows users to execute SQL statements. ACS 1.1.9.6 also brings enhancements to the data transfer, IFS, and 5250 emulator components of ACS, among others.

  ACS, of course, is the universal Java-based utility that IBM unveiled 12 years ago to replace Client Access. It’s a must-have tool for any IBM i user, as it contains a slew of facilities for interacting with the system, including RSS, data transfer, IFS file viewing, spool file management, 5250 …

  Read more

• IBM i PTF Guide, Volume 26, Number 31

  August 12, 2024 Doug Bidwell

  As we report elsewhere in this issue, the big news this week in IBM Software Land is a new release of Access Client Solutions, which is rolled out as a PTF update for the currently supported releases of the IBM i operating system. Our story is here, and the release notes are there.

  We did not see any new security vulnerabilities, which is always good news.

  Here is the rundown of PTF Groups by IBM i release level since we last published:

  PTF Groups 7.5:

  • IBM i Access Client Solutions V1.1.9.6
  • SAP Support Required PTF List for IBM

  …

  Read more

• Spring 2024 IBM i Technology Refresh Unveiled by IBM

  May 8, 2024 Alex Woodie

  IBM today took the wraps off the latest Technology Refresh for the IBM i platform. When IBM i 7.5 TR4 and 7.4 TR10 ship on June 14, customers will find enhancements such as Merlin version 2, new features in Navigator and ACS, security improvements, a couple of RPG enhancements, HA and DR enhancements, and a host of new SQL-based database services, among other capabilities.

  In addition to new features, which we’ll get to in a second, the launch of IBM i 7.5 TR4 and 7.4 TR10 is important for an unexpected reason: It will mark the beginning of IBM’s transition …

  Read more

• April Showers Bring May IBM i Security Vulnerabilities

  May 8, 2024 Alex Woodie

  IBM has patched more than a dozen security flaws in IBM i and related products this spring, including serious flaws in the operating system proper and the compilers, and a critical vulnerability in Administrative Runtime Expert that landed a nearly perfect CVSS Base score.

  In the interest of time, let’s cover the security vulnerabilities in descending order of severity. That means we’re starting with the worst and then moving on to the slightly less worse.

  ARE Flaw

  The flaw reported in the Administration Runtime Expert for i (ARE), which IBM launched in 2010 to make it easier to manage IBM …

  Read more

• IBM Cranks Up the Performance for Run SQL Scripts

  April 24, 2024 Alex Woodie

  Access Client Solutions (ACS) users who are tired of waiting for database fields to resolve in the Run SQL Scripts (RSS) facility will be happy to hear that IBM felt their pain and RSS will return data much more quickly to return data with ACS version 1.1.9.5, which IBM shipped earlier this month.

  The speed-up of field resolution time was listed as a concern to at least one IBM i user, who took to IBM Power Ideas Portal to voice his or her concern. “Simply put the resolution of potential field makes content assist almost unusable,” the user wrote. “I …

  Read more

• Guru: Fooling Around With SQL And RPG

  April 15, 2024 Gregory Simmons

  Editor’s Note: This was originally scheduled to be published on April 1. No joke. And for a lot of complex reasons, that could not happen. But, it’s still fun, so enjoy.

  I started out one morning, purely interested in having a bit of fun. Honest. In RSS within ACS, I often like to run this SQL:

   select *
   from json_table(
        QSYS2.HTTP_GET('https://icanhazdadjoke.com/',
                '{"header": "Accept,application/json", "sslTolerate":"true"}'),
                'lax $' columns ("joke" varchar(200) CCSID 1208)
        )
  

  

  Okay, that was fun. This is harmless, good fun. But then I thought, what if I put this into a simple RPG program? Then I …

  Read more

Previous Articles Next Articles