Rick Flagler - DB2 Web Query

Rick Flagler - Wednesday February 12, 2014

DB2 Web Query

DB2 Web Query is included with IBM i if you originally had Query/400. Each site is entitled to at least give the Express version a test-drive. The capabilities of WQ far exceed that of Query/400 however, enabling powerful business intelligence reporting. This includes everything from "standard greenbar reports" to Key Performance Indicators, charts, graphs and more - all easily created with the WQ tooling. Learn about the capabilities and see examples of how this might improve reporting in your organization.


Rick Flagler is a consultant, trainer and mentor, focusing on DB2 performance, business metric development and DB2 Web Query. Rick has held IT management positions with The Timken Company and MPB Corporation, leading software development and installing ERP systems from SAP, Oracle and INFOR. Starting with the System/38, Rick is a long-time and enthusiastic supporter of IBM i on the POWER platform. Rick guided MPB Corporation through their Y2K project, achieving on-time/under budget success. He's an experienced project manager, skilled in database management and user interface design. He specializes in transforming data to knowledge using business metrics and database tools. He is president/owner of Rick Flagler IT Consulting.

Mike Pavlak to host PHP Workshop at NHMUG user group meeting

Mike Pavlak - Thursday November 7, 2013

Bring your own device PHP Workshop

This is a full day session where the students bring their own laptops and connect to an IBM i LPAR running PHP in the cloud. The workshop includes 4 presentations with 4 corresponding hands on lab sections covering all of the fundamentals of PHP like variable use, arrays, function declarations and calls and more. As IBM i is a significant part of our goals in these discussion we will explore the use of the new Open Source toolkit for calling RPG programs and CL Commands as well as database access using DB2 and MySQL. We will also explore the Object Oriented model of PHP.

Workshop Agenda:

Section 1

  • Introduction to PHP Language Syntax
  • Introduction to HTML
  • Iterative processes in PHP
  • Zend Studio Setup

Section 2

  • PHP Functions
  • Array processing

Section 3

  • Data Access using DB2
  • Data Access using MySQL

Section 4

  • Introduction to Object Oriented PHP
  • Open Source Toolkit
  • IBM i program call from PHP using CL Command execution

Section 5 (Bonus - Time permitting)

  • Overview of Mobile
  • Introduction to MVC
  • Demonstration of Connected Mobile Solutions


Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Mike joined Zend Technologies as a Solutions Consultant working with the IBM sales team in 2008 and enjoys helping IBM i customers explore PHP as a state of the art solution for application modernization. In addition to several roles as a volunteer with COMMON the premier IBM midrange user group, Mike also teaches PHP classes part time at Moraine Valley Community College in Suburban Chicago.

Mike lives in suburban Chicago with his wife, five kids, two dogs, two cats, a leopard spotted gecko, Russian tortoise, two rabbits, and a half dozen fish.


Tom McKinley presents SQL topics at NHMUG

Tom McKinley - Wednesday September 25, 2013

SQL routines - procedures, functions and triggers

While many developers know how to use SQL to query and process data, many are not aware that they can use SQL as a procedural language for programming business logic.

In this session, we will explore the capabilities of the SQL procedural language and its usage in data-centric programming with SQL procedures, functions, and triggers.

Temp tables, good or bad idea?

Even though SQL is a powerful language for processing data sets, many developers utilize temporary tables to break a complex request into multiple, smaller steps. While solving a problem with multiple steps is a valid approach, multi-step solutions involving temporary tables can negatively impact performance.

This session will illuminate these performance issues as well as demonstrate how advanced SQL features such as Views and Common Table Expressions can be used as an alternative to deliver multi-step solutions without the performance baggage.


Tom is an IBM Lab Services Consultant working on DB2 for IBM i in Rochester MN. His main focus is complex query performance associated with Business Intelligence running on Very Large Databases. He worked as a developer or performance analyst in the DB area from 1986 until 2006. Some of his Major pieces of work include the Symmetric Multiple processing capabilities of DB2 for IBM i as well as Large Object Data types. In addition he was on the original team that designed and built the SQL Query Engine. Prior to Database he worked on Licensed Internal Code for System 34 and System 36.

Tom is a frequent speaker at COMMON and IBM conferences.


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

Thursday, June 6, 2013 - Fireside Inn, West Lebanon NH

This event was free and sponsored by IBM, NHMUG and VTMUG.

IBM Announcements - Steve Fier, IBM

Steve Fier will review the latest IBM Power Systems and IBM i announcements and how our customers are using these new technologies. As IBM i shops upgrade to newer releases like IBM i 6.1 and 7.1 before V5R4 goes to end-of-support in a few months, people are asking "What's new in IBM i and how will this make my life easier?"

A programmer's future: Looking back to see the future - Pete Massiello iTech Solutions

This session looks back at the history of programming and computing. We examine the skill sets that programmers required in the past, examine the skills of those programmers entering the market, and what is required of today's programmers to compete in the future. If you don't invest in yourself, your skills don't remain static, they actually slowly deteriorate compared to the market. We are taking a light hearted look at what we need to do with our careers to compete and excel in today’s market.

I Didn't Know You Could Do That Using SQL - Skip Marchesani

Tired of writing a one-time RPG program with many lines of code to do special or unique things with your tables and data? In many cases you can use SQL instead.

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, and you will also learn how to use CASE and UNION statements.

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.

The Why and How of the iModernize(d) Application Architecture - David Andruchuk CSDA, inc

For most IBM i shops an ongoing initiative is to take advantage of the new offerings IBM has made to the IBM i hardware and software that has defined and set our platform apart from the competitors. The process of converting your non data centric architecture to a data centric architecture can appear to be beyond the reach of many IT staffs.

While the performance gains of modernizing can be easily quantified, the added benefit of flexibility often goes unheralded. Being able to provide faster response to constantly changing business requirements and ever increasing large data demands placed on our environments can be achieved without having to recompile your current programs. Adapting your database access and software development practices is as much a necessity as changing your business to constantly changing market requirements.

In this session we will discuss:

  • The process of converting your DDS defined PF and LFs to DDL defined tabkes, views and indexes
  • Taking advantage of the scalability and flexibility gains offered by modern technologies, both in hardware and in software engineering
  • Adopting the use of views and stored procedures to gain separation between your data model and your programs
  • Designing your system to become easier to implement your web based or graphical UI layer
  • Real life examples of flexibility and performance gains achieved on the path of IBM i(ntegration)