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

    Integrate Virtual Tape to Automate Your Backups And Strengthen Your Ability To Recover From Cyber Attacks And Disasters

    With most IT departments stretched thin, finding something that can quickly free up IT time is definitely a bonus. That’s why it’s important to stop and take a look at integrating virtual tape into your backup and recovery. Virtual tape is one of those technologies where once you have it, you’ll wonder why you didn’t do it sooner. See a demo and get a $50 gift card.

    But what is it about using virtual tape that makes it so worthwhile? Why is it that so many IBM i shops are already using or considering using virtual tape for all or part of their backup and recovery systems?

    Virtual tape and virtual tape libraries offer a way to both simplify and strengthen backup and recovery operations. By incorporating virtual tape technology, automation of backups becomes possible resulting in hundreds of hours saved annually for IT departments and personnel.

    “We needed to find a replacement that would lower the maintenance cost and reduce complexity of our backup and recovery functions without a major disruption to our operations.” David Fray, Director of Enterprise Systems, ABC Financial

    LaserVault ViTL is a virtual tape and tape library solution developed specifically for use with IBM Power Systems (from AS/400 to iSeries to Power 9s). With ViTL you can:

    • Replace physical tape and tape libraries and eliminate associated delays
    • Automate backup operations, including the ability to purge or archive backups
    • Remotely manage your backups – no need to be onsite with your server
    • Save backups to a dedupe appliance and the cloud
    • Recover your data at lightspeed greatly improving your ability to recover from cyberattacks
    • And so much more

    Sign-up now to see a ViTL online demo and get a $50 Amazon e-gift card when the demo is complete as our way of saying thanks for your time. Plus when you sign-up you’ll receive a free facts comparison sheet on using virtual tape vs tape so you can compare the functionality for yourself.

    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

  • IBM Mulls Using DataMigrator as Cloud Warehouse Pipeline
  • PowerTech AV Automatically Detects Ransomware Activity
  • Infor Puts CM3 Project On Hold
  • Four Hundred Monitor, June 29
  • IBM i PTF Guide, Volume 24, Number 26
  • Guild Mortgage Takes The 20-Year Option For Modernization
  • IBM i Licensing, Part 3: Can The Hardware Bundle Be Cheaper Than A Smartphone?
  • Guru: The Finer Points of Exit Points
  • Big Blue Tweaks IBM i Pricing Ahead Of Subscription Model
  • We Still Want IBM i On The Impending Power E1050

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 © 2022 IT Jungle

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.