Vermont Midrange User Group 

VTMUG logo Thirteenth Annual Technical Conference
Thu, Sep 21, 2017
Conference
Home
Register Speakers  Sessions  Session Grid Sponsors  Hotel &
Directions 
Cancel
Registration 
Exhibitor
Information 
Session Descriptions

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

 

Track 1: RPG Programming

 

 


Opening Session: IBM i in the Age of Digital Transformation

Alison Butterill

IBM i is uniquely positioned to support modern environments and modern technologies, allowing clients to achieve and maintain a competitive advantage in their business. Whether it is providing mobile interfaces, executing data analytics or harnessing the power of IBM Watson in your own applications, IBM i can do it! This presentation will cover the latest trends and directions in the marketplace and describe how IBM i is not only prepared for these trends, but how we are ahead of the curve!

 


Embedded SQL in RPG - Beyond the Basics

Paul Tuohy

You have been using embedded SQL in RPG. You have mastered the syntax, tried a few selects, declared a cursor, performed an update - you may even have tried some dynamic SQL!

Time to take it to the next stage and see what you can do with embedded SQL - beyond the basics

Topics covered in this session include:

  • Discussion of the key points in writing powerful embedded SQL
  • What tools should you use to write and test SQL prior to embedding it?
  • Controlling CRTSQLRPGI
  • SQLCA and SQLCODE considerations
  • Getting data without SELECT - GET DIAGNOSTICS and VALUES INTO
  • Talking to Watson with Embedded SQL
  • Mastering Multi Row Fetch
  • Handling NULL
  • Dates, Times and Timestamps


This session assumes you are familiar with and have basic experience embedding SQL in RPG.

 


RPG Tricks and Techniques

Paul Tuohy

This session covers tricks and techniques for the RPG IV programmer. Come to this session and learn some of the things that you may not have known about

  • The H Spec and the D Spec
  • Compiler Directives
  • Sorting Arrays
  • Using dynamic memory allocation
  • Using integers
  • Using indicators
  • Triggers
  • Constraints
  • Record Locking techniques
  • Other bits and pieces

 


Programming RPG With Style

Paul Tuohy

In this session, Paul discusses the what and why of standards and guidelines for modern RPG development. Topics include:

  • Make Use of the Tools
  • RPG is FREE
  • Modern RPG Programs and Subprocedures
  • What is in a Name?
  • Comments
  • Structuring Code
  • Use Templates and Qualified Data Structures
  • Qualify Wherever Possible
  • Strings
  • Subroutines
  • Out With The Old
  • Embedded SQL
  • Global Definitions
  • Parameters, Prototyping and Procedure Interfaces
  • The Integrated Language Environment
  • Roll Your Own

 

 

Track 2: Web Programming

 

 


Opening Session: IBM i in the Age of Digital Transformation

Alison Butterill

IBM i is uniquely positioned to support modern environments and modern technologies, allowing clients to achieve and maintain a competitive advantage in their business. Whether it is providing mobile interfaces, executing data analytics or harnessing the power of IBM Watson in your own applications, IBM i can do it! This presentation will cover the latest trends and directions in the marketplace and describe how IBM i is not only prepared for these trends, but how we are ahead of the curve!

 


Intro to Node.js

Aaron Bartell

Abstract: Node.js is here. Yep, Javascript on the server side of things. Is this a good thing? That's what we'll be looking to decipher as we walk through the following points at a high level, all the while relating it to the RPG programmer mindset to more easily draw similarities.

And seriously, Javascript is employment insurance. You have life insurance and car insurance, and, and, and; well, why not employment insurance. Learn something (Javascript, and inherently Node.js) that is applicable to every single website on the internet.

In this session we will learn about the following:

  • Why Node.js? We already have Java, PHP, Ruby.
  • How to obtain and install Node.js
  • Make Node talk to your RPG and DB2
  • What's this i/o blocking stuff I hear about Node.js?
  • Javascript syntax - brief intro
  • Javascript callbacks - they're everywhere, but how do they affect your programming in Node?
  • Create a simple ‘hello world’ app without using frameworks.

 


Node.js transacts with DB2 and RPG

Aaron Bartell

Abstract: When IBM introduced Node.js to IBM i they included a full fledge DB2 for i database driver written directly against the SQL CLI APIs. No middle layer JDBC or MySQL in the mix. They also provided the iToolkit, a seamless way to call RPG (or any other type of resource or program on IBM i) directly from Node.js. Very cool. This means adopting Node.js does not mean abandoning your huge investment in RPG; instead you can revitalize it. That makes good business sense. In this session we will do the following:

  • Walk through the various features and ways to communicate with existing DB2 tables directly from Node.js.
  • Talk about blocking and non-blocking database i/o
  • How to interface with DB2 for i Services to create a cool realtime WebSockets app that displays WRKACTJOB type information
  • Introduce XMLSERVICE and its feature set.
  • Walk through the various features and ways to communicate with existing RPG programs directly from a Node.js program that is running on the same IBM i!
  • Show how to do iterative development using the Node.js REPL capabilities (programming in a real-time response environment) - a great tool and approach for learning how to code in
  • Learn how to modularize your Node.js calls to RPG to make them reusable.
  • Discuss how to make stateful requests to an RPG *SRVPGM.

 


Building Your First Node.js App With Expressjs

Aaron Bartell

Abstract: Node.js is a hot topic in IBM i circles because of its recent port. Doing a 'Hello World' app in Node.js is very simple, but what about developing something more substantial with full model-view-controller capabilities? This session aims to take you beyond your first pass at Node.js and show how to use one of the most popular Node.js web frameworks, Express.js. In this session we will learn about the following:

  • Installing Expressjs with npm (Node Package Manager)
  • Model: DB2 for i access
  • View: Template Engines and how to use them
  • Controller: Routing requests
  • Implement web sockets to make the app insanely interactive

 

 

Track 3: DB2/SQL

 

 


Opening Session: IBM i in the Age of Digital Transformation

Alison Butterill

IBM i is uniquely positioned to support modern environments and modern technologies, allowing clients to achieve and maintain a competitive advantage in their business. Whether it is providing mobile interfaces, executing data analytics or harnessing the power of IBM Watson in your own applications, IBM i can do it! This presentation will cover the latest trends and directions in the marketplace and describe how IBM i is not only prepared for these trends, but how we are ahead of the curve!

 


Cool Things you can do with DB2 Web Query for i

Doug Mack

You own it. Are you using it? Did you know you can….

  • Run a Query/400 report from a spreadsheet?
  • Place a map on a dashboard displaying key performance indicators by geography?
  • Spin up an installation in minutes with the new EZ-Install Package?
  • Replace 50 Query/400 reports with a single auto-drill down report for your business analysts?
  • Create visualizations over key system utilization metrics like CPU utilization across multiple LPARs/Systems?
  • Build data warehouses or data marts with automated data transformation and replication capabilities?

This session will provide updates on some of the new DB2 Web Query capabilities.

 


Stop Building Extracts! Automate Data Preparation

Doug Mack

The biggest challenge of providing business information to business analysts, or interface to Watson or open source databases, or moving data to another platform to support a different application - is not about data replication - it’s about data TRANSFORMATION. This is because business rules and data meaning is locked up in RPG code. But through DB2 tools you can build a meta data based transformation and replication capability to automate data preparation and replication, and document those business rules locked up in RPG code.

 


What’s New with DB2 for i

Doug Mack

This session will include an exploration of the latest DB2 for i capabilities. DB2 for i includes data-centric, analytic, security and performance improvements that can be used without disrupting application infrastructures. As an integrated database, many of these technologies can be deployed within minimal investment. Learn about some of the new features in DB2 for i 7.3 and how you can take advantage of them!