Vermont Midrange User Group 

VTMUG logo Twelfth Annual Technical Conference
Thu, Sep 22, 2016
Register Speakers  Sessions  Session Grid Sponsors  Hotel &
Session Descriptions

Track 1: RPG Programming:
Track 2: Web Programming:
Track 3: DB2/SQL:


Track 1: RPG Programming



Introduction to XML Basics and Generating XML with RPG

Jon Paris

Every day more and more RPG shops are finding that XML is playing an increasing role in their data interchange operations. In this session we will introduce you to the basics of XML syntax and show how it compares with HTML and DDS.

Having dealt with the basics we then move on to discuss several ways in which XML can be generated from RPG programs. While there is no direct support for XML generation in RPG, the good news is that there are a number of tools available that can be used to help you. The even better news is that all of the tools we will introduce you to are available free of charge.


Processing XML with RPG

Jon Paris

In this session we'll look at RPG's native support for XML processing, including the latest enhancements. We'll also include a brief overview of the Data Structure features added in V5R2 that are critical to understanding how the XML support works.

Whether you are using XML for web services or data interchange, dealing with XML in RPG can be challenging. V5R4 brought welcome relief in the form of new RPG language support that greatly simplified parsing XML within your programs. While useful, there were issues that IBM subsequently addressed in enhancements released in V6 and 7. The result is a powerful set of XML processing capabilities that are also easy to use once the basics are grasped.


RPG Subprocedures - Beyond the Basics

Susan Gantner

You know the basics of coding and using subprocedures. Now it is time to take the next step. In this session we will discuss a number of topics such as:

  • Making your subprocedures more useful through the use of parameter options such as VALUE and CONST
  • Defining and using optional (*NOPASS) parameters - and doing it safely!
  • Using new 6.1 features for local files and passing files as parameters
  • Effective Return Values, including using 7.1 feature that may improve performance
  • New, more relaxed prototyping rules implemented in 7.1

We'll not only cover how to use these functions, but offer advice on when to use them most effectively.

Note: This session assumes you already have a basic understanding of RPG subprocedures. If you need a refresher on the basics before attending this session, take a look at the following articles:




Service Programs: Why and How

Susan Gantner

In this session, we will take a look at the essential information you need to know about using ILE static binding to create Service Programs. Using a simple application example, we will illustrate how and why to create modules, bound ILE programs, Service Programs and how to use them effectively. We will discuss creating modules, bound programs and Service Programs as well as creating and using Binding Directories.



Track 2: Web Programming



Leveraging Free Java Libraries in Your RPG Programs.

Ryan Eberly

Java is a large stable development environment with a vibrant open source community. Learn how to identify and leverage appropriate open source Java libraries to provide solutions within your IBM i programs.


How to Plan and Start a Modernization Project

Chris Koppe

Planning a modernization project involves more than choosing target technology options and a vendor to help with the process. The key element of planning is to ensure that the modernization is in clear support of a defined business goal. Providing improved business results highlights the success of the modernization and ensures backing for future modernization projects. This session will show you how to define business goals and undertake a discovery process that will identify IT modernization projects that align with those business goals. The discovery process typically provides preliminary project plans, budgets, personnel requirements and technology recommendations.

This session has the following leaning objectives:

  • Learn about identifying business goals and how to align IT modernization projects to them
  • Learn about discovery activities
  • Understand how to establish a budget, create a project inventory, create a project plan and choose technology options
  • Examine testing best practices, which need to be in place before the project starts


Database Modernization

Brian Garland

The first step to modernizing your applications is to modernize your database. Traditional DDS databases have served us well, but the benefits of SQL based databases more than outweigh the time involved in the conversion. This presentation focuses on the first steps of database modernization. Brian will go over the reasons to change from DDS to DDL in defining your database objects. He will review IBM’s database modernization roadmap and detail the steps to follow to accomplish the various phases of the roadmap.


Data Virtualization: a Legacy Application Enablement Tool

Glen Marchesani

The traditional approach to modernizing legacy software application is to focus on replacing or evolving the application itself. The former is highly expensive and time consuming. The latter is highly complicated as the new code needs to be integrated with legacy code. This takes extraordinary care, consideration, and resource if one wants the enabled application to be highly peformant.

Data virtualization allows an alternative approach to legacy enablement as its focus is on the data not the application as a first principle. It is a leading edge technology that abstracts data from multiple sources creating a unified virtual data layer that provides easy access to the underling source data. What this allows is for developers to build the new requirements for an application directly from the virtual data layer which sits on top of the legacy application. They can do so using their preferred service oriented architecture tooling and browser technologies sourcing legacy data directly from the virtual data layer without needing to deal with legacy code integration. In other words, data virtualization allows the integration between the modern and legacy components of an application to happen elegantly through the data rather than complexly through the code. In essence, this allows a company to build the new ship while sailing the old. It can evolve its legacy code with the latest programming languages with the integration to legacy applications made easy through the virtual data layer. This provides a much easier and cost effective path to modernizing legacy applications.



Track 3: DB2/SQL



DB2 for i 7.3 update

Tom Mckinley

This session will focus on what's new in DB2 for i, covering the latest features, functions and benefits in 7.3, 7.2, 7.1 and the database technology refreshes. An overview al the new function in all releases will be provided. The new 7.3 content such as: temporal tables, OLAP extensions, additional scalar functions, additional built in global variables and new SQL services, will be covered in more depth.


Advanced SQL Data Manipulation Language Elements

Tom Mckinley

This session will review SQL DML and provide insight into data centric programming via advanced SQL "set at a time" elements and concepts. The presentation covers the coding and implementation of queries that identify, construct and retrieve interesting "sets" of information.


An Introduction to DB2 SQL Performance Tools and Methods

Tom Mckinley

This session will provide an overview of the DB2 SQL performance tools and methods included in IBM i. The presentation will provide particular focus on obtaining value from the index advisor and SQL plan cache - both fully autonomic monitoring and analysis mechanisms available to the database engineer.


An Introduction to IBM Data Studio

Tom Mckinley

This session will introduce and provide an overview of IBM Data Studio - a no charge graphical tool for DB2 data centric design and development. The presentation will cover physical data model development and coding of SQL routines.