• 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

• IBM i PTF Guide, Volume 26, Number 15

  April 15, 2024 Doug Bidwell

  Hey, this is interesting. We have no security vulnerabilities to report on this week for the IBM i platform. And this is also interesting. There is a new version of Access Client Solutions, called V1.1.9.5. We will be putting together a news story to talk about this, but in the meantime, we thought you should know that it is out. There ain’t a lot else going on, as you will see.

  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.5
  • QMGTOOLS

  PTF Groups 7.4: …

  Read more

• IBM Patches New Security Vulns In IBM i Components, Power Firmware

  February 12, 2024 Alex Woodie

  IBM has patched a series of moderate security vulnerabilities in IBM i products and Power firmware over the past two weeks. The IBM i flaws span Rational Developer for i (RDi), Access Client Solutions (ACS), and the Java development kit and runtime, while the Power flaw involves PowerVM and its communications with the Hardware Management Console (HMC).

  Concerns over security hit an all-time high in the IBM i community according to the IBM i Marketplace 2024 study conducted by Fortra. The survey found that 79 percent of IBM i professionals considered security a top concern, a 10 percent increase …

  Read more

• ACS, Merlin Hit With Serious Security Vulnerabilities

  December 11, 2023 Alex Woodie

  Three serious security vulnerabilities in IBM i Access Client Solutions and six in Merlin were disclosed and patched by IBM last week. The flaws could allow attackers to commit a range of crimes, from executing arbitrary code and denial of service attacks, to obtaining sensitive data on IBM i conducting phishing attacks. All of the flaws – including another three reported by IBM in November – should be patched immediately.

  IBM published a security bulletin December 8 covering all three of the ACS flaws, which impact ACS versions 1.1.2 through 1.1.4 and 1.1.4.3 through 1.1.9.3. The fix is to download …

  Read more

• IBM i PTF Guide, Volume 25, Number 50

  December 11, 2023 Doug Bidwell

  Well, there are two new security vulnerabilities in the IBM i stack, as we report elsewhere in this issue of The Four Hundred. And there is also an update to the System Planning Tool. Let’s do the latter first and the former last.

  The System Planning Tool, version 6.23.340, is now available for download at this link. The System Planning Tool is used by customers and business partners to build valid system configurations for Power Systems machines and their software stacks. You can look at the release notes for various SPT generations here.

  Now on to the …

  Read more

• New Run SQL Scripts Features in ACS Update

  August 23, 2023 Alex Woodie

  If you’re a fan of the Run SQL Scripts features in IBM i Access Client Solutions, then there’s good news: IBM has adopted several suggestions on how to improve the functionality in the latest release of ACS.

  IBM quietly released ACS version 1.1.9.3 last month, enabling a series of new functions in the popular Java-based utility used by IBM i professionals to interact with the platform, as well as a handful of fixes.

  At the top of the list, according to an IBM Support document on the new release, are enhancements to Run SQL Scripts (RSS), the handy facility that …

  Read more

• IBM i PTF Guide, Volume 25, Number 32

  August 7, 2023 Doug Bidwell

  Here is what is new: A new “version” of Access Client Solutions (ACS) is available for download, catch the link in the Guide. (Your “Check for Update” won’t catch it, and you won’t see the version until you get all the way into the ACS Main window, and do the Help/About.) This is an updated version, no change to the ODBC driver. This version of ACS uses the IBM GSKit version 8.0.55.31 with the latest security updates.

  This is important: Prior versions of ACS have security defects. Specifically, Security Bulletin: IBM i Access Client Solutions – Windows Application Package is …

  Read more

• Guru: Binding Directory Entries

  June 5, 2023 Bob Cozzi

  I assume you’ve heard about *BNDDIR (Binding Directory) objects introduced circa 1994 with OS/400 V3R2. The infamous QC2LE binding directory is used by a huge number of RPG applications to access C runtime and unblocked MI functions such as system cvthc, cpybytes, and matmatr. You have probably seen RPG IV source code with the BNDDIR(‘QC2LE’) keyword on the header specification.

  I was one of the first developers outside of IBM to use Binding Directories for my own code. When I go back and look at my own RPG IV code created prior to mid-2007, well over 90 percent of it …

  Read more

• How IBM Improved Application Development with the Spring 2023 TRs

  April 19, 2023 Alex Woodie

  IBM i developers have a few exciting new features to look forward to with the latest Technology Refreshes for IBM i 7.5 and 7.4, including a new release of RDi and new RPG and COBOL functions in the compilers.

  As part of the Spring 2023 announcement for IBM i 7.5 TR2 and 7.4 TR8, IBM last week unveiled a new release of Rational Developer for i (RDi), version 9.8, that brings new functionality to the Eclipse-based integrated development environment (IDE).

  According to IBM’s announcement letter, RDi RPG and COBOL Tools Edition runs on

  One of the new features with …

  Read more

• IBM Welcomes COMMON Advisory Councils to Rochester

  December 7, 2022 Alex Woodie

  One of the hallmarks of a good company is listening to customers. A company may not do everything that its customers wish, but it must show that it’s listening to maintain the relationship. This dynamic was in play during an IBM i meeting that took place last month in Rochester, Minnesota, between IBM and the advisory councils for both COMMON North America and COMMON Europe.

  The three-day meeting that took place November 14 through 16 involved a handful of members from the COMMON Americas Advisory Council (CAAC) as well as the COMMON Europe Advisory Council (CEAC). Both advisory councils had …

  Read more

Previous Articles Next Articles