Name: Modern SQL Mastery: Advanced Techniques for DB2 for i Performance and Productivity
Start: 2025-06-04T15:20:00+0200
End: 2025-06-04T16:20:00+0200

WELCOME TO COMMON EUROPE CONGRESS 2025

Don’t forget to reach out to your local country user group to get the discount code for the congress!

Common Europe, in collaboration with Common Sweden, is delighted to be holding its annual flagship event, Common Europe Congress, in the friendly city of Gothenburg offering extensive education, networking and relaxation opportunities. It’s also a great opportunity for exploring the city… so why not take a family mini-break as well.
Congress education areas targeted are IBM Power hardware, Application Development, Advanced RPG, Open Source tools and Languages, System Management, Db2 and SQL, IBM Storage, IBM i services and microservices, Security and Compliance and much more.
There will be two AIX / Linux tracks, to emphasize the Power Systems character of Common Europe.
Top IBM Business Architects and industry experts have already agreed to share their knowledge on the latest announcements, customer cases as well as practical subjects.
The congress content includes:

3 ½ days of latest education delivered by top IBM and industry leading speakers punctuated by large breaks offering maximum networking,
Three-hour in-depth workshops, 60 minutes’ education sessions and solution provider’s special slots,
A Solution Providers’ Centre open for 2 ½ days with top European and worldwide technology companies at their booths presenting innovative practical solutions that will enhance our solutions,
A Congress Dinner in the hotel with live entertainment.

We have negotiated special room rates in the Congress hotel itself,
The Common Europe Organization Team looks forward to seeing you in picturesque Gothenburg.

You will be able to validate your attendance (Check-In to sessions) using your personal schedule.

Wednesday June 4, 2025 15:20 - 16:20 CEST

05 - F3

Take your SQL skills to the next level with advanced techniques that maximize DB2 for i's capabilities. This deep-dive session covers powerful features including common table expressions, window functions, JSON handling, and advanced indexing strategies. Through real-world examples, learn how to transform complex business requirements into efficient SQL solutions. We'll explore performance optimization techniques, demonstrate modern SQL patterns for replacing traditional record-level access, and show how to leverage the latest DB2 for i enhancements. Whether you're modernizing legacy applications or building new solutions, you'll gain practical skills to write faster, more maintainable SQL code. Includes live demonstrations of performance tuning and query optimization.

Speakers

Koen Decorte

Owner and CEO, IBM Champion, CD-Invest

Koen Decorte is what happens when you let a philologist accidentally wander into a server room and decide to stay. He abandoned the tranquility of ancient texts for the chaotic thrill of RPGLE debugging! As the founder of CD-Invest (which stands for "Computers Doing Impressive Stuff... Read More →

Wednesday June 4, 2025 15:20 - 16:20 CEST
05 - F3

IBM i App Dev