• 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

• 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 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

• 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 Unveils Fall 2022 Tech Refreshes for IBM i

  October 12, 2022 Alex Woodie

  IBM yesterday announced Technology Refreshes for its two most current IBM i operating systems, including 7.5 and 7.4. Security continues to be a big driver of new functionality with 7.5 TR1 and 7.4 TR7. But the fall TRs bring a bevy of enhancements across all areas, including the database, IBM i services, open source, application development, and analytics, among others.

  Security has been the number one concern for CIOs for a few years now, and IBM has responded with a number of new features in IBM i. Some of the new security features exist in IBM i Navigator, the GUI …

  Read more

• IBM Ships ACS Version 1.1.9.0

  April 13, 2022 Alex Woodie

  IBM this week delivered an update to Access Client Solutions (ACS), the popular Java-based utility that many IBM i professionals use to interact with the platform. IBM is delivering several enhancements with ACS version 1.1.9.0, some of which came through the request for enhancement (RFE) process. It also defaults to opening IBM’s new Navigator for i, rather than the old one, which is susceptible to the Log4j security vulnerability.

  ACS is the universal Java-based utility that IBM unveiled 10 years ago this August to replace older Client Access products, including the ones for Windows, Linux, and Mac. The software, which …

  Read more

• Guru: Debugging SQL Stored Procedures With ACS

  April 11, 2022 Mike Larsen

  I use Access Client Solutions (ACS) daily to help with different tasks. I’m usually running SQL scripts or working with the IFS, but recently I was asked if there was a way to debug SQL stored procedures using ACS. More specifically, they were looking for a way that a “non-IBM i” person can debug SQL stored procedures on IBM i.

  After browsing the various menus in Run SQL Scripts in ACS, I found a system debugger. I had seen the system debugger before, but never took the time to explore it further. With this new request in mind, I decided …

  Read more

• Guru: Keeping Track Of IBM i System Limits

  January 17, 2022 Dawn May

  Every complex system has limits, and computer systems are no different. During my work with clients over the years I’ve seen many shops push their systems as far as they can go until performance breaks down. The limits I encounter are generally numbers of things: How many objects can exist in a library? How many rows can be inserted into a table? How large can a file in the IFS be?

  Typically, these limits are large and you may think you do not need to worry about them, especially after an upgrade. But as the workload on your system …

  Read more

• Guru: Content Assist Plus in Run SQL Scripts

  November 29, 2021 Paul Tuohy

  By now, you should be well aware that Run SQL Scripts provides content assist (promoting) for Select statements (see Guru: ACS 1.1.8.3 Content Assist Includes Prompt For SQL! ). But did you know that you can also use content assist for stored procedures, table functions and parameters? Let’s see how it works, using some of the Integrated File System (IFS) procedures and functions provided by IBM i Services.

  Prompting a Stored Procedure

  Open Run SQL Scripts, type in:

  call qsys2.
  

  Then press F4 (or Ctrl+Space). You will be presented with a list of all the stored procedures in the schema …

  Read more

• IBM Improves Run SQL Scripts with ACS Update

  September 22, 2021 Alex Woodie

  In recent years, Access Client Solutions (ACS) has become an indispensable utility for a range of tasks involving the IBM i. A good reason for that success is the adoption of Run SQL Scripts, which has been enhanced with the latest Technology Refresh for IBM i 7.3 and 7.4.

  ACS is a Java-based product that IBM first unveiled in 2012 and that has replaced other versions of Client Access, including the dedicated Windows utility. No matter what type of computer or device you’re using to work with the IBM i server, be it Windows, Linux, or Mac, you can access …

  Read more

Previous Articles