IDUG EMEA 2026: Full Schedule

arrow_back View All Dates

10:20am BST

Tuesday September 29, 2026 10:20am - 11:20am BST

Integrating Db2 for z/OS with non-mainframe processes is easy if you learn how to use Db2 with scripting languages, particularly exploiting Db2 client capabilities and ZOWE. This presentation explains how to do this, and shows some classic use cases in database administration and DevOps.

Speakers

Philip Nelson

Senior Database Software Engineer, Lloyds Banking Group / ScotDB Limited

Philip Nelson has worked with Db2 since 1989. He likes to explore new functionality and is always exploring new techniques for enhancing Db2 usage. He is a frequent presenter at IDUG and has also supported IDUG in many other ways, including the IDUG EMEA CPC and the Content Commi... Read More →

Tuesday September 29, 2026 10:20am - 11:20am BST
Miragaia

Track F, Technical Session

Topic AppDev, Automation, Modernization in Development, Modernization in Operations
Audience All
Platform z/OS

2:00pm BST

D8 SQL in Action: One Statement to Rule Them All - MERGE and integrated SQL operations

Tuesday September 29, 2026 2:00pm - 3:00pm BST

Maria

If multiple statements can be combined into a single one it will be more efficient.
In this session we will explore multiple options to combine different SQL statements. Have you ever used the FINAL TABLE clause or selected the data you just deleted? Besides this the main focus is on the MERGE stamement which is probably the most powerful SQL operation which offers a lot of processing options and can even be used in ETL architectures and with temporal tables. Practical use case will be shown and explained.

Speakers

Michael Tiefenbacher

Distinguished Engineer, Broadcom

Michael Tiefenbacher holds a Master of Science degree from the Munich Institute of Technology. He began his career as a Db2 trainer and was instrumental in introducing IBM’s Business Intelligence course curriculum in Germany.
With more than 25 years of experience in projects an... Read More →

Tuesday September 29, 2026 2:00pm - 3:00pm BST
Maria

Track D, Technical Session

Topic AppDev, Data Movement and Integration, Working with SQL
Audience Intermediate
Platform LUW

4:30pm BST

D9 More SQL tricks with Db2

Tuesday September 29, 2026 4:30pm - 5:30pm BST

Maria

SQL is a very powerful language. But to make best use of it one has to come to a "set-oriented" thinking to solve problems instead of the procedural thinking most application programmers are used to. This presentation discusses some important problems for which a set-oriented solution is initially not obvious, and shows how solutions of these problems can be developed with SQL in Db2. This presentation is a continuation with new problems and solutions of the presentation "SQL tricks with Db2" shown at IDUG EMEA 2024.

Speakers

Andreas Weininger

Principal Information Architecture Technical Specialist, IBM

Andreas Weininger is part of the Information Architecture team of IBM in Munich. He has more than 20 year of experience with scalable solutions for data intensive solutions focussing especially on the performance aspects. He is a regular speaker at database and data warehousing events... Read More →

Tuesday September 29, 2026 4:30pm - 5:30pm BST
Maria

Track D, Technical Session

Topic AppDev, Best Practices, Working with SQL
Audience All
Platform LUW

IDUG EMEA 2026

10:20am BST

Philip Nelson

2:00pm BST

Michael Tiefenbacher

4:30pm BST

Andreas Weininger

Get help with the event