• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • IBM Delivers New Goodies with ACS Update

    December 5, 2018 Alex Woodie

    IBM has issued a new release of Access Client Solutions (ACS), the indispensable Java-based client that delivers a range of functionality to administrators, developers, and users alike. In the new release of ACS, IBM delivers enhancements across a range of functions, including SQL queries, database schemas, data transfer, and printing and emulation.

    IBM first unveiled ACS way back in August 2012 as the strategic replacement for older IBM i client interfaces, such as Access for Windows, Access for Web, and Access for Linux. With a full 5250 emulator, support for printing, the capability to view IFS, spool file, and message queues, and a virtual console for LAN and HMC management, ACS delivered a slew of important functionality in a single product. And since it was written in Java, it can run practically anywhere, including Windows, Linux, and (most importantly) MacOS.

    With ACS 1.1.8.1, IBM has updated the product in several important ways. For starters, let’s look at the popular Run SQL Scripts function in ACS, which allows developers to write and execute SQL queries against the Db2 for i database within the ACS environment.

    According to the “read me” document for this release, Users can now automatically update their scripts Run SQL Scripts with the push of a button. Users can also select text from within a result cell, and display name and label data at the same time. Users can change column headings and perform other customizations in current results. There are also many new examples that users can choose from.

    On the schema front, ACS 1.1.8.1 brings several enhancements, including the capability to specify a system name when creating a new schema. IBM has made a variety of improvements in the work with related objects function, and also added support for changing aliases, row permissions, and column masks.

    Developers who want to optimize their SQL will find new options for filtering performance monitors, plan cache snapshots, and plan cache event monitors. There were also new options created for selecting other systems in the SQL Performance Center.

    In the 5250 emulator, IBM now lets users turn off keyboard buffering. It also allows variables to be used in the print screen header and footer. When “use Java print service” is selected in the print emulator, users can set margins. And users moving from Access for Windows to ACS can now migrate their Kerberos settings, simplifying the setup of authentication parameters.

    On the data transfer front, users can now choose custom tab names for Excel downloads. It also offers UTF-8 variable width character encoding when the DOS random file type (.dsr) is being used.

    A couple of changes have been made to the installation process. For starters, ACS 1.1.8.1 uses Java version 8, so be sure that is enabled on the computer that’s running ACS. IBM now includes installation scripts for Windows that check to ensure there’s a compatible version of Java.

    IBM offers two application packages for ACS, including one for Windows and one for Linux. It is now bundling those application packages in the base download for version 1.1.8.1, which is a change that former IBMer Dawn May notes in her blog. IBM is prepping an update of these application packages this month.

    RELATED STORIES

    Tooling Around With IBM i Access Client Solutions Announcements

    What’s New In Access Client Solutions

    IBM Teaches ACS New Tricks

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: Access Client Solutions, ACS, DB2 for i, HMC, IBM i, IFS, Java, LAN, Linux, MacOS, SQL, Windows

    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

    Four Hundred Monitor, December 5 Mono Comes to RPM, Making .NET on IBM i Even Easier

    Leave a Reply Cancel reply

TFH Volume: 28 Issue: 81

This Issue Sponsored By

  • HiT Software, Inc. a BackOffice Associates Company
  • WorksRight Software
  • iTech Solutions
  • Datanational Corporation
  • T.L. Ashford

Table of Contents

  • Skytap Says It’s Building a ‘True Cloud’ Offering for IBM i
  • Mono Comes to RPM, Making .NET on IBM i Even Easier
  • IBM Delivers New Goodies with ACS Update
  • Four Hundred Monitor, December 5
  • IBM i PTF Guide, Volume 20, Number 48

Content archive

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

Recent Posts

  • With Power11, Power Systems “Go To Eleven”
  • With Subscription Price, IBM i P20 And P30 Tiers Get Bigger Bundles
  • Izzi Buys CNX, Eyes Valence Port To System Z
  • IBM i Shops “Attacking” Security Concerns, Study Shows
  • IBM i PTF Guide, Volume 27, Number 26
  • 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

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