26th Annual New Hampshire / Vermont IBM i User Group Meeting
Thursday, June 6, 2013 - Fireside Inn, West Lebanon NH.
This event is free and sponsored by IBM, NHMUG and VTMUG. Please register in advance so we have an accurate headcount for lunch.
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?"
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. You will also learn how to use CASE and UNION statements, and where to use Full Outer Join and Hidden Time Stamp columns.
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)