Sat, Nov
10 New Articles

March 15, 2017

Issue Highlights

March 15, 2017 | Volume 16 Issue 6

• LEAD ARTICLE: A Little Bit More About Meetings
• FEATURED ARTICLE: SQL 101: Tools of the Trade - The ACS Run SQL Scripts, Part 2
• NEWS HIGHLIGHT: HelpSystems Centralizes AIX, VIOS, IBM i Performance Monitoring
• BUYER'S GUIDE: TLAForms by TL Ashford
• FEATURED VIDEO: Why you should use Watson Natural Language Understanding
• EVENT: Give your RPG applications the UI they deserve with ASNA Wings

Lead Article - Career

A Little Bit More About Meetings

In a recent article, it may have seemed that I thought meetings were the end of humanity as we know it. Didn’t mean to be so negative. The real question is whether meetings can be helpful. 

Written by Dave Shirey

Despite my negativity in my article about meetings, if we didn’t have meetings, what would we have? 

OK, greater productivity…but besides that. The truth is, you need meetings. Even if they are just informal meetings around the coffeemaker, there is a need for people to get together and talk about the issues they are working on, exchange ideas, get organized so that multiple people can work on an issue without falling all over each other, etc.

BCD Software

Give Your IBM i Users the Modern UI They Want

It's easier than you think for RPG programmers to give users the modern UI they want. See how BCD's Presto transforms green screens to web pages that:

  • Meet user expectations with a modern look
  • Improve navigation and data entry
  • Work on mobile devices

Watch this video



ASNA Visual RPG (AVR) empowers RPG programming to integrate your IBM i data and applications harmoniously with your other applications and platforms. With AVR your RPG programmers can build great Windows programs, scalable and performant Web apps, and SOAP and Restful Web services. AVR provides secure connectivity to both the IBM i and MS SQL Server and works with all popular open source tools such as Git, jQuery, Bootstrap/Zurb Foundation, and Backbone. AVR is an IBM i Swiss Army Knife!

MC Press Bookstore

This ain’t your mama’s RPG! Time to move on from OPM—with Evolve Your RPG Coding. This comprehensive new book gives you all the tools to move to a more modern, modular, and efficient ILE RPG. The book guides you through the transition at a comfortable pace, making every ILE concept totally accessible. You’ll start with simple, easy-to-understand examples and analogies to OPM, then advance to complete and complex ILE code. Finally, you’ll go beyond ILE with a detailed discussion of SQL, code organization, and structure. Order by Friday, March 17th and get 20% off.  Use promo code: RAFAEL Get your copy today!


Feature Article - Programming

SQL 101: Tools of the Trade - The ACS Run SQL Scripts, Part 2

As promised, here are a few more tricks and tips about ACS’ Run SQL Scripts, including the availability of a new version with some nice features!

Written by Rafael Victória-Pereira

couple of TechTips ago, I explained how to install ACS and remarked that the process was not very user-friendly. Among other things, you need to figure out which JavaScript file to use in order to start the right installation process and, when the said process ends, you have to create your own desktop shortcuts.

MC SCBG Featured Product

TLAForms by TL Ashford converts your traditional IBM i spool files into high quality, professional forms.

Use a GUI Designer to create forms using data from a spool file and data from your IBM i files. Forms can be designed with true-type fonts, bar codes – including QR Code and Datamatrix, color images, overlays, lines, boxes and ellipses all in full color.

The software generates your forms as PDF documents that are archived to the IFS, automatically emailed and/or printed. Forms can be printed to IBM i PostScript printers, any printer connected to the network, or any printer connected to a PC. IFS locations, email addresses, and printers can be variable based on data within the spool file, data within the IBM i file or spool file attributes.

No programming is required to generate the new forms from your existing ERP, WMS or in-house application software.

The experienced TL Ashford technical support team will provide any pre-designed templates like the VICS Bill of Lading, and make sure working with the software is as easy and productive as possible!