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)