December 2020 Access Client Solutions Enhancements
Dawn May highlights favorite features in the latest update of Access Client Solutions
By Dawn May12/22/2020
Notice the new ACS icon!
IFSIBM enhances the IFS task with every update, and this version is no exception:
- Download or view source members: You can now easily download and view source members, which are files in the QSYS.LIB file system with an extension of .MBR. Prior to this update, if you tried to view a source member via the IFS task the contents would be unreadable. There are new View… and Download… actions which have an option to “View as UTF-8 text file”. Selecting this option allows source members to display correctly.
- Upload multiple files or an entire folder: Prior to this update users could only select individual files to upload one at a time. Now you can select multiple files, or an entire folder.
- Unzip files: You can now unzip a file in the IFS. When you unzip a file, you are prompted for the location in which to store the individual files, which defaults to the same directory in which the zip file resides. You are given the option to specify the directory where the zip file contents should be stored. You can unzip .zip and .jar files.
Like IFS tasks, Run SQL Scripts are continually enhanced:
Run SQL Scripts
- Menu options and preferences: Various menu and configuration options are now consolidated under a Preferences option you will find under Edit. Edit → Preferences allows you to customize your Run SQL Scripts interface in a single place. Previously, many of these options were scattered around in various places and the Options menu is now gone.
- Customizable null results: When the results returned from a SELECT statement were null, a ‘-‘ was simply in the column. This might cause confusion if the actual contents of a column was a ‘-‘. Users can now customize how null columns are displayed. You do this customization in the Results tab of Preferences. You can specify a color for cells with null results as well as text to display, as the following screen capture shows.
- Example IBM i Services: With this update, there are many more examples provided, including examples for all the new services added in the Db2 Group PTF level 10 delivered in November.
- Context Assist: Context Assist is your “SQL prompter”, and IBM delivered many enhancements to this powerful feature, such as support for additional SQL statements and more SQL syntax.
Dawn May is an IBM i consultant. She owns Dawn May Consulting, LLC in the Greater Boston area. Dawn is a former IBM senior technical staff member.