Paul Tuohy returned to NHMUG on Tuesday September 19th, 2017!

It is with great excitement that we had a return visit from Paul Tuohy on Tuesday September 19th, 2017.
Paul is a world renowned speaker and well known throughout the IBM i community.

Paul presented the following sessions:

Paul Tuohy

RPG on the Move: Mobilize Your i

Choices and challenges in the world of mobile applications

Mobile applications are the hot topic of the day and your old RPG green-screen skills and tools are just not going to make the grade. In this session Paul discusses some of the factors you have to consider when embarking on the development of your first mobile applications.

Topics to be covered include:

  • Design considerations for mobile - from F-keys to touch sensitivity
  • Platform options - iPad? iPhone? Android? Blackberry? Tablets?
  • Local processing or server/browser based?
  • Can you do it with RPG? And what are your other language choices

Introduction to AJAX for RPG Programmers

Although it has been around for a number of years Asynchronous JavaScript and XML (AJAX) has suddenly become a hot topic. What is all the fuss about? What relevance does AJAX have for the RPG programmer?

AJAX provides a means of having a web page communicate with a server, either synchronously or asynchronously. Combined with CGI programming techniques (CGIDEV2 is used in the presentation), you now have a means of dealing interactively with a web page i.e. changing the contents of a web page without having to re-write the whole page.

And best of all, it is already installed on every PC, all you have to do is use it!.

In this session you will learn:

  • The background to AJAX
  • How it works
  • Examples of how to use it

I Didn't Know You Could Do That With SQL

You have started to master SQL but you have a sneaky suspicion that there might be more to it.

In this session you will learn valuable and time saving techniques with SQL that let you avoid writing code. You will learn how to use SQL Subquery or Subselect in an SQL SELECT, INSERT, UPDATE, DELETE or CREATE TABLE statement to reference multiple tables without having to do a join of the tables involved. You will see how to use CASE and UNION statements, Common Table Expressions (CTEs) and where to use Full Outer Join and Hidden Time Stamp columns.

This session is based on the SQL function available in V5R4, V6R1, and V7R1 of OS/400 or i5/OS, assumes you have a basic understanding of relational database concepts and SQL.

Externalizing Database Processing in RPG IV

One of the major considerations for the ongoing modernization of applications is how to make functionality accessible to multiple interfaces. But no matter how the application interfaces may change (green screen, web, client server, mobile phones etc.) or how data may arrive on the system (FTP, EDI, XML etc.) you can be sure that all of the data is going to end up in a database.

Externalized database processing provides a means of encapsulating database access. This session discusses why you may want to externalize database processing in RPG IV and how to do it.



ComCon is a company owned and run by Paul Tuohy. It specializes in consultancy, software development and training for the IBM i (System i, i5, iSeries and AS/400).

Paul Tuohy has worked in the development of IBM Midrange applications since the '70s. He has been IT manager for Kodak Ireland Ltd. and Technical Director of Precision Software Ltd. As well as being CEO of ComCon he is also one of the co-founders of System iDeveloper, a consortium of top experts and educators on i technology. He has been teaching and lecturing since the mid-'80s.

Paul is the author of "Re-engineering RPG Legacy Applications", "The Programmers Guide to iSeries Navigator" and the self teach course "iSeries Navigator for Programmers".

He also writes regular articles for most of the industry publications and is one of the quoted industry experts in the IBM Redbook "Who knew you could do that with RPG IV?".

As well as speaking at renowned RPG & DB2 Summit conferences and other conferences around the world Paul is also an award winning speaker at numerous US Common conferences.

29th Annual New Hampshire / Vermont IBM i User Group Meeting

Wednesday, June 7, 2017 - Fireside Inn, West Lebanon NH

This event was free to IBM i professionals, and sponsored by NHMUG and VTMUG


IBM Announcements - Steve Fier, IBMSteve Fier

The presentation will cover the February 2017 hardware announcements including the new S812. Also, there will be details on IBM i 7.3 TR2 and 7.2 TR6 including DB2 for i, Web Query and Client Access.


Click -->> HERE <<-- for the handout from this session

Living Without Client Access - Part 2

About Steve

Steve Fier has been with IBM over 30 years, initially starting as a systems engineer, and then becoming a senior marketing specialist. His current role is POWER Platform Leader for the Northeast, responsible for former System i and System p products. Steve's areas of expertise include application development, DB2 for i, Windows Integration and Server Consolidation.

Promoting the Future and Value of IBM i to Your Business Executives - Trevor Perry, Fresche Legacy 

This session shows you how IBM i can be presented to the business in order to raise visibility, preserve your investment in the platform, and ensure that business applications are developed using the right tools. Join us and take away information that can be used to educate your own business about the platform, its planned future, how it fits the requirements of your business, and how to leverage IBM i in your business. Your organization has a strong heritage with IBM i and the total cost of ownership of IBM i consistently proves to be a better proposition. With IBM i on Power Systems, the future of your business can be more agile, scalable and sound. Come and learn how to sell that proposition to your business executives.

IBM i Application Modernization Revealed - Trevor Perry

Modernization is such an interesting word. It seems everyone has a definition, and depending on the vendor, there is only ONE way to modernize. Yet, everyone has a different starting point, different ending destination, and therefore, different roadmap. Trevor brings his 25 years of modernization and transformation experience and 30 years of IBM i related experience to help you decide the best direction for your own unique modernization journey. Also covered will be several real world examples and ideas of what to do and what not to do. A simple and effective strategy approach is also introduced.

How to be an IT Survivor - Trevor Perry

Do you know that your job will look like in 5 years? 10 years? Will you be kicked off the island? Are you the weakest link? The IT industry is fueled by change and requires both ourselves and our companies to adapt quickly.This session is a discussion of topics that can assist you in being an IT survivor. A review of past trends may give us clues to maintaining current skills and developing new skills. This will allow us to remain competitive as individuals and drive our businesses in the right direction for a future of change. Be prepared to challenge your status quo, and leave with new ideas on how to become flexible enough to adjust quickly to new trends and directions and ensure your survival.

About TrevorTrevor Perry

Trevor Perry is a veteran of the IBM i community. He is a consultant to companies on their I.T. modernization efforts, and has been engaged in all phases of the IT development cycle. He is a popular speaker at industry events on technical, strategic, modernization and motivational topics and is a regular keynote at conferences around the world. Trevor won an IBM/COMMON innovation award for his community efforts, occasionally blogs at, was the creator of the only ever cartoon for IBM i, and provides marketing encouragement for the community everywhere. His passion for changing the world for the better has not been tamed and his storytelling skills can be found in his first book “Never Iron When You Are Naked”. Trevor is working on his next book “You Are Extraordinary”, while he continues to find new ways to stir the passion of the IBM i community.

Trevor's day job is a consultant at Fresche. Guiding customers in their modernization efforts, assisting with IT strategy and directions, and setting new standards in leveraging IBM i in business for a strong future. He speaks at conferences and events around the world leveraging the collected experience and expertise of Fresche in the business and IT community.




Robin Tatam presents security topics to NHMUG user group!

Thursday March 23rd

Encrypting Data on IBM iRobin Tatam

With news headlines populated with a constant flow of data breaches, many organizations are looking to encryption as a possible “silver bullet.”

This session will answer pressing questions around the topic of encryption and teach some of the main considerations when embarking on this type of project, including:

  • Why encrypt
  • Can I just encrypt the entire disk?
  • What changed in IBM i v7.1
  • Considerations that influence an encryption project
  • Field procedures and Triggers

IBM i Security for Programmers

Although your IBM i server is one of the most securable platforms available, the protection of critical data is often undermined by weak security design at the application level.

This session will cover the main considerations that a programmer should be aware of as they design their applications:

  • Object ownership
  • Adopted authority
  • Public and private authorities
  • Command line permission
  • Client-server considerations

Configuring and using IBM i Auditing Features

Did you know that IBM i includes powerful auditing features? This session is designed to teach how to correctly activate and utilize IBM i’s built-in forensic capabilities.

Learn about:

  • Security audit journal
  • Audit data management
  • Configuring the ‘Audit’ system values
  • A user profile’s *AUDIT special authority
  • Object auditing
  • User auditing
  • Data reporting options

Equally important, you will also learn about what system auditing does not capture, and how to prevent that from causing you to fail an audit.

Evaluating YOUR OWN State of Security

For many in the IBM i community, security is a journey that is considered and discussed but never embarked upon. This often stems from the fact that many people are under the impression that IBM i is inherently secure and have never had theirs professionally reviewed for risk.

Before the conference, registrants will be provided with a link to download a [free] proprietary tool to quickly and non-invasively scan the IBM i partition of choice. The session, led by a certified auditor and expert in IBM i security, will consist of an interactive discussion regarding how to interpret the findings.

Topics will include the following:

  • Administrative Privileges
  • Public Authority
  • Network-based Access
  • FTP
  • System-level security settings
  • User-based security risks
  • Auditing


Robin Tatam

Robin Tatam is HelpSystems’ Global Director of Security Technologies and a COMMON subject matter expert (SME). As an award-winning speaker on security topics, Robin has been interviewed and quoted by industry magazines and has published numerous trade articles. Robin’s extensive Power Server experience has resulted in more than 20 IBM certifications and the highly sought after designation of ISACA-certified Information Security Manager (CISM) and PCI-Professional (PCI-P). He is also co-author of IBM’s Redbook publication on IBM i Data Encryption.

Look who came to New Hampshire!

Wednesday February 1st


Meeting users needs with free software on IBM iJon

Are you tired of constantly exporting and importing data for "foreign" applications running on Windows or Unix/Linux servers? Do you wish there was an easy way to keep more applications on IBM i?

This session shows you some approaches that will help you to ensure that modern applications can be deployed on IBM i easily and without breaking the budget.

Exploit the huge world of open source applications and tools that you can easily implement on your IBM i. And what's more, you can easily integrate these applications into your DB2/RPG universe.

Jon will also show you how you can create powerful browser-based database applications in minutes using readily available application frameworks - writing almost no code yourself. And all the data can be stored in DB2 so you can easily integrate these applications into your existing inventory.

Can it all really be that cheap and easy to do? Jon believes so and on this session will discuss and demonstrate a number of open source applications to show just how quickly and easily new web-based applications can be deployed.

Keep your IBM i alive and vibrant and be a hero to your end users by responding quickly to requests for new web based applications.

From subroutines to Procedures & Service Programs - part 1

Susan doesn’t code subroutines any more. She believes that procedures (aka, subprocedures) make great subroutine replacements. They can make your code more obvious, making maintenance easier, faster and more reliable. Take the extra step to package your commonly used procedures into ILE Service Programs and you can share them easily and efficiently among many programs.

SusanIn this 2 part session, Susan will explain the advantages of modularizing your code using procedures and she'll cover how to do it.

Part 1 covers the details of coding procedures - both the syntax and the best practices. We'll look at how prototypes are used with procedures and cover some valuable prototype keywords to make your coding life easier.

From subroutines to Procedures & Service Programs - part 2

Part 2 assumes you have either attended Part 1 or already have experience coding internal procedures, defining and using local data and prototypes. In this second session, we'll cover the details of ILE Service Programs - what they are, when and why you should use them, how to package your procedures in them, and shortcuts for using them from your other programs.

These two sessions can form a foundation for writing better modular applications.

The latest and greatest in RPG IV

The V7 releases of RPG have radically changed the language. Among other new features, you can now code RPG in completely free format - and with no 80 columns restrictions!

The latest updates have also extended RPG's error handling model, making it much simpler to ensure that things are "tidied up" in the even of an exception.

In addition to these latest enhancements, Jon will also cover other V7 features including:

  • Sorting and Searching of Data Structure Arrays
  • Support For Alias Names
  • New and Updated BIFs - Including Scan and Replace
  • Changes in Prototyping rules
  • And last but not least how performance improvements for large return values can make your subprocedures easier to deploy as web services.



Susan's career has spanned over 30 years in the field of application development. She began as a programmer developing applications for corporations in Atlanta, Georgia, working with a variety of hardware and software platforms. She joined IBM in 1985 and quickly developed a close association with the Rochester laboratory during the development of the AS/400 system.

Susan worked in Rochester, Minnesota for 5 years in the AS/400 Technical Support Center. She later moved to the IBM Toronto Software Laboratory to provide technical support for programming languages and AD tools on IBM i.

Susan left IBM in 1999 to devote more time to teaching and consulting. Her primary emphasis is on enabling customers to take advantage of the latest programming and database technologies on IBM i.

Today she is part of System i Developer, the team that hosts the RPG & DB2 Summit events twice annually.

Susan is a regular speaker at user group and other technical conferences around the world and holds a number of Speaker Excellence medals from COMMON.

Susan is a Technical Editor for IBM Systems Magazine and a frequent writer for IBM Systems Magazine and IT Jungle.


Jon's IBM midrange career started when he fell in love with the System/38 while working as a consultant. This love affair ultimately led him to joining IBM.

In 1987, Jon was hired by the IBM Toronto Laboratory to work on the S/36 and S/38 COBOL compilers. Subsequently Jon became involved with the AS/400 and in particular COBOL/400.

In early 1989 Jon was transferred to the Languages Architecture and Planning Group, with particular responsibility for the COBOL and RPG languages. There he played a major role in the definition of the new RPG IV language and in promoting its use with IBM Business Partners and Users. He was also heavily involved in producing educational and other support materials and services related to other AS/400 programming languages and development tools, such as CODE/400 and VisualAge for RPG.

Jon left IBM in 1998 to focus on developing and delivering education focused on enhancing IBM i application development skills.

Today he is part of System i Developer, the team that hosts the RPG & DB2 Summit events twice annually.

Jon is a frequent speaker at User Groups meetings and conferences around the world and holds a number of speaker excellence awards from COMMON.

Jon is a Technical Editor with IBM Systems Magazine and a frequent author for IBM Systems Magazine and IT Jungle.