Meeting Information

Select Meeting  


Meeting Date
Wednesday, May 20, 2015




at the Milleridge Inn, Quaker room
in Westbury, Long Island


The Presession starts at 5pm
The Networking and Cocktail hour starts at 6pm

Click here to Register and Pay using Paypal (Save $$$)

Payment can be made at the door (cash or check only)!



2:00pm: Embedded SQL in RPG - Beyond the Basics

Paul Tuohy
ComCon

Presentation Description

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
* Mastering Multi Row Fetch
* Handling NULL
* Dates, Times and Timestamps


About Paul Tuohy

Paul Tuohy has worked in the development of IBM Midrange applications since the 70s. He has been IT manager for Kodak Ireland Ltd. and Technical Director of Precision Software Ltd. As well as being CEO of ComCon he is also one of the co-founders of System i Developer, a consortium of top experts and educators on i technology. He has been teaching and lecturing since the mid-80s. Paul is the author of "Re-engineering RPG Legacy Applications", "The Programmers Guide to iSeries Navigator" and the self teach course "iSeries Navigator for Programmers". He also writes regular articles for most of the industry publications and is one of the quoted industry experts in the IBM Redbook "Who knew you could do that with RPG IV?"



4:00pm: Externalizing Database Processing in RPG IV

Paul Tuohy
ComCon

Presentation Description

One of the major considerations for the ongoing modernization of applications is how to make functionality accessible to multiple interfaces. But no matter how the application interfaces may change (green screen, web, client server, mobile phones etc.) or how data may arrive on the system (FTP, EDI, XML etc.) you can be sure that all of the data is going to end up in a database.
Externalized database processing provides a means of encapsulating database access. This session discusses why you may want to externalize database processing in RPG IV and how to do it.

About Paul Tuohy

Paul Tuohy has worked in the development of IBM Midrange applications since the 70s. He has been IT manager for Kodak Ireland Ltd. and Technical Director of Precision Software Ltd. As well as being CEO of ComCon he is also one of the co-founders of System i Developer, a consortium of top experts and educators on i technology. He has been teaching and lecturing since the mid-80s. Paul is the author of "Re-engineering RPG Legacy Applications", "The Programmers Guide to iSeries Navigator" and the self teach course "iSeries Navigator for Programmers". He also writes regular articles for most of the industry publications and is one of the quoted industry experts in the IBM Redbook "Who knew you could do that with RPG IV?"



7:00pm: IBMi Announcements

Steve Fier
IBM Corp.

Presentation Description

IBMi Announcements

About Steve Fier

Steve Fier has been with IBM over 30 years, initially starting as a systems engineer, and then becoming a senior marketing specialist. His current role is POWER Platform Leader for the Northeast responsible for former System i and System p products. Steve’s areas of expertise include application development, DB2 for i, Windows Integration, and Server Consolidation. Over the years, Steve has been a frequent and well received presenter at LISUG.



7:00pm: Panel Discussion-Application Modernization

Speaker Panel


Presentation Description

Pannel Discussion Featuring Trevor Perry, Floyd Del Muro and Paul Tuohy

About Speaker Panel




8:00pm: Development Strategies on Power

Paul Tuohy
ComCon

Presentation Description

In this session, Paul Tuohy discusses the key factors in determining development strategies on Power systems. The challenges facing companies, as they progress through different levels of modernization, are many. How does a company change from a traditional development and maintenance environment to a more robust, modern development environment? What is new, what is different, what are the major and minor obstacles. Paul also discusses the challenges faced by developer and what makes a modern developer on Power systems.

About Paul Tuohy

Paul Tuohy has worked in the development of IBM Midrange applications since the 70s. He has been IT manager for Kodak Ireland Ltd. and Technical Director of Precision Software Ltd. As well as being CEO of ComCon he is also one of the co-founders of System i Developer, a consortium of top experts and educators on i technology. He has been teaching and lecturing since the mid-80s. Paul is the author of "Re-engineering RPG Legacy Applications", "The Programmers Guide to iSeries Navigator" and the self teach course "iSeries Navigator for Programmers". He also writes regular articles for most of the industry publications and is one of the quoted industry experts in the IBM Redbook "Who knew you could do that with RPG IV?"