In 2017 NEUGC is excited to offer you a choice of one of two great Monday sessions for only $100.00 when included with your regular conference registration!



Deep Dive: Thinking in Sets with SQL and Securing and Tracking Critical Business Data

Presenter: Rob Bestgen, IBM Rochester DB2 Center of Competency

Part 1 - Changing Perspectives − Thinking in Sets with SQL

SQL is a very powerful language for processing data. However, many developers use it the same way they do record level access (RLA) from a native program. While SQL can be used this way, an RLA approach never fully exploits SQL and often results in disappointment. 

This session will explore the concept of thinking in Sets, how the set concept underpins SQL, and how to start thinking in sets when dealing with database.

Part 2 - Taking Care of Data − Securing and Tracking Critical Business Data with Datacentric Security

This session will include an overview of technologies that can be used to respond to the tough data security questions and satisfy the important mandates for securing data.

Structured Query Language (SQL) is a very powerful language for accessing and manipulating data in your DB2 for i databases. In this session, you will learn how to use advanced SQL features to reduce your application development time and boost performance. This session will take your basic knowledge of SQL to a deeper level of sophistication - enabling you to have DB2 for i do more of your work.
This seminar begins by explaining how to fully harness the power of SELECT statements by leveraging constructs such as views, common table expressions, and recursive processing. In addition, you will learn about other advanced query writing techniques.
After this introduction to advanced set processing with SQL, we'll look at how to more efficiently deliver analytics solution with DB2 for i's OLAP support which includes the Rank and Row Number specifications along with the Super Group support.
The seminar will close by showing you how to exploit the integrated XML capabilities that were delivered in the DB2 for i 7.1 release including enhancements that were added after 7.1 was first available.
Tom McKinley 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. Tom was on the original IBM team which designed and built the SQL Query Engine. He is a frequent speaker at COMMON and IBM conferences.

Rob Bestgen is a lead architect working in the heart of the IBM i development lab in Rochester, MN. As chief architect of the DB2 SQL Query Engine (SQE) for DB2 for i, he has directed the team in providing SQE's numerous industry leading capabilities. Rob is also product manager for DB2 Web Query for i, the popular IBM i product for query reporting and analytics. He is a frequent presenter at customer briefings and customer conferences both domestically and internationally.

DEEP DIVE: Procedures and Service Programs from A to Z

Presenters: Jon Paris and Susan Gantner, Partner400 and System i Developer Consortium

It has been many years since Jon coded a subroutine. These days he much prefers to use RPG procedures instead. They make great subroutine replacements and make your programs both easier to read and maintain. The result is applications that are faster to build, easier to debug and more reliable.

But procedures are just the beginning. To fully exploit them in your applications you need to package them into Service Programs so that you can share them easily and efficiently among multiple programs.

In this hands-on workshop, Jon will explain the advantages of using procedures to modularize your code and show you just how to utilize them to best advantage.

We will start with the details of coding procedures - the syntax as well as the best practices for using them as a means of structuring your code. Specifically, we'll explore such questions as:

• What's the benefit of return values?
• Why is local data important?
• Can prototype keywords make my coding life easier?
• Why should I code prototypes in a separate member?

The procedure lectures will be followed by a series of hands-on exercises.
Once we have mastered the art of RPG procedures, we will move on to Service Programs. In addition to details on creating and maintaining them, we'll explore:

• What Service Programs are
• Why you should use them
• How to package your procedures into them
• Simple ways to update them

More hands-on labs will follow. We may not make it all the way from A to Z - but we'll give it a try and at least make it all the way to P!

Jon Paris’s IBM midrange career started when he fell in love with the System/38 while working as a consultant.  This love affair ultimately led him to joining IBM.


In 1987, Jon was hired by the IBM Toronto Laboratory to work on the S/36 and S/38 COBOL compilers. Subsequently Jon became involved with the AS/400 and in particular COBOL/400.


In early 1989 Jon was transferred to the Languages Architecture and Planning Group, with responsibility for the COBOL and RPG languages. There he played a major role in the definition of the new RPG IV language and in promoting its use with IBM Business Partners and Users. Jon left IBM in 1998 to focus on developing and delivering education focused on enhancing AS/400 and iSeries application development skills.


Jon is a frequent speaker at User Groups meetings and conferences around the world, and holds a number of speaker excellence awards from COMMON.


Susan Gantner’s career has spanned over 24 years in the field of application development. She began as a programmer developing applications for corporations in Atlanta, Georgia, working with a variety of hardware and software platforms.  She joined IBM in 1985 and quickly developed a close association with the Rochester laboratory during the development of the AS/400 system.


Susan worked in Rochester, Minnesota for 5 years in the AS/400 Technical Support Center.  She later moved to the IBM Toronto Software Laboratory to provide technical support for programming languages and AD tools on the AS/400. Susan left IBM in 1999 to devote more time to teaching and consulting. Her primary emphasis is on enabling customers to take advantage of the latest programming and database technologies on OS/400.


Susan is a regular speaker at COMMON conferences and other technical conferences around the world and holds a number of Speaker Excellence medals from COMMON.