IBM improves execution of SQL scripts with ACS update
September 22, 2021
In recent years, Access Client Solutions (ACS) has become an indispensable utility for a range of tasks involving IBM i. A good reason for this success is the adoption of Run SQL Scripts, which has been enhanced with the latest technology update for IBM i 7.3 and 7.4.
ACS is a Java-based product that IBM first unveiled in 2012 and which replaced other versions of Client Access, including the dedicated Windows utility. No matter what type of computer or device you use to work with the IBM i server, be it Windows, Linux, or Mac, you can access it with ACS.
The utility includes several essential tools for working in an IBM i environment, including a 5250 emulator, 5250 printer emulation, data transfer capabilities, IFS file viewing, spool file management, and a virtual console for LAN and HMC management. Running SQL scripts is also a popular utility, and ACS is also used to update open source software on IBM i through YUM.
With the September 8 announcements of IBM i 7.3 TR11 and IBM i 7.4 TR5, IBM released ACS version 220.127.116.11. This release brings several improvements to ACS, mainly to run SQL scripts, which allows users to run pre-written SQL code snippets, i.e. SQL scripts.
One of the most significant improvements with Execute SQL Scripts in ACS 18.104.22.168 is the introduction of commit and undo buttons in the toolbar, which we alluded to in our September 13 post. According to IBM i chief architect Steve Will, the new commit and cancel buttons will help prevent users from mistakenly logging off their ACS sessions before making changes.
“In the executed SQL scripts, within the ACS framework, you will now be able to discover – if you notice in the lower right portion of the page – that there is a set of uncommitted changes associated with what you are currently doing in ACS,” , Will said in a COMMON webinar on the new version. “And you can undo what you’ve done so far or validate it. And then again, ACS will tell you it’s been done.
This feature will be particularly useful in light of the expanded role ACS plays in the way developers interact with the system through the execution of SQL scripts and the multitude of SQL services that have become the preferred way of doing things on the server. IBM i. According to Will, the commit and rollback feature will ease the burden of having to remember to commit a change.
“Most people who do this kind of work all the time have to keep a mental track, okay, am I always in the middle of something?” ” he said. “We provide help so that you can visually see and then accomplish the validation restore that you want to perform. “
If a user makes a big mistake and inadvertently leaves a session before committing a change, the Execute SQL Scripts component will catch them before they drop. “We will now display and say” The session has uncommitted changes. Do you want to commit them? ‘ “Said Will. “Of course, we’ll let you decide. We are not forcing you to do anything. We are simply giving you the opportunity to recognize that you are in the middle of something.
These SQL script execution functions have been added at the request of users, who have submitted several Enhancement Requests (RFEs). (If you had any doubts about listening to IBM, then those doubts have been resolved. IBM is listening.)
ACS 22.214.171.124 provides a number of other enhancements, including improved memory management, which will help users who have multiple Execute SQL Scripts windows open. There is also now support for searching the task log and the ability to sync recently used files when there are multiple RSS windows. The download results panel in Execute SQL Scripts now has separate fields for schema and table, as well as a table replacement option, according to IBM.
Several other changes have been made to other ACS components not named Execute SQL Scripts. And again, many of them are motivated by RFEs. For example, it added “back” and “next” buttons to the Journal Viewer in Schemas component of ACS, which was added in a 2017 update. IBM also added “deterministic” and “inline” columns. “to the list of functions in Schemas,” he says.
In the SQL Performance Center component of ACS, IBM added a search function to the main window as well as its “analyze reports” function. New buttons have also been added to give users more display options on the main window, among other changes.
ACS’s Data Transfer component has also been strengthened. With this release, when connecting to an active Excel worksheet, IBM added support for selecting a specific Excel worksheet as an output or input device.
A variety of fixes were also provided with this release, according to IBM’s Wiki for ACS, which also included some special notes. One of these notes is for users who want to launch the new IBM Browser for IBM i from ACS (a few PTFs are required). The other is for Mac users who want to apply this update on ACS version 126.96.36.199 or earlier.
ACS version 188.8.131.52 requires Java 11 or later. It is available for download here, or it can be obtained by installing the latest HTTP PTF group. For more information, see www.ibm.com/support/pages/ibm-i-access-acs-updates.
Surprise! It’s time to refresh IBM i technology
IBM deploys ACS 184.108.40.206
IBM strengthens ACS with database and administrative benefits (ACS 220.127.116.11)
IBM Delivers New Benefits with ACS Update (ACS 18.104.22.168)
ACS getting new database schema functions