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!
Type: Database clear filter
arrow_back View All Dates
Tuesday, May 20
 

8:00am PDT

SQL Coding Tips and Techniques
Tuesday May 20, 2025 8:00am - 9:00am PDT
North Ballroom A
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.
Speakers
avatar for Kent Milligan

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 →
Tuesday May 20, 2025 8:00am - 9:00am PDT
North Ballroom A 1150 Magic Way, Anaheim, CA 92802
  Database

9:15am PDT

ILE Concepts - and Analyzing ILE Objects with IBM i/Db2 Services
Tuesday May 20, 2025 9:15am - 10:15am PDT
South Ballroom B
Programs, Modules, Service Programs, Internal and exported Functions and Procedures, Binding Directories ... in short ILE Concepts are necessary for a modular and modern programming in RPG and other ILE messages. But ... sometimes still a mess.
Once the Concepts are understood and used, programs can easily be created by putting "puzzle pieces" pieces together, i.e. calling functions and procedures.
But how to analyze our ILE Objects, i.e. where are our procedures/functions located, which modules are bound to what (service-)programs etc?
The good news is, IBM provided in the last releases and technology refreshes a lot of powerful IBM and Db2 Services.
Among these services are also all kinds of Services for analyzing and managing ILE Objects.
This session combines an introduction into the ILE Concepts and shows what services are available for analyzing the ILE Objects (modules, programs, service programs, modules …)
 
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 →
Tuesday May 20, 2025 9:15am - 10:15am PDT
South Ballroom B 1150 Magic Way, Anaheim, CA 92802
  Database

10:45am PDT

Database Modernization – An Evolution Not Revolution
Tuesday May 20, 2025 10:45am - 11:45am PDT
Magic Ballroom 2
Modernizing applications and neglecting the database? Think converting from DDS to DDL is enough database modernization? It may be enough, although there’s more to the database than the way it’s defined. This session explores database modernization techniques from an evolution perspective for continuous change. And, how that type of database modernization compliments application modernization.
Speakers
avatar for John Westcott

John Westcott

Db2 for i Consultant and Team Lead, IBM
John Westcott is the Db2 for i Team Lead in IBM Technology Expert Labs. John is highyly skilled in SQL, RPG, Data Analytics, Rest API, and both database and application modernization. John has over 35 years of experience on IBM i and it's past family of names. John has a storied career... Read More →
Tuesday May 20, 2025 10:45am - 11:45am PDT
Magic Ballroom 2 1150 Magic Way, Anaheim, CA 92802
  Database

10:45am PDT

What's New in Db2 for i
Tuesday May 20, 2025 10:45am - 11:45am PDT
North Ballroom B
In the tradition of previous Technology Refreshes (TR), the database team is delivering enhancements on the same cadence. Attend this session to hear about the many enhancements to SQL on i, SQL Query Engine, IBM i Services and more. This session will cover the new and enhanced Db2 for i capabilities added to IBM i 7.4 and IBM i 7.5 over the most recent IBM i Technology Refreshes.

This session will include something for everyone and anyone who uses the IBM i.

Resources: https://www.ibm.com/support/pages/node/1119129 and http://ibm.biz/Db2foriSQLTutor
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 →
Tuesday May 20, 2025 10:45am - 11:45am PDT
North Ballroom B 1150 Magic Way, Anaheim, CA 92802
  Database

3:15pm PDT

Analyzing Geospatial Data Using Db2 for i
Tuesday May 20, 2025 3:15pm - 4:15pm PDT
North Ballroom B
In everyday life when we asks questions like “Where is the nearest coffee shop” or “How far away is the airport” we are asking questions about geospatial data. Geospatial data is used to represent objects and events that occur on the surface of the earth. Geospatial analytics allows you to not only store geospatial data representing real location in your database, but to also compare and analyze geographic relationships and trends.
Speakers
avatar for John Westcott

John Westcott

Db2 for i Consultant and Team Lead, IBM
John Westcott is the Db2 for i Team Lead in IBM Technology Expert Labs. John is highyly skilled in SQL, RPG, Data Analytics, Rest API, and both database and application modernization. John has over 35 years of experience on IBM i and it's past family of names. John has a storied career... Read More →
Tuesday May 20, 2025 3:15pm - 4:15pm PDT
North Ballroom B 1150 Magic Way, Anaheim, CA 92802
  Database

3:15pm PDT

Commitment Control – Transaction Control
Tuesday May 20, 2025 3:15pm - 4:15pm PDT
Magic Ballroom 2
In applications multiple steps have to be consolidated and executed as a unit (Transaction), That means either all steps or none of the steps must be performed. Example: An order has to be completely delivered or not at all.
No problem if everything is okay, but what if there is suddenly not enough inventory for one position?
Everything has to be reset … and this can become tricky, because multiple programs were executed, multiple rows in different tables were updated and may be even constraints or triggers were activated.
The solution is Commitment Control. Even though Commitment Control is not new, it is only rarely used in (traditional) IBM i applications. … but it is essential for keeping data consistent, especially when using techniques such as referential integrities and triggers.
… and it is even for traditional applications important.
… so, it is time to start!     
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 →
Tuesday May 20, 2025 3:15pm - 4:15pm PDT
Magic Ballroom 2 1150 Magic Way, Anaheim, CA 92802
  Database

4:30pm PDT

The simplicity of audit columns
Tuesday May 20, 2025 4:30pm - 4:50pm PDT
North Ballroom A
Simon will explain the simplicity of using Db2 audit columns for providing audit columns to your DDL tables & DDS files. He will give examples of how to create system maintained columns or add them to existing tables & files. Then show how they can be hidden from common users.
Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Founder & author, RPGPGM.COM
Simon Hutchinson has been writing his highly acclaimed IBM i blog, RPGPGM.COM, for eleven years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL. His work has led him to be recognized by IBM as an IBM Champion for Power and IBM i Community Advocate. He is a subject matter expert for COMMON Americas, awarded... Read More →
Tuesday May 20, 2025 4:30pm - 4:50pm PDT
North Ballroom A 1150 Magic Way, Anaheim, CA 92802
  Database
 
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Filtered by Date - 
Clear filter
Monday, May 19
Tuesday, May 20
Wednesday, May 21
Thursday, May 22
Adventure
Amazon
Castle
Exhibit Hall
Grand Ballroom
Magic Ballroom 1
Magic Ballroom 2
Magic Ballroom 3
Magic Ballroom 4
Monorail
Nile
North Ballroom A
North Ballroom B
Safari
South Ballroom A
South Ballroom B
Star Wars: Galaxy's Edge
TBD
  • Artificial Intelligence (AI)
  • Client Connectivity
  • Conference Events
  • Database
  • Developing Business Skills
  • DevOps
  • Hardware
  • High Availability Resilience
  • Integrated File System (IFS)
  • IT Leadership & Management
  • IT Strategy
  • Networking
  • Personal Development
  • Program Testing
  • Programmer Tools
  • Programming: Frameworks
  • Programming: General
  • Programming: PHP
  • Programming: Python
  • Programming: RPG
  • Security
  • Storage Technologies
  • Systems Management
  • Technologies Integrated with IBM i
  • Virtualization
  • Popular