Loading…
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!

Venue: Room 5 clear filter
arrow_back View All Dates
Thursday, May 22
 

8:00am PDT

Improving Software Quality via Development and Testing
Thursday May 22, 2025 8:00am - 9:00am PDT
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
avatar for Scott Klement

Scott Klement

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

9:15am PDT

IBM Navigator for i – As seen by Scott
Thursday May 22, 2025 9:15am - 10:15am PDT
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
avatar for Scott Forstie

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

1:30pm PDT

How Refactoring Helps Bulletproof Your Application
Thursday May 22, 2025 1:30pm - 2:30pm PDT
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
avatar for Scott Klement

Scott Klement

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

3:00pm PDT

ListAgg and Split – Grouping, Aggregating and Dividing again
Thursday May 22, 2025 3:00pm - 4:00pm PDT
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
avatar for Birgitta Hauser

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

5:00pm PDT

Tame the IFS with SQL Services
Thursday May 22, 2025 5:00pm - 6:00pm PDT
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
avatar for Scott Forstie

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 5:00pm - 6:00pm PDT
Room 5 1150 Magic Way, Anaheim, CA 92802
 
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Filtered by Date -