• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • New Release Of ACS Now Available

    December 9, 2020 Alex Woodie

    IBM delivered a new release of Access Client Solutions (ACS) last week, right on schedule. With ACS version 1.1.8.6, users will find a host of new features designed to accelerate their productivity across a range of uses.

    ACS is the Java-based utility that has become one of the most used (and useful) ways that administrators, programmers, and engineers can interact with the IBM i server. The software, which is free to IBM i customers on maintenance, features a 5250 emulator, 5250 printer emulation, data transfer capabilities, IFS file viewing, spool file management, and a virtual console for LAN and HMC management. Run SQL Scripts is a component of ACS, as is an Open Source Package Management, which enables users to access open source programs distributed via RPM.

    IBM originally announced ACS 1.1.8.6 as part of its fall 2020 Technology Refresh for IBM i on October 6, which included IBM i 7.3 TR9 and IBM i 7.4 TR3. On December 1, the company delivered the new release by making it available for download at ibm.biz/IBMi_ACS.

    The new release brings enhancements to Content Assist, a nifty function in the Run SQL Scripts component of ACS that gives users prompts when writing (or editing) SQL commands. Users can use Content Assist to pull up common SQL commands, displays additional information about a database object, and other features.

    With this release, users can pull up content assist by pressing the CTRL and space bar at the same time. Steve Will, the chief architect for IBM i at IBM, says this will be a much-appreciated feature among users.

    “If you’re a longtime IBM i user, you might think of this as the GUI version of F4 for commands,” Will said earlier this year. “It’s so much more powerful than that though, because it looks at all the different options that you could have for the SQL that you’re building . . . It helps you to converge and get preferences that you can carry over from one script to another so you don’t have to set them each time you’re doing it.”

    IBM has also extended Content Assist coverage for additional SQL statement and for more SQL syntax. “The team has gone crazy with updates to the Content Assist support,” said Tim Rowe, IBM’s architect for application development and systems management, said in a recent webinar. “There are more and more options that have been added to allow you to build simplistic as well as fairly complex SQL just by prompting.”

    Also getting some attention is Run SQL Scripts, which is an ACS features that lets users execute all sorts of SQL scripts for a variety of functions. With this release, IBM has converged and enhanced the preferences dialog. It also delivered new usability and performance enhancements, and added the capability to automatically close incompletely consumed queries.

    Browsing the IFS will be a much-improved experience with ACS 1.1.8.6. IBM says its can return thousands of IFS objects in “mere seconds,” a feature it has taken to calling “freaky fast IFS.”

    According to Will, this one feature alone will boost both the IFS and ACS. “With some of the advancements that we made in the prior Technology Refresh to allow you to subset which part of IFS you want to look at — these two things combined can make using IFS and ACS as fast as you can imagine, really,” he said.

    This release also brings multi-file upload in ACS, which will give users more power to move multiple files at once. This had been on many clients wish lists for some time, according to Will.

    IBM is also providing an IBM i Access ODBC driver for Mac OS and IBM i, to go along with the previously available driver for Windows and Linux. This will simplify how users create and deploy application packages, according to IBM.

    Finally, ACS can be launched from Rational Developer for IBM i (RDi), the full-featured IDE from IBM, without requiring a separate Java runtime installation.

    RELATED STORIES

    How The Latest TRs Bolster The Core IBM i OS

    IBM Rolls Out ACS 1.1.8.5

    IBM Bolsters ACS with Database and Administrative Goodies (ACS 1.1.8.2)

    IBM Delivers New Goodies with ACS Update (ACS 1.1.8.1)

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: Access Client Solutions, ACS, ACS 1.1.8.6, HMC, IBM i, IDE, IFS, LAN, Linux, ODBC, Rational Developer for IBM i, RDi, RPM, Run SQL Scripts, SQL

    Sponsored by
    VISUAL LANSA 16 WEBINAR

    Trying to balance stability and agility in your IBM i environment?

    Join this webinar and explore Visual LANSA 16 – our enhanced professional low-code platform designed to help organizations running on IBM i evolve seamlessly for what’s next.

    🎙️VISUAL LANSA 16 WEBINAR

    Break Monolithic IBM i Applications and Unlock New Value

    Explore modernization without rewriting. Decouple monolithic applications and extend their value through integration with modern services, web frameworks, and cloud technologies.

    🗓️ July 10, 2025

    ⏰ 9 AM – 10 AM CDT (4 PM to 5 PM CEST)

    See the webinar schedule in your time zone

    Register to join the webinar now

    What to Expect

    • Get to know Visual LANSA 16, its core features, latest enhancements, and use cases
    • Understand how you can transition to a MACH-aligned architecture to enable faster innovation
    • Discover native REST APIs, WebView2 support, cloud-ready Azure licensing, and more to help transform and scale your IBM i applications

    Read more about V16 here.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    COMMON Launches Focus, A Live Educational Series VS Code Provides Another Coding Option for IBM i

    Leave a Reply Cancel reply

TFH Volume: 30 Issue: 79

This Issue Sponsored By

  • Maxava
  • ProData
  • UCG Technologies
  • ARCAD Software
  • WorksRight Software

Table of Contents

  • VS Code Provides Another Coding Option for IBM i
  • New Release Of ACS Now Available
  • COMMON Launches Focus, A Live Educational Series
  • Four Hundred Monitor, December 9
  • IBM i PTF Guide, Volume 22, Number 49

Content archive

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

Recent Posts

  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25
  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24

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