COMMON POWERUp 2026: Full Schedule

Unlock the Power of IBM i at POWERUp 2026!

Join us in New Orleans, Louisiana for POWERUp 2026, the premier conference for IBM i professionals. Whether you’re an experienced expert or just starting your IBM i journey, this event offers unparalleled education, hands-on workshops, and valuable networking opportunities. Stay ahead of the curve with insights from industry leaders, explore the latest innovations, and connect with a thriving community that shares your passion for IBM i. Don’t miss this opportunity to expand your knowledge, grow your skills, and power up your career!

10:00am CDT

Intro to SQL

Monday April 27, 2026 10:00am - 11:00am CDT

Studio 1-2

Evaluation Survey

If you're new to SQL or just need a refresher in the basics, this sessoin is for you. We'll explore how to use basic SQL commands to make your everday life easier.

Learning Objectives:

Understand 1. How to create an SQL statement 2. How to run an SQL statement 3. Some "gotcha" when using SQL

Speakers

Kent Milligan

Senior Db2 for i Consultant, IBM

Kent Milligan is a Senior Db2 for i Consultant in IBM Technology Expert Labs. Kent has over 25 years of experience as a Db2 for IBM i consultant and developer working out of the IBM Rochester lab. Prior to re-joining the Db2 for i Expert Labs practice in 2020, Kent spent 5 years... Read More →

Monday April 27, 2026 10:00am - 11:00am CDT
Studio 1-2

Database, Database

Level Beginner

11:15am CDT

Run Away Queries Got You Down?

Monday April 27, 2026 11:15am - 12:15pm CDT

Studio 1-2

Evaluation Survey

Having negative performance impacts from query tools like Query/400, QMF, Showcase, Tableau and others because of the "query from heck" eating up system resources? Is your system open to security exposures from wide-open ODBC type connections? This session will cover options including using the new-ish Db2 Query Supervisor to control and/or audit long-running queries.

Learning Objectives:

1. Learn about the Db2 Supervisor to control and/or audit long running queries. 2. Gain insight into the tools you can use to monitor, tune, and prune queries.

Speakers

Kent Milligan

Senior Db2 for i Consultant, IBM

Monday April 27, 2026 11:15am - 12:15pm CDT
Studio 1-2

Database, Database

11:15am CDT

VS Code for i - Database Extension

Monday April 27, 2026 11:15am - 12:15pm CDT

Galerie 3

Evaluation Survey

This session is a review of the newest and most awesome features added to the VS Code4i Database Extension. This is designed to be an interactive, with questions and comments from the attendees, so be ready to interact, cheer, jeer, or inspire us with your good ideas.

Learning Objectives:

1) Understand what's possible today with the VS Code4i Database Extension. 2) Understand when to use VS Code4i vs other tools 3) Interact with the VS Code4i Database Extension technology leaders

Speakers

Scott Forstie

Senior Technical Staff Member, IBM

Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Architect. He has worked on IBM operating system development since joining IBM in 1989.
Scott is a frequently published author, speaker at industry events... Read More →

Sanjula Ganepola

Software Developer - IBM i App Dev & AI Toolchain, IBM

Sanjula Ganepola is a Software Developer at IBM working on IBM i application development tools. As an open-source advocate, he is an active contributor and maintainer of several Visual Studio Code extensions including IBM i Project Explorer, Code for IBM i, IBM i Testing, Source Orbit... Read More →

Monday April 27, 2026 11:15am - 12:15pm CDT
Galerie 3

Database, Database, Programmer Tools

Track Student

3:15pm CDT

Stepping through SQL Performance

Monday April 27, 2026 3:15pm - 4:15pm CDT

Studio 3-4

Evaluation Survey

Every SQL statement has a predefined steps that it must go through before it can complete you data base requests. Each step taken can positively or negatively impact SQL performance - especially on transactional applications that are running the same set of SQL statements over and over again. This session will explain each step needed to run an SQL statement and the structures that Db2 creates that can impact performance. In addition, this session will review application design and settings that can impact the performance of the required steps.

Learning Objectives:

How Db2 manages the runtime execution of SQL. Differences between the 3 types of SQL: Static, Dynamic, and Extended Dynamic (ie, SQL Packages). Performance difference between SQL Full Opens & Pseudo Opens and the factors that determine when a Full Open must be performed.

Speakers

Kent Milligan

Senior Db2 for i Consultant, IBM

Monday April 27, 2026 3:15pm - 4:15pm CDT
Studio 3-4

Database

4:30pm CDT

20 Hidden Gems of Db2 for i in 20 minutes

Monday April 27, 2026 4:30pm - 4:50pm CDT

Studio 9-10

Evaluation Survey

In this new session you'll discover 20 features of Db2 for i that are typically less known or under used. Your presenter is the Db2 for i Architect and he's lead the Db2 for i development team for decades. Invest 20 minutes to raise for your Db2 for i and SQL capabilities!

Learning Objectives:

1) Discover features, tools, or capabilities within Db2 for i 2) Improve how you leverage or use Db2 for i and SQL on i 3) Extend your Db2 for i knowledge

Speakers

Scott Forstie

Senior Technical Staff Member, IBM

Monday April 27, 2026 4:30pm - 4:50pm CDT
Studio 9-10

Database, Database

Track Student

5:05pm CDT

SQL - Merge Statement

Monday April 27, 2026 5:05pm - 5:25pm CDT

Studio 3-4

Evaluation Survey

Add another tool to your SQL toolbelt with this session on the SQL Merge statement. Discover how a single SQL statement can handle Inserts, Updates, and Deletes. Learning Objectives:

Learn how and when to use an SQL Merge statement

Speakers

Mike Zaringhalam

Developer, PC Richard & Son

Have you ever wanted to meet someone who started Hawaiian Shirt Fridays at their work place?
If the answer is 'Yes!', then feel free to reach out with any questions you have regarding Hawaiian shirts... Or IBM i related topics.
My main focuses are RDi, DB2, Modernization, and D... Read More →

Monday April 27, 2026 5:05pm - 5:25pm CDT
Studio 3-4

Database, Database, Programming: General

5:05pm CDT

Using SQL Triggers to Track File Changes on IBM i

Monday April 27, 2026 5:05pm - 5:25pm CDT

Studio 1-2

Evaluation Survey

Need to know who changed what — and when — in your IBM i files? SQL triggers make it easy! In this fast-paced 20-minute session, you’ll learn how to use SQL triggers to automatically capture file changes (inserts, updates, and deletes) and write them to an output or audit file. Simon will demonstrate how to create, test, and manage SQL triggers using Db2 for i. You’ll see real examples of triggers that record user information, timestamps, and before-and-after values — perfect for building audit trails or debugging data issues. If you’ve ever wanted an “audit log” without changing your application code, this session will show you how quick and powerful SQL triggers can be.

Learning Objectives:

By the end of this session, attendees will be able to: - Understand what SQL triggers are and when to use them. - Create an SQL trigger that writes file changes to an audit/output file. - Capture key details — user, timestamp, and changed values — automatically. - Manage and remove triggers safely in production environments.

Speakers

Simon Hutchinson

Founder & author, RPGPGM.COM

Simon Hutchinson has worked with IBM midrange servers and the RPG programming language since 1988—starting in the U.K. and continuing in the U.S. for over 35 years. He is best known for his long-running blog, RPGPGM.COM, where for more than 12 years he has shared practical insi... Read More →

Monday April 27, 2026 5:05pm - 5:25pm CDT
Studio 1-2

Database, Database

8:00am CDT

SQL Plan Cache Uncovered

Tuesday April 28, 2026 8:00am - 9:00am CDT

Balcony L

Evaluation Survey

This session explains how the SQL Plan Cache is used by Db2 for i to support the execution of your SQL & non-SQL queries. In addition, the session will review Plan Cache related tools & services that can help you identify query performance problems.

Learning Objectives:

Understanding of how Db2 uses the SQL Plan Cache Learn how to use Plan Cache tooling to identify and remedy query performance problems.

Speakers

Kent Milligan

Senior Db2 for i Consultant, IBM

Tuesday April 28, 2026 8:00am - 9:00am CDT
Balcony L

Database

8:00am CDT

Web Services: Pull useful external data into your IBM i applications

Tuesday April 28, 2026 8:00am - 9:00am CDT

Balcony I-J

Evaluation Survey

Obtaining information from external systems or data servers has come a long way since the introduction of EDI in the 1980s! Today, heaps of publicly available web service APIs offer a much more flexible and easier-to-integrate method for pulling pertinent data into your IBM i applications. Whether it be commodity prices, financial data, current weather information, demographic statistics or whatever else you can think of, there's no shortage of information available on the internet that could complement portions of your company's business, adding valuable real-time information to your user applications.

In this session we'll put this concept to work in a hands-on fashion. The presenter will use real-world examples to demonstrate how IBM i developers can quickly find and access public web service APIs to pull data into an RPG program or UI tool using SQL.

Attendees will see three simple 5250-based interactive examples in action, along with source code they can try on their own systems.

Learning Objectives:
- Introduce the concept of pulling data from external web services, and how best to find them
- Understand the difference (and benefits) of using SQL to pull data from RESTful web services, versus "old school" SOAP-based ones
- Master the steps required to integrate a web service-consuming SQL statement into an RPG program or dashboard tool

Speakers

Robert Swanson

Senior Partner, CNX

Rob has worked as an in-the-trenches IBM i developer since 1992, with the past 15 years focused on developing modernization efforts for legacy systems written in RPG. Currently serving as Senior Partner for CNX Corporation in Chicago, Rob is a strong advocate of introducing highly... Read More →

Tuesday April 28, 2026 8:00am - 9:00am CDT
Balcony I-J

Database

9:15am CDT

Elevate your SQL Capabilities with Lateral Joins, Pivots, and Window Functions

Tuesday April 28, 2026 9:15am - 10:15am CDT

Studio 3-4

Evaluation Survey

Take your SQL skills to the next level with this session on Lateral joins, Window functions, and Pivoting. Discover how LATERAL joins simplify complex queries, learn new insights with Window Functions, and master the art of pivoting data for dynamic reporting. Whether you're an SQL pro or beginner, join us to unlock the full potential of these powerful tools and techniques (and get free code).

Learning Objectives:

1. Learn how and when to use the Lateral keyword (along with correlation and cross joins). 2. Learn all the available Window Functions and how/when to use them. 3. Learn what pivoting is and how to setup an SQL procedure to do it dynamically.

Speakers

Mike Zaringhalam

Developer, PC Richard & Son

Tuesday April 28, 2026 9:15am - 10:15am CDT
Studio 3-4

Database, Programmer Tools

10:45am CDT

Revving up SQL Performance with Indexes

Tuesday April 28, 2026 10:45am - 11:45am CDT

Studio 3-4

Evaluation Survey

One of the most important things needed to improve SQL performance is to have the proper indexing over tables, especially as table grow in size. Indexes are so important that the database provides index advice for assistance. However, advice is no substitute for knowledge and proper understanding of indexes. As with all advice, it must be reviewed and good judgment applied on when to create them.

Learning Objectives:

1. Learn about the importance of indexes on SQL performance 2. Learn how to use ACS tools to process Db2 Index Advice 3. Learn a methodology for identifying and ordering the key definition for new indexes.

Speakers

Kent Milligan

Senior Db2 for i Consultant, IBM

Tuesday April 28, 2026 10:45am - 11:45am CDT
Studio 3-4

Database

3:15pm CDT

SQL Views and UDTFs – Powerful Features for masking SQL Complexity

Tuesday April 28, 2026 3:15pm - 4:15pm CDT

Balcony L

Evaluation Survey

SQL has become very powerful. It includes for example recursions, multi-dimensional grouping, OLAP specifications, IFS and Webservice access ... But not everybody will be able to code those complex queries ... and this is not necessary as long as the average programmer or analyst can easily use the queries. With SQL Views complexity can be hidden. Since a SQL View can be used in a SELECT statement like any table even beginners can write reports based on complex SELECT statements. Sometimes information has to be set in the stored SELECT statement. With SQL global variables, values can be set on a job/connection level ... and SQL global variables can be specified within SQL views. How ever, sometimes more than one step is needed to retrieve the desired data. In this situation User Defined Functions (UDFs) or User Defined Table Functions come into play.

Learning Objectives:

In this session you will learn how to generate SQL Views. A lot of examples will demonstrate how even complex queries can be hidden. You will also learn how to call and write User Defined Table Functions

Speakers

Birgitta Hauser

ModEdCon

Tuesday April 28, 2026 3:15pm - 4:15pm CDT
Balcony L

Database, Database

3:15pm CDT

Writing Programs with SQL Procedural Language

Tuesday April 28, 2026 3:15pm - 4:15pm CDT

Galerie 6

Evaluation Survey

SQL includes a full-fledged programming language, SQL PL. Come learn about the programming constructs, including error handling, that this language contains. You will leave with all the knowledge you need to start writing your own SQL functions and procedures.

Learning Objectives:

Learn how to code in SQL PL (Procedural Language) from an RPG programmer perspective. You know how write an RPG IF, CASE, SELECT, loop, etc. but what’s the SQL PL equivalent.

Speakers

Kent Milligan

Senior Db2 for i Consultant, IBM

Tuesday April 28, 2026 3:15pm - 4:15pm CDT
Galerie 6

Database

5:05pm CDT

How many indexes is too many?

Tuesday April 28, 2026 5:05pm - 5:25pm CDT

Galerie 6

Evaluation Survey

The creation of indexes can have a positive impact on query performance. However, an index also has a cost since it has to be maintained every time rows in the associated table are inserted, deleted and updated. This session will the discuss indexing tradeoffs including the review of a benchmark test created to quantify the positive & negative impacts of indexes. In addition, you will learn about tooling that can be used to identify your most valuable and least valuable indexes. "

Learning Objectives:

Understanding of index maintenance considerations. Introduction to tools help you to determine the value of index.

Speakers

Kent Milligan

Senior Db2 for i Consultant, IBM

Tuesday April 28, 2026 5:05pm - 5:25pm CDT
Galerie 6

Database

5:05pm CDT

Make RUNSQLSTM Even Better Using CL Commands

Tuesday April 28, 2026 5:05pm - 5:25pm CDT

Balcony L

Evaluation Survey

The RUNSQLSTM command lets you run multiple SQL statements in a single call, like a script. You can do even more now by calling CL commands directly. See how this can expand your options.

Learning Objectives:

1. Learn how to use the RUNSQLSTM command in CL programs 2. Learn how to call CL commands inside RUNSQLSTM scripts 3. Learn how to handle errors raised when using RUNSQLSTM

Speakers

Vern Hamberg

Senior iSeries Developer, OneMain Financial

Vern has worked on IBM midrange systems for over 35 years, beginning with the System/38 and AS/400. At present he is a Senior iSeries Developer at OneMain Financial. He serves on the Strategic Education Team (SET) of COMMON and is one of the SMEs for Db2. He is also honored to have... Read More →

Tuesday April 28, 2026 5:05pm - 5:25pm CDT
Balcony L

Database, Programming: General

5:05pm CDT

SQL - Final/Old/New Table Statement

Tuesday April 28, 2026 5:05pm - 5:25pm CDT

Balcony K

Evaluation Survey

Have you ever wanted the ability to see which records were affected by an Insert, Update, or Delete statement? Data Change Table References (FINAL/OLD/NEW Table) statements were created for this exact purpose. Join me in this session to learn how to use these statements.Learning Objectives:

Learn how and when to use an SQL FINAL/OLD/NEW Table statement

Speakers

Mike Zaringhalam

Developer, PC Richard & Son

Tuesday April 28, 2026 5:05pm - 5:25pm CDT
Balcony K

Database

9:15am CDT

Visual Explain - IBM's SQL Performance Show-&-Tell

Wednesday April 29, 2026 9:15am - 10:15am CDT

Studio 3-4

Evaluation Survey

For many years now IBM have positioned SQL as the primary interface to the database on IBM i. At the same time, new capabilities are being added only to SQL, not to the native database interface. We need a different tool to understand and analyze query implementation plans and feedback from the optimizer – the SQL component that determines the most effective way to deliver the data we ask for in SQL statements. Visual Explain is just such a tool, and it both shows us graphically what plan the optimizer has chosen, as well as tells us details about each step along the way. It can also give us suggestions on ways to improve performance of our queries. With IBM i 7.6, IBM continue to enhance our ability to manage the database effectively.

Learning Objectives:

1. A brief description of optimization with SQL 2. The several ways of invoking Visual Explain 3. The various panes of the Visual Explain window 4. Some features of Visual Explain for managing how it behaves 5. Examples of improved performance after using suggested changes

Speakers

Vern Hamberg

Senior iSeries Developer, OneMain Financial

Wednesday April 29, 2026 9:15am - 10:15am CDT
Studio 3-4

Database, Programming: RPG

10:45am CDT

SQL and IFS

Wednesday April 29, 2026 10:45am - 11:45am CDT

Balcony L

Evaluation Survey

SQL is great for accessing data located in a relational database. But in a modern world it is also necessary to consume data that is located in the IFS (Integrated File System) or provided by web services With each Technology Refresh IBM introduces and enhances Db2 for i Services. With one of the latest Technology Refreshs provided new SQL Stored Procedures for reading data from and writing Data into the IFS. In composition with other SQL Functions it is easy to scan through IFS files or decompose *.csv files or JSON files or XML documents located in the IFS.

Learning Objectives:

In this session you’ll learn how to write data to the IFS and how to read IFS files, by using no other programming language than SQL. It will be also demonstrated how to access and decompose *.csv files located in the IFS without copying them into a physical file or SQL table.

Speakers

Birgitta Hauser

ModEdCon

Wednesday April 29, 2026 10:45am - 11:45am CDT
Balcony L

Database, Database

3:45pm CDT

SQL Coding Tips & Techniques

Wednesday April 29, 2026 3:45pm - 4:45pm CDT

Galerie 4

Evaluation Survey

SQL is a very powerful language for processing data. There are many ways to write SQL statements to get the desired results. However, not all queries are created equal. This session will compare different ways to approach a problem from an SQL perspective in terms of code maintenance and performance. Taking the right approach for writing SQL helps Db2 for i help you.

Learning Objectives:

Understanding of SQL Set-based processing Learn SQL coding techniques to avoid for poor performances Tools to help capture SQL errors

Speakers

Mike Zaringhalam

Developer, PC Richard & Son

Kent Milligan

Senior Db2 for i Consultant, IBM

Wednesday April 29, 2026 3:45pm - 4:45pm CDT
Galerie 4

Database

Track Student

5:00pm CDT

Panning for Performance Gold with Visual Explain

Wednesday April 29, 2026 5:00pm - 6:00pm CDT

Balcony L

Evaluation Survey

Analyzing your database environment can provide significant performance riches, provided you have the right tools for the job. Visual Explain fits the bill, but learning to understand Visual Explain diagrams can be overwhelming and difficult. This session provides an introductory look into how to read and analyze your Visual Explain diagrams to find SQL performance gold.

Learning Objectives:

`- Identify the various methods of collecting data to produce a Visual Explain diagram - Understand how to understand the flow of data through a Visual Explain diagram - Learn to perform basic query access plan analysis, including learning about various Visual Explain node types

Speakers

Ryan Moeller

Software Engineer, IBM

Ryan Moeller is a software engineer working on Db2 for i, specifically on the SQL Query Engine (SQE) team. He joined the team in the Rochester, MN development lab in 2020. Ryan specializes in SQL, database development, and query performance analysis.

Wednesday April 29, 2026 5:00pm - 6:00pm CDT
Balcony L

Database

8:00am CDT

Streamline SQL Routines

Thursday April 30, 2026 8:00am - 9:00am CDT

Studio 3-4

Evaluation Survey

The SQL procedural language makes it easy to create your business logic in stored procedures, triggers, and user-defined functions. Each of these routines have options that performance, but most programmers usually take the default option values without giving any thought to their impact. Learn about these overlooked performance options and other procedural language coding best practices.

Learning Objectives:

Awareness of options that impact runtime performance.

Speakers

Kent Milligan

Senior Db2 for i Consultant, IBM

Thursday April 30, 2026 8:00am - 9:00am CDT
Studio 3-4

Database

9:15am CDT

Db2 for i Web-Services ? Yes i can!

Thursday April 30, 2026 9:15am - 10:15am CDT

Galerie 4

Evaluation Survey

In a modern world, information gets exchanged over the web.

A request is send and an answer is returned. We do not care where the data is located. On the i data is stored within a relational database. Data access occurs with native I/O or SQL.

What if we could receive the request and provide the data directly by executing a SQL statement?

Wouldn’t that be great?

The HTTP Web Administration GUI interface can be used for deploying SQL Statements as REST APIs while the IBM Db2 acts as RESTful service provider

Learning Objectives:
- Create the integrated web services server
- Deploy the SQL statements as a RESTful web service, including how to define the database properties and how to depose the SQL statements for each HTTP-method
- Manage the deployed services

Speakers

Birgitta Hauser

ModEdCon

Thursday April 30, 2026 9:15am - 10:15am CDT
Galerie 4

Database

Level Intermediate

10:45am CDT

Shallow Dive into Database Modernization

Thursday April 30, 2026 10:45am - 11:45am CDT

Galerie 4

Evaluation Survey

Do you still use DDS to create physical files? Do you create an "extension" file when you need to add a field to an existing file? Are you worried that moving to SQL is too difficult? This session is for you.

Do you need to prevent bad data from getting into your system regardless of how it's being added? This session is for you.

Do you need to mask sensitive data, or protect data from unauthorized users? This session is for you.
If you love working really hard, enjoy cryptic column-oriented codes, or the thought of recompiling all your RPG programs gives you a thrill, then maybe this session isn't for you.

Learning Objectives:
1. Convert DDS physical files to SQL tables
2. Add audit fields that are automatically updated
3. Use constraints to ensure data integrity
4. Use Row And Column Access Control (RCAC) to control access to your data

Speakers

Patrick Behr

Senior Consultant & Instructor, Seiden Group & imPower Technologies

Thursday April 30, 2026 10:45am - 11:45am CDT
Galerie 4

Database

1:00pm CDT

Accelerate your SQL Queries with SMP

Thursday April 30, 2026 1:00pm - 2:00pm CDT

Galerie 4

Evaluation Survey

With Symmetric Multiprocessing (SMP) now available as a no-charge feature in IBM i, you've gained access to a powerful feature that can significantly improve the speed of query execution. However, SMP must be approached carefully, as improper usage may produce lackluster results. This session will cover the inner workings of SMP, when to utilize SMP, and tools for controlling system-wide SMP usage.

Learning Objectives:

`- Understand how the SQL Query Engine utilizes SMP to accelerate query execution - Understand what workloads benefit most from SMP - Understand the controls available to the Database Engineer to control SMP

Speakers

Ryan Moeller

Software Engineer, IBM

Thursday April 30, 2026 1:00pm - 2:00pm CDT
Galerie 4

Database

1:00pm CDT

Inject more security into Db2 for i

Thursday April 30, 2026 1:00pm - 2:00pm CDT

Studio 3-4

Evaluation Survey

In this updated and award-winning session, Scott will explore the many ways that “bad actors” can attempt to subvert the security on IBM i. Whether the topic is protecting against SQL Injection, closing doors to acquiring elevated privileges, or attempting to discover unprotected objects, this session will include techniques for evaluation and protection of your IBM i. Attend this session to take a big step towards discovering and eliminating attack vectors within your IBM i!

Learning Objectives:

1) Understand the attack vectors 2) Learn how SQL can be used to discover whether you're exposed or not 3) Learn a technique for remediating the issue, should it exist

Speakers

Scott Forstie

Senior Technical Staff Member, IBM

Thursday April 30, 2026 1:00pm - 2:00pm CDT
Studio 3-4

Database, Database, Integrated File System (IFS), Security, Systems Management

3:00pm CDT

Fun with JSON Publishing: Letting SQL Do the Dirty Work

Thursday April 30, 2026 3:00pm - 4:00pm CDT

Studio 3-4

Evaluation Survey

If you've ever been tasked as a developer with creating complex responses for an internal or external web service, you've likely explored multiple avenues for generating JSON from your IBM i programs. From constructing responses manually in your RPG code, to using various publicly available toolkits like YAJL, RPG NextGen, etc., there are a myriad of ways to create JSON strings with all the requisite curlies, commas, colons, quotes and hard brackets. If you're on IBM i OS 7.2 or higher, there's yet another avenue you can explore in which you let SQL do all the JSON construction work for you. The biggest benefit of this approach becomes most apparent when your JSON response requires arrays, and especially nested subarrays. Coding such responses can be a bit tedious when done on a record-by-record basis in your program, whereas by using some nifty functions you can can let SQL assemble your JSON response automatically. In this session we'll review the basics of JSON publishing functions such as JSON_Object, JSON_Array, JSON_ObjectAgg and JSON_ArrayAgg. We'll explore some practical use examples for publishing your business data in JSON, letting SQL do all the dirty work.

Learning Objectives:

* Learn the syntax of the most commonly used SQL JSON publishing functions * Understand the differences between a standard SQL select statement and an SQL statement constructing a JSON response * See how to integrate these SQL functions into an RPG program

Speakers

Robert Swanson

Senior Partner, CNX

Thursday April 30, 2026 3:00pm - 4:00pm CDT
Studio 3-4

Database, Database, Programming: RPG

3:00pm CDT

Using SQL to Overcome Challenges when Consuming XML (Case Study)

Thursday April 30, 2026 3:00pm - 4:00pm CDT

Galerie 5

Evaluation Survey

In the new world of mobile data collection by field specialists, we ran head-on into special characters as well as emojis. This case study tells the tale of overcoming the hurdles we were stumbling over to deal with them.

Learning Objectives:

1. Learn what issues can be raised when using mobile devices to collect information from the field 2. Learn how XML support in Db2 for i was used to resolve these issues

Speakers

Vern Hamberg

Senior iSeries Developer, OneMain Financial

Thursday April 30, 2026 3:00pm - 4:00pm CDT
Galerie 5

Database, Programming: RPG

4:15pm CDT

Group By, Having and multi-dimensional Grouping

Thursday April 30, 2026 4:15pm - 5:15pm CDT

Studio 1-2

Evaluation Survey

An SQL SELECT can be much more than a simple SELECT * FROM query. Among others it includes with the GROUP BY clause a powerful data aggregation capability. A bunch of aggregate functions allows to count or summarize rows, to calculate the average over multiple rows, to determine the minimum and maximum row value. The GROUP BY clause may be widely known and used, but the HAVING clause which goes hand in hand with the GROUP BY is often a mystery. There may be other secrets waiting for being revealed … or did you know you can create all kinds of sub-totals and grand-total with an SQL GROUP BY?

Learning Objectives:

In this session you’ll learn the basic use of the GROUP BY and HAVING clauses as well as the use of multiple aggregate functions. You’ll also discover how NULL values can affect the result returned by aggregate functions. It will be demonstrated how easily all kinds of sub-totals and grand-totals can be built. You’ll also learn how to use the CASE clause for building pivot tables

Speakers

Birgitta Hauser

ModEdCon

Thursday April 30, 2026 4:15pm - 5:15pm CDT
Studio 1-2

Database, Database

10:00am CDT

11:15am CDT

11:15am CDT

3:15pm CDT

4:30pm CDT

5:05pm CDT

5:05pm CDT

8:00am CDT

8:00am CDT

9:15am CDT

10:45am CDT

3:15pm CDT

3:15pm CDT

5:05pm CDT

5:05pm CDT

5:05pm CDT

9:15am CDT

10:45am CDT

3:45pm CDT

5:00pm CDT

8:00am CDT

9:15am CDT

10:45am CDT

1:00pm CDT

1:00pm CDT

3:00pm CDT

3:00pm CDT

4:15pm CDT

Get help with the event