• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • More Database Tools Highlight Latest IBM i Access Client

    September 18, 2017 Dan Burger

    Remember IBM i Access for Windows? Many IBM i advocates do because they never stopped using it, despite its replacement by IBM i Access Client Solutions more than four years ago. Access for Windows hasn’t seen an enhancement since ACS arrived and ACS is on a continual enhancement schedule. The most recent round of upgrades arrived in mid-July without much fanfare, which is the way IBM seems to prefer.

    SQL developers and database engineers (those that have the title and those that only have the responsibility) are among the professionals benefiting the most from the expanding ACS toolset that usually gets attention through educational sessions at tech conferences and notice during the spring and fall Technology Refresh announcements.

    In March, IT Jungle reported the ACS development team would soon be adding additional database schema functions as part of the ongoing enhancement program. Schema are similar to libraries. The foundation of schema functionality has been included in ACS for the past year. The latest schema functionality includes journal view entries, filtering for tables and indexes, and all objects permissions. In mid-July that promise became reality with the availability of ACS Version 1.1.7.1. For those familiar with System i Navigator, the schema functionality has been in that product for some time.

    A shopping list of incremental enhancements comes with the 1.1.7.1 release. Here are a few of the highlights.

    The most heavily used database tools in ACS is likely the SQL interface suite. There you’ll find Run SQL Scripts, which were originally introduced in late 2015 with enhancements at nearly every version release since. Run SQL Scripts was a feature in the predecessor of ACS, and although the layout seems familiar the functionality easily beats Access for Windows. Faster start-up time, color coding, and a graphical debugger are a few of the advantages.

    In the latest version, there’s an insert from example function within Run SQL Scripts that is useful to developers who try to avoid writing everything from scratch. There are also services that can be used for tasks such as querying disk usage and identifying the top consumers of spool storage using SQL.

    The insert from examples features saves development time by reusing code.

    The SQL Formatter is another new feature. It comes in handy when an SQL statement is written in one long line. The formatter will convert the statement into something easier to read and understand by using line indents and setting maximum line lengths.

    Also of note is the JDBC Configuration Manager. It provides the capability to make different connection settings for different tasks on different systems. The Access for Windows tool had a single copy of JDBC configuration. You could change the configuration, but you often did not remember the settings from the last time you used the tool. Maybe you were using commitment control and you might have been using SQL naming instead of system naming. The JDBC Configuration Manager allows you to be more organized by keeping stuff coordinated and properly named, so when certain issues require certain configurations they can be easily found. Just another case of building something once and using it many times.

    The JDBC Configuration Manager is a slick tool for selecting JDBC connections.

    ACS Version 1.1.7.1 also includes some new features for users who are mostly concerned with emulation. There’s a 5250 display and printer emulation based on IBM’s Host-on-Demand; multiple language support for concurrent 5250 emulation sessions on the same client; and 5250 emulation for LAN and HMC consoles.

    But as you can see from a review of the Technology Refreshes, the IBM i development is clearly database and SQL focused. IBM i shops not in alignment with that will not have their database tooling enhanced and their system management tools will similarly stagnate. You can continue to do things the way that you’ve done them for the past 25 years, but that’s not putting you on the road to the future. Some shops can live with that a while longer, but the inevitable can only be put off for so long.

    ACS was written in Java, so it will run on Linux and MacOS in addition to Windows. That’s a benefit for a growing number of shops. Another benefit is its accessibility via a shared network drive on the IBM i server, which eliminates downloading and installing binaries on desktops and laptops. Simplified maintenance means more time available for something else – modernizing a 25-year-old database comes to mind. That would be a benefit.

    The next ACS update is planned for October 2017 in conjunction with the next Technology Refresh. Expect more database and SQL enhancements when the TR announcement comes.

    RELATED STORIES

    ACS Getting New Database Schema Functions

    What’s New In Access Client Solutions

    IBM i Access Client Solutions For Database

    New Round Of Enhancements For Access Client Solutions

    See The IBM i Access You Never Heard Of

    IBM i Access Turns Its Attention To Database

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: Access Client Solutions, ACS, IBM i, SQL

    Sponsored by
    ARCAD Software

    Embrace VS Code for IBM i Development

    The IBM i development landscape is evolving with modern tools that enhance efficiency and collaboration. Ready to make the move to VS Code for IBM i?

    Watch this webinar where we showcase how VS Code can serve as a powerful editor for native IBM i code and explore the essential extensions that make it possible.

    In this session, you’ll discover:

    • How ARCAD’s integration with VS Code provides deep metadata insights, allowing developers to assess the impact of their changes upfront.
    • The role of Git in enabling seamless collaboration between developers using tools like SEU, RDi, and VS Code.
    • Powerful extensions for code quality, security, impact analysis, smart build, and automated RPG conversion to Free Form.
    • How non-IBM i developers can now contribute to IBM i projects without prior knowledge of its specifics, while ensuring full control over their changes.

    The future of IBM i development is here. Let ARCAD be your guide!

    Watch the replay now!

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Guru: Consuming A REST Web Service Using SQL And GET Crazy Idea # 542: Port IBM i To The Mainframe

    Leave a Reply Cancel reply

TFH Volume: 27 Issue: 59

This Issue Sponsored By

  • T.L. Ashford
  • ProData Computer Services
  • WorksRight Software
  • Linoma Software
  • Manta Technologies

Table of Contents

  • Crazy Idea # 542: Port IBM i To The Mainframe
  • More Database Tools Highlight Latest IBM i Access Client
  • Guru: Consuming A REST Web Service Using SQL And GET
  • Three Lessons IBM i Shops Can Learn From The Equifax Hack
  • The State Of Systems In The Second Quarter

Content archive

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

Recent Posts

  • 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
  • IBM Unveils Manzan, A New Open Source Event Monitor For IBM i
  • Say Goodbye To Downtime: Update Your Database Without Taking Your Business Offline
  • i-Rays Brings Observability To IBM i Performance Problems
  • Another Non-TR “Technology Refresh” Happens With IBM i TR6
  • IBM i PTF Guide, Volume 27, Number 18

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