2025-11-17, 14:00–17:00, Cipres
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.
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" or "Coffee-Driven Innovation" depending on the time of day), Koen has spent years convincing stubborn IBM i systems to embrace modern technology without having existential crises.
Koen strategically positioned offices in both Belgium and Spain – officially for "international business reach," unofficially for escaping Belgian rain.
This IBM Champion since 2018 possesses the rare talent of making executives nod confidently while explaining concepts they absolutely don't understand. As a CEAC member and Common Belgium Treasurer, Koen spends his free time convincing common members that "modernization" doesn't mean "replacing your AS/400 with a houseplant."
"Carpe Datum!" — Seize the data! he proclaims dramatically while rescuing databases that predate most of his developers. As Ovid might observe: "Omnia mutantur, nihil interit" (Everything changes, nothing perishes) – especially your cherished RPG applications under Koen's enlightened guidance.
With unparalleled multilingual proficiency, Koen is uniquely qualified to swear in multiple languages when open-source installations rebel against IBM i integration. Join his sessions where the code is fresh, the demos are live (and therefore guaranteed to fail spectacularly), and the solutions are so innovative that even Koen occasionally whispers "how did that actually work?" when nobody's listening.