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)


Charles Guarino presents to NHMUG

Charles Guarino - Thursday February 21st, 2013


So you keep hearing about this great tool RDP (Rational Developer for Power Systems Software) but are somewhat intimidated by the prospect of learning it? This session is a primer on RDP basics, including new terminology, connecting to the IBM i, and getting productive with its features, with a large focus on source code editing. The rich graphical environment far exceeds what PDM and SEU can do, and you will be glad you spent the time learning how to harness its power. The more you use this tool, the more you will want to use it. This session includes a live demonstration of the tool.

From STRPDM to RDP - Awesome RSE Navigation

Of all of the perspectives in RDP, the Remote Systems Explorer perspective is where you will likely spend most of your time. It’s quite possible that you’re not using all of the available tools it offers. Not by a long shot. Attend this session and leap to the next level of application development. Here we will discuss advanced RSE concepts including using filter pools, bookmarks and tasks and using the remote scratchpad, just to name a few.

After attending this session you will possess the skills to watch your RSE productivity soar!

Raising the Bar - A Jumpstart to Using SOAP Web Services in RPG

The Internet abounds with available services using Simple Object Access Protocol (SOAP). The process of consuming these services from your programs is a bit tricky, that is until you use one of IBM’s latest tools WSDL2RPG, which is a component of Integrated Web Services (IWS). This tool does the heavy lifting for you and sets up an entire environment with a callable RPG service program. And the best part is this V5R4 and above tool is FREE! Refuse to be intimidated! In this session we’ll work with the tool and review step-by-step the process of testing and consuming a SOAP web service and displaying its information in a working RPG display program. Learn how you can leverage this technology so your applications can explode beyond your own four walls and gain access to vast information resources on the web in real-time. Here is a great place to start your learning - http://www-03.ibm.com/systems/i/software/iws/documentation.html

i Can Serve You - Providing Web Services From Your IBM i

Now that you’ve been consuming web services directly get ready to turn the tables and become the web service provider. Using IBM’s Integrated Web Services server for ILE you too can launch programs to access your database and provide your system’s information to external user such as web developers. We will go step by step through the process of creating a program to receive a parameter and return database values. Next we will implement this program on to the built-in web services server and demonstrate how to test and deploy it using IBM’s graphical Web Administration tool. Since the tool is wizard-driven deploying web provider side web services is a snap!


With an IT career spanning over 25 years, Charles Guarino has been an enterprise application consultant for most of them. Since 1995 he has been founder and President of Central Park Data Systems, Inc., a Long Island based IBM midrange consulting company. He has published numerous technical and strategic articles for the IT community and speaks each year at conferences and user groups across the country. He was inducted into COMMON’s Speaker Excellence Hall of Fame in 2008 and also selected as one of LISTnet's Long Island’s Twenty Top Techies for 2009.

Charles is currently a COMMON Application Development Subject Matter Expert and President and monthly Q&A host of LISUG, a Long Island IBM System i Users Group.