• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • IBM Bolsters ACS with Database and Administrative Goodies

    May 15, 2019 Alex Woodie

    Amid the many enhancements that IBM has delivered with IBM i 7.4 and IBM i 7.3 TR6 is a new release of Access Client Solutions (ACS), which has become the go-to client interface that many IBM i professionals use to access the system for a variety of tasks. Database engineers and system administrators are the big winners with this release.

    There’s no denying that IBM delivered a whopper of release with IBM i 7.4 and its sidekick, IBM i 7.3 TR6. There’s been so much news – starting with the availability and security enhancements in Db2 Mirror and Authority Collection enhancements – to keep the IT Jungle news team busy that we haven’t gotten to ACS version 1.1.8.2. Until now, that is.

    ACS, in case you forgot, is IBM’s strategic desktop client for accessing IBM i. The Java-based product, which IBM unveiled in August 2012, brings several handy components, 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.

    Getting up to speed on ACS is even more important now that IBM i Access for Windows was withdrawn from marketing on April 30. So let’s go through the enhancements in ACS version 1.1.8.2 by functional area, starting with Run SQL Scripts, enables users execute SQL queries against Db2 for i, and which is one of ACS’s most popular functions.

    For starters, users can now open and save SQL scripts to the IFS and stream files, which IBM says “extends the options for how scripts are maintained and used.” The software will also remember which database you prefer to work with and retain iASP connections, both of which will save time.

    IBM provides a host of example SQL scripts that workers can use with the software. From this point forward, IBM will include any new SQL examples with its “insert from examples” functionality. Getting the SQL syntax perfect will also be easier thanks to a new design in the Formatter portion that “enables it to understand SQL syntax,” IBM says. If there is a problem with the SQL syntax, the new Formatter will highlight the error, including the line number and the issue.

    Authorized users can also now access and update data values in Db2 for i fields directly from within the Run SQL Scripts interface, a powerful feature that could be a real timesaver — or a security liability if not properly secured. Lastly, in the JDBC Connection dialog, IBM is including the capability to assign alternate server names and other attributes.

    ACS has printer emulation, allowing users to print directly from ACS. Normally, the printed output contains the system name. With version 1.1.8.2, administrators are given the option of removing the system name on printed output download path, providing for a cleaner look.

    In addition to the IFS-related Run SQL Scripts function mentioned above, IBM included two other IFS updates with this release. For starters, when downloading a new copy of IFS to a computer (PC, MacOS, Linux, or any JVM-compatible system), the software will prompt the user with the location of the current IFS download location on the target PC.

    Secondly, when querying data stored in the IFS via ACS, IBM is now including an “include” filter, which it says will “improve performance by limiting the data returned from the server when viewing directories with a large number of files.”

    In addition to system administrators, ACS is used by database engineers. One new feature in ACS that will appeal to database engineers is the ability to copy and paste database schemas when creating a new project.

    There is also big enhancement to the ODBC Driver that’s included with ACS: IBM has ported the IBM i Access ODBC driver. IBM says this will allow any standard ODBC client to be able to communicate to the local database on IBM i. It also says that this will allow any application to be developed using the IBM i Access ODBC driver for Windows or Linux and deployed to IBM i using the same ODBC driver.

    There are various general enhancements with ACS’ system configuration, including several shortcuts that will save time and keystrokes.

    First, the System Configuration screen can be set as the primary location for launching ACS activities. IBM has also included keyboard shortcuts to menu options, which should bolster the experience for keyboard-loving users. The mouse-loving folk will be pleased to hear that they can pull up a menu of contextual options by right-clicking the System Configuration panel.

    The Hardware Management Interface received a few new features. IBM says that a customized list of possible interfaces has been added to the screen. It’s also now possible to specify more than two options, IBM says. The information shown on the main ACS panel will also reflect the configured Hardware Management Interface for the selected system, IBM says.

    Various other administrative enhancements were made with this release, including the capability to exclude ACS components when importing an ACS configuration to a target machines. Also, when importing an existing ACS configuration, it’s no longer necessary to have a user profile associated with that configuration preloaded on the target.

    ACS has also been updated to reflect the set of data and time services that supports the new Japanese era that started May 1. The old era was Heisei, and the new era is Reiwa.

    Finally, IBM made improvements to how users find and download ACS via the Entitled System Support (ESS) delivery method. From now on, feature 6290 will be automatically defaulted for users who are downloading ACS from the ESS website. Feature 6290 becomes viable on June 11.

    RELATED STORIES

    IBM Delivers New Goodies with ACS Update

    IBM Bolsters RPG And COBOL Development

    How IBM i 7.4 Improves Security

    IBM Brings Active-Active Mirroring Into Db2 For i Database

    IBM i 7.4 Rolled Out, And IBM i 7.3 Tech Refresh Rolled Up

    IBM Teaches ACS New Tricks

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: Access Client Solutions, ACS, DB2 for i, Entitled System Support, ESS, Hardware Management Interface, HMC, IBM i, IBM i 7.3 TR6, IBM i 7.4, IFS, JDBC, Linux, ODBC, Run SQL Scripts, SQL

    Sponsored by
    DRV Tech

    Get More Out of Your IBM i

    With soaring costs, operational data is more critical than ever. IBM shops need faster, easier ways to distribute IBM applications-based data to users more efficiently, no matter where they are.

    The Problem:

    For Users, IBM Data Can Be Difficult to Get To

    IBM Applications generate reports as spooled files, originally designed to be printed. Often those reports are packed together with so much data it makes them difficult to read. Add to that hardcopy is a pain to distribute. User-friendly formats like Excel and PDF are better, offering sorting, searching, and easy portability but getting IBM reports into these formats can be tricky without the right tools.

    The Solution:

    IBM i Reports can easily be converted to easy to read and share formats like Excel and PDF and Delivered by Email

    Converting IBM i, iSeries, and AS400 reports into Excel and PDF is now a lot easier with SpoolFlex software by DRV Tech.  If you or your users are still doing this manually, think how much time is wasted dragging and reformatting to make a report readable. How much time would be saved if they were automatically formatted correctly and delivered to one or multiple recipients.

    SpoolFlex converts spooled files to Excel and PDF, automatically emailing them, and saving copies to network shared folders. SpoolFlex converts complex reports to Excel, removing unwanted headers, splitting large reports out for individual recipients, and delivering to users whether they are at the office or working from home.

    Watch our 2-minute video and see DRV’s powerful SpoolFlex software can solve your file conversion challenges.

    Watch Video

    DRV Tech

    www.drvtech.com

    866.378.3366

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Raz-Lee Offloads Virus Scanning from IBM i with ICAP These POWERUp Sessions Are About the Recent IBM i Announcement

    One thought on “IBM Bolsters ACS with Database and Administrative Goodies”

    • Todd Mason says:
      May 15, 2019 at 10:20 am

      Where do we obtain the latest ODBC driver you mention now that IBM i Access for Windows has been withdrawn? I don’t see it in the latest ACS download. Thanks!

      Reply

    Leave a Reply Cancel reply

TFH Volume: 29 Issue: 31

This Issue Sponsored By

  • T.L. Ashford
  • CNX
  • MITEC
  • New Generation Software
  • OCEAN User Group

Table of Contents

  • These POWERUp Sessions Are About the Recent IBM i Announcement
  • IBM Bolsters ACS with Database and Administrative Goodies
  • Raz-Lee Offloads Virus Scanning from IBM i with ICAP
  • Four Hundred Monitor, May 15
  • IBM i PTF Guide, Volume 21, Number 19

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • FAX/400 And CICS For i Are Dead. What Will IBM Kill Next?
  • Fresche Overhauls X-Analysis With Web UI, AI Smarts
  • Is It Time To Add The Rust Programming Language To IBM i?
  • Is IBM Going To Raise Prices On Power10 Expert Care?
  • IBM i PTF Guide, Volume 27, Number 20
  • POWERUp 2025 –Your Source For IBM i 7.6 Information
  • Maxava Consulting Services Does More Than HA/DR Project Management – A Lot More
  • Guru: Creating An SQL Stored Procedure That Returns A Result Set
  • As I See It: At Any Cost
  • IBM i PTF Guide, Volume 27, Number 19

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle