COMMON POWERUp 2025: Full Schedule

Unlock the Power of IBM i at POWERUp 2025!

Join us in Disneyland, California, for POWERUp 2025, 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!

arrow_back View All Dates

8:00am PDT

Improving Software Quality via Development and Testing

Thursday May 22, 2025 8:00am - 9:00am PDT

Room 5

Do you know all of the things you should be considering when writing and testing your software? In this session, testing expert Yvonne Enselman teams up with programming expert Scott Klement to discuss all of the things you should be considering when testing your software if you want to achieve the highest quality result.

Although examples are provided in RPG, the concepts discussed in this session apply to software development in all environments.

Speakers

Scott Klement

Managing Partner, ORC LLC

Thursday May 22, 2025 8:00am - 9:00am PDT
Room 5 1150 Magic Way, Anaheim, CA 92802

Program Testing

9:15am PDT

IBM Navigator for i – As seen by Scott

Thursday May 22, 2025 9:15am - 10:15am PDT

Room 5

In this new session, Scott will explore IBM Navigator for i features and demonstrate how this feature rich GUI is built upon the shoulders of SQL. We’ll spend time exploring new Navigator features, as well as the well-established. Finally, Scott will show how users can start with Navigator, but finish with VSCode4i or ACS, for those situations not handled by Navigator.
https://www.ibm.com/support/pages/ibm-navigator-i

Speakers

Scott Forstie

STSM, Db2 for i Architect, 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 →

Thursday May 22, 2025 9:15am - 10:15am PDT
Room 5 1150 Magic Way, Anaheim, CA 92802

Systems Management

1:30pm PDT

How Refactoring Helps Bulletproof Your Application

Thursday May 22, 2025 1:30pm - 2:30pm PDT

Room 5

Old program code creates technical debt and makes it difficult to maintain robust applications. In this session, we will discuss what refactoring is and how it is important to creating applications that are robust and "bulletproof." We will show an example of rewriting an old monolithic program in a new modular style, and explain the different aspects of it and how it allows for better testing and quality assurance.

This is a joint session between programming expert Scott Klement and software testing expert Yvonne Enselman, allowing you to see refactoring from both a tester and programmer perspective.

Although some RPG examples are provided, the concepts apply to any software coded in any environment.

Speakers

Scott Klement

Managing Partner, ORC LLC

Thursday May 22, 2025 1:30pm - 2:30pm PDT
Room 5 1150 Magic Way, Anaheim, CA 92802

Program Testing

3:00pm PDT

ListAgg and Split – Grouping, Aggregating and Dividing again

Thursday May 22, 2025 3:00pm - 4:00pm PDT

Room 5

Almost everybody working with SQL knows the GROUP BY specification for accumulating identical information. Those queries are quite often combined with aggregate functions such as SUM() or AVG().
With the multi-dimensional grouping it is possible to also add all kinds of sub-totals as well as a grand total to the queries.
In composition with CASE clauses it is possible to accumulate information and return the data in different columns, for example monthly or quarterly sales per customer. Pivot tables can be easily created … as long as the number of output columns is fixed.
Sometimes, however, we have to accumulate information that is located in multiple rows in a single row, for example all items in an order. Unfortunately, the number of output columns (i.e. Items) may differ. However, with the LISTAGG aggregate function a string containing the different information separated by a comma (or any individual separation string) can be built.
As far as good … but how to split a string with multiple information separated by a comma or any other individual separation string? No problem with the SPLIT service! … in composition with other services even *.csv files located in the IFS can be decomposed

Speakers

Birgitta Hauser

Database and Software Architect, IBM Champion, Birgitta Hauser - Modernization - Education - Consulting

Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →

Thursday May 22, 2025 3:00pm - 4:00pm PDT
Room 5 1150 Magic Way, Anaheim, CA 92802

Database

5:00pm PDT

Tame the IFS with SQL Services

Thursday May 22, 2025 5:00pm - 6:00pm PDT

Room 5

In this session, you will discover how SQL and IBM i (SQL) Services can be used to bring order to the IFS. Whether you aim to further secure, manage, or utilize the IFS, SQL can help get the job done. The Db2 for i team has made consistent and noteworthy investments to bring SQL capabilities that can be used with the IFS. Come to this session to see, understand, and be ready to use SQL with the IFS.

Speakers

Scott Forstie

STSM, Db2 for i Architect, IBM

Thursday May 22, 2025 5:00pm - 6:00pm PDT
Room 5 1150 Magic Way, Anaheim, CA 92802

Integrated File System (IFS)