Contact | Privacy Policy
Virtual RPG & DB2 Summit
October 28 — November 3, 2020
Sponsors & Special Offers
News Headlines
October 13, 2020
New sessions added to Session Grid for October 2020 Virtual RPG & DB2 Summit.
September 28, 2020
Session Grid posted for October 2020 Virtual RPG & DB2 Summit.
July 14, 2020
New Hands-On Live! series features in-depth 1-day workshops on 10 vital IBM i development skillsets.
May 4, 2020
System i Developer hosts no-charge Summit Lunch & Learn Series, May 19 - June 17, 2020
February 6, 2020
2020 IBM i Champions Named: Congrats to Ted Holt, Scott Klement, Liam Allan, Alan Seiden, Mike Pavlak, Stephanie Rabbani, Charles Guarino, Susan Gantner, Jon Paris & Paul Tuohy!

DB2-Oriented Sessions

Advanced SQL Coding

Here we will dig into some more advanced SQL topics such as scalar functions, common table expressions, some DDL topics, and more.

Speaker: Sue Romano

30 SQL Tips in 60 Minutes

SQL is THE data access language. It runs interactively from green screens and System i Navigator. It's in RPG and COBOL programs, in ODBC and JDBC. It's ubiquitous, and it's everywhere, too! You can't know too much about SQL. In this session, Ted Holt presents an assortment of powerful, effective, and easily implemented SQL tips and techniques.

These tips and techniques are based on DB2 for i, but many of them apply equally to other platforms. There's something for everyone, from the SQL novice to the advanced user. Come learn some new techniques and reacquaint yourself with some you may have forgotten.

Speaker: Ted Holt

Getting Quick Wins on Improving SQL Performance

This session will provide an overview of the DB2 SQL performance tools and methods included in IBM i.

The presentation will provide particular focus on obtaining value from Visual Explain, the Index Advisor and the SQL Plan Cache. These options leverage 'always available' information to make powerful tools readily available to the database engineer.

Speaker: Kent Milligan

Access Client Solutions (ACS) for Programmers

Access Client Solutions is a powerful tool for programmers. ACS replaces and enhances much of the functionality originally supplied by Navigatorfor i.

This session discusses how ACS can be used by programmers; including

  • System Configuration
  • 5250 Emulator
  • SSH Terminal
  • Integrated File System
  • Printer Output
  • Schemas
  • Run SQL Scripts
  • SQL Performance Center

Speaker: Paul Tuohy

IBM i (SQL) Services for the Developer

IBM i services provided by Db2 for i can be used to access system information that is useful for developers. In the past you may have considered using CL or coding to system APIs to access and work with some system information. Today there is a better option: SQL.

In this session you will learn how to use SQL to work with data areas and data queues, discover how easy it is to review your program and service program attributes, and more. Just wander over to to get an advance look at what is available!

Speaker: Sue Romano

What's new in Db2 for i - Data Centric features

Implementing a data-centric approach to development allows you to let the database manage and secure your data automatically. Using database features like triggers, constraints, temporal tables, generated columns, and RCAC improves both the agility and flexibility of your database and ensures data integrity and security.

Each new technology refresh brings a new round of Db2 for i enhancements, features and tools. This includes both enhancements to existing data-centric technologies as well as introducing new data-centric tools to your toolbox. This session will cover both new functions provided in recent technology refreshes as well as some choice enhancements from the recent past you may have missed.

Stay current and take advantage of the new features to let the database work for you so you don't have to!

Speaker: Sarah Mackenzie

Designing a Modern Database on IBM i

Description to follow shortly

Speaker: Paul Tuohy

Db2 for i - Strategy, Enhancements & more - including 7.4!

I own the Db2 for i development strategy, plan and team. It's always a sunny day in the database, even if it is frigid outdoors in wonderful Rochester, Minnesota.

In this session, I will explain how and why Db2 for i has changed in recent years. I'll also look ahead to some of the new features yet to come in the recently announced TRs for 7.4 and 7.3 as highlighted here

Beyond delivering major feature enhancements in IBM i operating system releases, the database team typically delivers enhancements on a twice-per-year cadence via Db2 PTF Groups.

Attend this session to hear about the many enhancements to SQL on i, SQL Query Engine, IBM i Services and more.

This session ends with an overview of the recent enhancements to Db2 for i.


Speaker: Scott Forstie

Getting the Most Out of SQL Joins

This session discusses the different types of SQL joins and how to use them. It will also explain how joins work in general and help to clear up some of the most commonly experienced confusion developers have. Pick the right join type for the job.

Speaker: Kent Milligan

Hidden Gems in Db2 for i

The IBM i team has been delivering new function two times per year since 2010. New releases and technology refreshes deliver a broad range of function and sometimes the smallest line items can be easily missed.

In this session, Sarah and Sue have assembled some of their favorite hidden gems; things that you might have missed but should know.

Start your day right with Db2 for i.

Speaker: Sarah Mackenzie and Sue Romano

Best practices for the SQL developer

Wisdom is typically gained through a commitment to repeatedly encounter, endure and finally overcome failure.

In this session, Paul and Scott will share several best practices for SQL development on Db2 for i. Take advantage of this rare opportunity to avoid some bruised knees that go along with being an SQL programmer.

Paul and Scott will cover such topics as proper definitions for SQL Procedures and Functions, using IBM i Access Client Solutions (ACS) to your advantage as an SQL programmer, and much more.

Speaker: Scott Forstie and Paul Tuohy

Db2 Web Query for the RPG/SQL Developer

While Db2 Web Query might be thought of as a Query/400 modernization tool, it is actually much more than that. If you're a developer writing code for reporting purposes, or building extracts to push data out, or even frustrated with run-away queries, this session will provide some insights into simplifying your world.

Speaker: Doug Mack

All New: 30 MORE SQL Tips in 60 Minutes

You may have seen Ted's ever-popular "30 SQL Tips in 60 Minutes" session before. It turns out Ted has more than 30 SQL tips up his sleeve!

In this all-new second edition, Ted explores yet another set of 30 practical SQL tips.

As in the original SQL tips session, these tips and techniques are based on DB2 for i, but many of them apply equally to other platforms. There's something for everyone, from the SQL novice to the advanced user. Come learn some new techniques and reacquaint yourself with some you may have forgotten.

Speaker: Ted Holt

Home | RPG & DB2 SUMMIT | About Us | System i Community | Privacy Policy | Legal Notices | Email Webmaster | Contact
System i Developer,LLC © 2019