• 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
    Chilli IT

    Chilli is one of the UKs leading IBM support and management providers with 20 years’ experience in the power and storage industry. Our bespoke solutions for maintenance, security and infrastructure delivers a service which is cost effective, increases productivity and enhances efficiency. Our ethical approach and unrivalled knowledge has secured business partnerships with blue-chip companies in the technology, retail, banking and travel sectors.

    As an IBM Business Partner, we provide you with the peace of mind that you are working in partnership with a company accredited to the highest standard. Our team of experts have worked together for many years and deliver projects which include consolidation, High Availability, Operating System upgrades; and backup and recovery installations.

    Contact us to see how we can help your business with IBM support and management.

    www.chilli-it.co.uk

    info@chilli–it.co.uk

    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

  • IBM i 7.3 TR12: The Non-TR Tech Refresh
  • IBM i Integration Elevates Operational Query and Analytics
  • Simplified IBM i Stack Bundling Ahead Of Subscription Pricing
  • More Price Hikes From IBM, Now For High End Storage
  • Big Blue Readies Power10 And IBM i 7.5 Training for Partners
  • IBM Delivers More Out-of-the-Box Security with IBM i 7.5
  • Groundhog Day For Malware
  • IBM i Community Reacts to IBM i 7.5
  • Four Hundred Monitor, May 11
  • IBM i PTF Guide, Volume 24, 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 © 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.