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

Venue: Studio 1-2 clear filter
Monday, April 27
 

10:00am CDT

Intro to SQL
Monday April 27, 2026 10:00am - 11:00am CDT
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
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 →
Monday April 27, 2026 10:00am - 11:00am CDT
Studio 1-2

11:15am CDT

Run Away Queries Got You Down?
Monday April 27, 2026 11:15am - 12:15pm CDT
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
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 →
Monday April 27, 2026 11:15am - 12:15pm CDT
Studio 1-2

3:15pm CDT

Avoid Distractions, Get Focused
Monday April 27, 2026 3:15pm - 4:15pm CDT
We live in a world of endless distractions. Get distracted and you lose focus. According to research, it takes around 23 minutes to refocus after a distraction. Should we manage the distractions? Or let ourselves get distracted? Or learn to focus despite the distractions? If you can’t focus your attention, how can you accomplish anything? This session will teach you how to identify when and why you’re being distracted, what to do about it, and how to increase your focus.

Learning Objectives:

1) How to identify when you’re distracted 2) Understanding why you get distracted 3) How to avoid distractions 4) How to increase your focus
Speakers
avatar for Kim Greene

Kim Greene

President, Kim Greene Consulting, Inc.
Kim Greene is president of Kim Greene Consulting, Inc. specializing in providing consulting services for the HCL Collaboration Solutions portfolio for IBM i, Windows, and Linux. Kim has over 20 years of experience with IBM Domino and over 25 years of experience with the AS/400, iSeries... Read More →
Monday April 27, 2026 3:15pm - 4:15pm CDT
Studio 1-2

4:30pm CDT

CL 2025: What’s New and Useful
Monday April 27, 2026 4:30pm - 4:50pm CDT
Control Language (CL) remains a core tool for IBM i system operations, and recent releases have added features that make scripting faster, cleaner, and more powerful. In this 20-minute session, Simon Hutchinson will provide a hands-on look at the most useful new CL commands, built-in functions, and SQL integration techniques. Attendees will learn how to modernize legacy scripts, automate system tasks, and streamline everyday operations using the latest CL features.

Learning Objectives:

By the end of this session, attendees will be able to: - Identify and use the most important new CL commands and functions. - Integrate SQL statements into CL scripts for database operations. - Modernize legacy CL code with practical tips for efficiency and readability. - Apply CL features to automate routine system tasks.
Speakers
avatar for Simon Hutchinson

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 4:30pm - 4:50pm CDT
Studio 1-2

5:05pm CDT

Using SQL Triggers to Track File Changes on IBM i
Monday April 27, 2026 5:05pm - 5:25pm CDT
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
avatar for Simon Hutchinson

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
 
Tuesday, April 28
 

8:00am CDT

Code for IBM i – What’s New, What’s Next
Tuesday April 28, 2026 8:00am - 9:00am CDT
The Code for IBM i family of extensions continues to grow with new tools and powerful enhancements. In this session, we will showcase recent improvements, highlight community contributions, and share a glimpse of upcoming features on the roadmap for 2026.

Learning Objectives:

• Share newly released features across all IBM i VS Code extensions • Showcase new tips and tricks to improve the developer experience • Share an overview of upcoming features in the 2026 roadmap
Speakers
avatar for Alan Seiden

Alan Seiden

Principal Consultant, Seiden Group
How to modernize and create something new while leveraging your valuable business logic. Supporting developers, mentoring, staff augmentation, architecture, development and programming. Seiden PHP+ Server for IBM i, 
APIs, IBM i, open source, web, PHP, Node.js, Python, RPG, ERPs... Read More →
avatar for Sanjula Ganepola

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 →
Tuesday April 28, 2026 8:00am - 9:00am CDT
Studio 1-2

9:15am CDT

The Technology Has Arrived. Is Your Organization Ready?
Tuesday April 28, 2026 9:15am - 10:15am CDT
The numbers are in — and they tell a story most AI vendors don't want you to hear.
 
79% of enterprises are experimenting with AI. Only 8.6% have made it to production. 94% have adopted AI tools, but fewer than half have the governance frameworks to support them. 72% have scaled pilots — but only 33% have governed what they scaled. And after everything, only 6% can point to measurable EBIT impact.
 
And the pace isn't slowing. The CEO of the lab most associated with measured, conservative AI claims is now describing the rate of change as a civilizational tsunami — one most organizations haven't recognized yet. The window to close the readiness gap is not a planning horizon. It's a competitive one. AI-native companies aren't waiting for organizational alignment — they're likely already in your market, and they're building on day one what it took your organization a decade to construct.
 
The IBM i community has always known how to build systems that last. The platform didn't fail. But technology that arrives without organizational readiness doesn't transform — it accumulates. And when Naval Ravikant publicly declares software "uninvestable," he's not making a valuation call. He's pointing at the only layer that still holds durable value: governance, trust, and the organizational infrastructure to deploy at scale.
 
This session is a practitioner's account of what actually happens when you run a technology transformation and an organizational transformation in tandem — not sequentially, not siloed, not hoping the tech carries the org when it's finally ready.
 
This session will explore what transformation actually looks like at both layers — the technology and the organization — and why the sequence and structure of that work matters more than the tools you choose.
 
The organizations that close the gap first won't be the ones with the best technology. They'll be the ones who understood what the technology was actually asking of them.

Speakers
avatar for Reggie Britt

Reggie Britt

CTO, American First Finance
30+ years on various Midrange platforms from IBM S/36 through the current IBM i platform.  My primary focus has been developing Fintech software solutions in Banking, Consumer Finance and BNPL.  I have been involved in all aspects of IT including Full Stack Development, DevOps... Read More →
Tuesday April 28, 2026 9:15am - 10:15am CDT
Studio 1-2

10:45am CDT

Let's Build an RPG Service Program
Tuesday April 28, 2026 10:45am - 11:45am CDT
Service programs have been around for quite some time. Perhaps you’ve even bumped into one in your professional travels. You will certainly find them on the road to application modernization. This session focuses on what they are, how to implement them and making them a regularly used asset during your application development. In this session we will discuss service programs, program signatures and using binder language.

Learning Objectives:

We will go step by step to the creation of an RPG service program.
Speakers
avatar for Charles Guarino

Charles Guarino

CEO & IBM Champion, Central Park Data Systems
Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.

He is a member of COMMON’s Speaker Excellence Hall of Fame and a proud recipient of the Al Barsa Memorial Scholarship Award. Additionally, he participates on COMMON’s Strategic Education Team. Other professional endeavors have included the roles of President and monthly Q&A host... Read More →
Tuesday April 28, 2026 10:45am - 11:45am CDT
Studio 1-2

3:15pm CDT

Breaking Up a Monolith
Tuesday April 28, 2026 3:15pm - 4:15pm CDT
Every RPG shop has them. Most developers avoid them like the plague. Large monolithic programs are a significant source of technical debt in all RPG shops. They limit your agility which in turn is detrimental to your business. So, once you are ready to deal with the issue, where do you start? There is no one answer, but there are steps you can take to begin dismantling and repurposing the code within these behemoths.

Learning Objectives:

1. Discuss steps to refactoring monolithic RPG programs 2. Learn common pitfalls to avoid 3. Learn how to organize extracted procedures for ease of use
Speakers
avatar for Brian May

Brian May

Principal Technology Evangelist, Profound Logic
Professional IT Leader, Speaker and WriterSpecialties:Team Building, Development and RetentionTechnical SalesSolutions ArchitectureSoftware DevelopmentEnterprise Systems Manufacturing ProcessesApparel IndustryAccounting Principles
Tuesday April 28, 2026 3:15pm - 4:15pm CDT
Studio 1-2

4:30pm CDT

The Secrets to Making the Most of Online Meetings
Tuesday April 28, 2026 4:30pm - 4:50pm CDT
Now that virtual meetings have become the new normal for so many of us, it's vital that we learn to make the most of this approach to getting things done. Whether you use Zoom, Teams, Webex, or another product, come to this session to learn the secrets to supercharging your online meeting productivity and getting results!

Learning Objectives:

In just 20 minutes, you'll learn: - How to plan your meeting for success - How to run your meeting for maximum productivity - The best ways to take meeting notes - When and how to end your meeting - Tips and tricks to maximize your use of technology and supercharge your work from home environment
Speakers
avatar for Steven Wolk

Steven Wolk

CTO, PC Richard & Son
Steven Wolk is the CTO for PC Richard & Son. Founded in 1909, PC Richard is a family owned and operated chain of over 65 appliance, electronics, and mattress superstores located throughout NY, NJ, CT, and PA. Steve's deep background in retail began on the sales floor while in college... Read More →
Tuesday April 28, 2026 4:30pm - 4:50pm CDT
Studio 1-2

5:05pm CDT

The Secrets to Negotiating and Resolving Workplace Conflict
Tuesday April 28, 2026 5:05pm - 5:25pm CDT
Do you dread the thought of negotiating on your own behalf? Are you unsure of the best ways to handle conflict in the workplace? If you answered yes to either of these questions, then you need to attend this session! We'll cover time-tested techniques for negotiations and conflict resolution that could change your life!

Learning Objectives:

In just 20 minutes, you'll: - Learn to consider the value of an argument vs the cost - Find common ground to smooth the negotiation - Understand that all new ideas are great, and that we all make mistakes - Show respect and build a reserve of good will to allow everyone to leave the negotiation with their head held high
Speakers
avatar for Steven Wolk

Steven Wolk

CTO, PC Richard & Son
Steven Wolk is the CTO for PC Richard & Son. Founded in 1909, PC Richard is a family owned and operated chain of over 65 appliance, electronics, and mattress superstores located throughout NY, NJ, CT, and PA. Steve's deep background in retail began on the sales floor while in college... Read More →
Tuesday April 28, 2026 5:05pm - 5:25pm CDT
Studio 1-2
 
Wednesday, April 29
 

8:00am CDT

Navigating the HA/DR Maze: Make the Right Move
Wednesday April 29, 2026 8:00am - 9:00am CDT
In today’s ever-evolving IT landscape, ensuring continuous business operations requires a strategic approach to High Availability (HA) and Disaster Recovery (DR). With a growing array of technologies, both on-premises and in the cloud, choosing the right solution can feel like navigating a maze. This session will guide you through the key considerations for building a resilient HA/DR strategy. We’ll explore the different types of outages and align them with the technologies designed to mitigate their impact. Whether you're planning for hardware failures, software issues, or full system outages, understanding your business requirements and protection goals is critical. Join us for a practical overview of HA/DR technologies including Db2 Mirror, Live Partition Mobility, Logical and Software-Based Replication, Full System Replication, and PowerHA. You’ll leave with a clearer roadmap to help you make informed decisions and confidently chart your HA/DR journey.

Learning Objectives:

1. Learn the importance of considering your recovery point objective and recovery time objective for different types of outages 2. Learn how different technologies can help achieve various RPO and RTO targets. 3. Learn how the technologies can be combined
Speakers
avatar for Brian Nordland

Brian Nordland

Director of Development, Fortra
Brian Nordland is the Director of Development for IBM Power Development at Fortra. Brian has been a prominent speaker at events, webinars, and user groups, including COMMON and LUG for over a decade. He is a co-inventor on multiple patents and has authored technical publications in... Read More →
Wednesday April 29, 2026 8:00am - 9:00am CDT
Studio 1-2

9:15am CDT

AI on Power
Wednesday April 29, 2026 9:15am - 10:15am CDT
The speaker's insights into running AI workloads on Power. Some history of how the Power approach to Machine Learning, Large Language Models, and Transformers evolved up to Power 11 and Spyre.

Learning Objectives:

1. Python libraries for AI on Power 2. CPU/MMA support for AI on Power 3. Spyre on Power
Speakers
avatar for Jack Woehr

Jack Woehr

Senior Engineer / Senior Consultant, Consulting to Procern Technology Solutions and Seiden Group LLC
40+ years development. IBM Champion 2021-2026.
IBM Qiskit Advocate since 2019. Secretary, OpenQASM Technical Steering Committee. MongoDB Creator status. Prolific Open Source creator/contributor. Former Contributing Editor, Dr. Dobb's Journal.
Consult on IBM i AI modernization... Read More →
Wednesday April 29, 2026 9:15am - 10:15am CDT
Studio 1-2

10:45am CDT

Diving into the Deep End of IBM i Security
Wednesday April 29, 2026 10:45am - 11:45am CDT
What is an authorized pointer? How does the authority checking algorithm really work? What are the performance aspects of IBM i security? Using her knowledge obtained as IBM i Security team leader, Carol Woodbury answers these questions and more, as she takes you into the depths of IBM i security.

Learning Objectives:

Understand the deeply technical aspects of IBM i Security.
Speakers
avatar for Carol Woodbury

Carol Woodbury

IBM i Security SME and Senior Advisor, Kisco
Wednesday April 29, 2026 10:45am - 11:45am CDT
Studio 1-2

3:45pm CDT

Processing JSON with DB2 and RPG
Wednesday April 29, 2026 3:45pm - 4:45pm CDT
Tricks” to make your life easier when you start working with JSON data. After a short discussion of the HTTP functions that have been added to QSYS2 and how they can be used with the JSON_TABLE Function, Jim shows the attendee how to work with the QSYS2.HTTP_GET and JSON_TABLE Functions to consume an API returning a JSON object. If you have tried using these functions many have problems writing the correct SQL/JSON path expressions to extract the data and represent it in a relational table. Jim will help the attendee understand this process with solid examples.

Learning Objectives:

Developers looking for clear examples of SQL/JSON path expressions with DB2. Improve developers’ understanding of SQL/JSON path expressions with DB2 and JSON. Improve developers’ understanding of how to use HTTP functions in QSYS2. Improve developers’ understanding of how to use JSON_TABLE functions.
Speakers
avatar for Jim Buck

Jim Buck

CEO & Head Instructor, imPower Technologies

Jim Buck’s career in IT has spanned more than 35+ years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →
Wednesday April 29, 2026 3:45pm - 4:45pm CDT
Studio 1-2

5:00pm CDT

Integrated File System Performance Strategies
Wednesday April 29, 2026 5:00pm - 6:00pm CDT
Is your application or workload running slower than you’d like when accessing the integrated file system (IFS)? Do you want to learn how you can increase your performance without drastically overhauling everything? If so, then attend this session. In this session, we will discuss performance strategies like using user-defined file systems (UDFS) and auxiliary storage pools (ASPs), ways to reduce contention, and how to analyze file system performance. The latest updates to performance tools will also be discussed.

Learning Objectives:

1. Understand how UDFSs, ASPs, and spreading data across different storage units can help increase performance. 2. Understand extensions to some APIs that can help increase performance. 3. Understand and see demonstrations of performance analysis tools.
Speakers
avatar for Justin Nelson

Justin Nelson

Advisory Software Engineer, IBM
Justin Nelson is a software developer within IBM i development. He has worked on the IBM i since joining IBM in 2015. He is a member of the integrated file system & servers (IFS) team and specializes in the Network Client File System (QNTC), host servers, and Network Authentication... Read More →
Wednesday April 29, 2026 5:00pm - 6:00pm CDT
Studio 1-2
 
Thursday, April 30
 

8:00am CDT

Modern RPG what does that mean?
Thursday April 30, 2026 8:00am - 9:00am CDT
You hear modern RPG but, what does that actually mean? we will look at converting from monolithic programs to modular programming including the use of service program and converting RLA(Record level access) to sql.

Learning Objectives:

Understanding what modern RPG means Understanding of what needs to be done to implement modern RPG.
Speakers
avatar for Marina Schwenk

Marina Schwenk

Senior Programmer/Analyst IBM i Admin, Innovative Software Solutions

Thursday April 30, 2026 8:00am - 9:00am CDT
Studio 1-2
  RPG

9:15am CDT

Mission: Possible! Journaling Forensics 101 (with Free Tools)
Thursday April 30, 2026 9:15am - 10:15am CDT
Learn to think like a spy! Many shops use journaling for a variety of reasons, but may not be familiar with how to use these journals for forensic purposes. Mining your journals for the who, what, when, where, how - and sometimes even why - can be very useful, not to mention fun! Come join us for a lighthearted and entertaining "Mission: Impossible" themed look at one of the most useful things you can do with your journals. This session will introduce journaling concepts and share tuning tips to optimize your journal environment for forensics. After reviewing the "old fashioned" way to dig into your journals, we will demonstrate how much easier this is with the right tools. The DMPJRN and CVTJRNDTA commands used in this presentation will be made available as a free download to all attendees, including source code!

Learning Objectives:

Learning Objectives - After participating in this session, attendees should have the skills and tools to: - Optimize your journal environment to maximize the forensic information available to you - Understand what your journals are trying to tell you, and how to interrogate them to get the answers you need - Dump your journals quickly and easily using the free software made available - Be able to interpret the content of your journals to determine what really happened to your data - Use the techniques demonstrated in the provided source code to develop your own tools - Save the world from evil-doers
Speakers
avatar for Steven Wolk

Steven Wolk

CTO, PC Richard & Son
Steven Wolk is the CTO for PC Richard & Son. Founded in 1909, PC Richard is a family owned and operated chain of over 65 appliance, electronics, and mattress superstores located throughout NY, NJ, CT, and PA. Steve's deep background in retail began on the sales floor while in college... Read More →
Thursday April 30, 2026 9:15am - 10:15am CDT
Studio 1-2

10:45am CDT

Using Large Language Models
Thursday April 30, 2026 10:45am - 11:45am CDT
What are the strengths of the modern Large Language Model approach to Artificial Intelligence? What are the weaknesses? Where and how is it safe to apply this enticing yet dangerous technology? Where are the usage models headed right now? Inquiring minds want to know!

Learning Objectives:

1. Understanding the strengths of Large Language Model and Transformer architecture 2. Understanding the weaknesses of Large Language Model and Transformer architecture 3. Reviewing the technical, epistemological, and existential critiques of Large Language Model and Transformer architecture 4. Making actionable suggestions on this technology in the enterprise
Speakers
avatar for Jack Woehr

Jack Woehr

Senior Engineer / Senior Consultant, Consulting to Procern Technology Solutions and Seiden Group LLC
40+ years development. IBM Champion 2021-2026.
IBM Qiskit Advocate since 2019. Secretary, OpenQASM Technical Steering Committee. MongoDB Creator status. Prolific Open Source creator/contributor. Former Contributing Editor, Dr. Dobb's Journal.
Consult on IBM i AI modernization... Read More →
Thursday April 30, 2026 10:45am - 11:45am CDT
Studio 1-2

1:00pm CDT

IBM i Mythbusting
Thursday April 30, 2026 1:00pm - 2:00pm CDT
You can’t do that on IBM i! Or so they may say. We’ll explore some common misconceptions, urban legends, and outright lies about our favorite platform, and of course we’ll also try to take down a running system for fun. The floor’s open for suggestions, stories, and a bit of fun while we try everything that you’re too afraid to try on your own system.

Learning Objectives:

n/a
Speakers
avatar for Nathan Williams

Nathan Williams

Senior Systems Engineer, CloudFirst Global
As a Senior Systems Engineer on the Service Delivery team at CloudFirst, Nathan provides support and advice on new hardware installations, system migrations, OS upgrades, SAN and VIOS implementations, and more. He has been in an IT support role of one form or another since the mid-1990s... Read More →
Thursday April 30, 2026 1:00pm - 2:00pm CDT
Studio 1-2

3:00pm CDT

Fix Management
Thursday April 30, 2026 3:00pm - 4:00pm CDT
Keeping your system up to date and secure requires knowledge of IBM Fixes. Here will will discuss what the Fixess are, how to get them, and how to apply them. We will also discuss the different types of Fixes and how to develop a Fix strategy for your organization.

Learning Objectives:

1. What is a Fix and the different types of Fixes 2. Build a Fix strategy that works for your company 3. How to acquire and apply the Fixes and Fix groups. 4. Using virtual image catalogs to save time on Fix application
Speakers
avatar for Sarah Jacob

Sarah Jacob

VP of Customer Experience, Agile Technology Architects
Sarah Jacob is the Vice President of Customer Experience at Agile Technology Architects. She is a Subject Matter Expert in Power Systems Administration and a volunteer for COMMON. Sarah specializes in Backup and Recovery planning and recovery testing. Additionally, she acts as primary... Read More →
Thursday April 30, 2026 3:00pm - 4:00pm CDT
Studio 1-2

4:15pm CDT

Group By, Having and multi-dimensional Grouping
Thursday April 30, 2026 4:15pm - 5:15pm CDT
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
Thursday April 30, 2026 4:15pm - 5:15pm CDT
Studio 1-2
 

Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
  • Artificial Intelligence (AI)
  • Client Connectivity
  • Conference Events
  • Database
  • Developing Business Skills
  • Frameworks
  • General Programming
  • Hardware
  • High Availability Resilience
  • IBM Event
  • IFS
  • IT Leadership and Management
  • IT Strategy
  • NDA
  • Networking
  • PHP
  • Program Testing
  • Programmer Tools
  • Python
  • RPG
  • Security
  • Systems Management
  • Technologies Integrated with IBM i
  • UI
  • Virtualization