• 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
    Raz-Lee Security

    Raz-Lee Security is the leader in security and compliance solutions that guard business-critical information on IBM i servers. We are committed to providing the best and most comprehensive solutions for compliance, auditing, and protection from threats and ransomware. We have developed cutting-edge solutions that have revolutionized analysis and fortification of IBM i servers.

    Raz-Lee’s flagship iSecurity suite of products is comprised of solutions that help your company safeguard and monitor valuable information assets against intrusions. Our state-of-the-art products protect your files and databases from both theft and extortion attacks. Our technology provides visibility into how users access data and applications, and uses sophisticated user tracking and classification to detect and block cyberattacks, unauthorized users and malicious insiders.

    With over 35 years of exclusive IBM i security focus, Raz-Lee has achieved outstanding development capabilities and expertise. We work hard to help your company achieve the highest security and regulatory compliance.

    Key Products:

    • AUDIT
    • FIREWALL
    • ANTIVIRUS
    • ANTI-RANSOMWARE
    • MULTI-FACTOR AUTHENTICATION
    • AP-JOURNAL
    • DB-GATE
    • FILESCOPE
    • COMPLIANCE MANAGER
    • FIELD ENCRYPTION

    Learn about iSecurity Products at https://www.razlee.com/isecurity-products/

    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

  • N2i Gains Traction Among IBM i Newbies
  • Realizing The Promise Of Cross Platform Development With VS Code
  • 2023 IBM i Predictions, Part 3
  • Four Hundred Monitor, January 25
  • Join The 2023 IBM i Marketplace Survey Webinar Tomorrow
  • It Is Time To Have A Group Chat About AI
  • 2023 IBM i Predictions, Part 2
  • Multiple Vulnerabilities Pop Up In Navigator For i
  • Participate In The 2023 IBM i Marketplace Survey Discussion
  • IBM i PTF Guide, Volume 25, Number 4

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.