Emil Kotrc

Speaker Details

Emil Kotrc is a principal architect at CA Technologies.
Emil has been working in the Prague Technology Center since 2005. He started on resource management products for mainframe and later moved into database management for DB2 for z/OS development.  Before joining CA Technologies, Emil worked in an academic environment. and he holds a Ph.D. degree in the applied mathematics. He is one of the leaders of the IDUG Content Committee. Emil is also honored to have been added to the global list of IBM Champions for Analytics
Past presentation
12 June 2018
15:45 - 16:30
European SQLAdria Seminar – Šibenik 2018 DSNUTILU for fun and profit
Db2 for z/OS comes with a set of Stored Procedures that can help application developers to perform various administrative tasks. The main benefits of these procedures are their ease of use via the SQL CALL statement and the simplification of processes. One example of the supplied stored procedures is DSNUTILU, which allows Db2 utility operations from the application programs.
In this presentation we will show how to use DSNUTILU, we will discuss possible real life scenarios, and the benefits and drawbacks of its usage in local and remote application programs.
1. An overview of Db2 supplied stored procedures.
2. Description of DSNUTILU and examples of possible use cases.
3. Discussion of DSNUTILU benefits and drawbacks.

11 June 2018
15:00 - 16:00
European SQLAdria Seminar – Šibenik 2018 A Handful of Application Development Goodies in Db2 12

13 June 2016
16:30 - 17:15
European SQLAdria Seminar – Šibenik 2016 Unsung Heroes of the DB2 for z/OS Application Development
DB2 is constantly evolving over the years, bringing new features with every new release. It might be hard for the developers and administrators to catch up with all the new useful technologies and possibilities. Often, even the features that are not brand new are not yet fully exploited despite they have a potential to help reducing the costs by improving the performance or making the application simpler. 
This presentation will list and remind some features that might help application developers to use more power of the DB2 engine. The discussed topics will cover advanced SQL like the MERGE statement, SELECT from data change references, multi-row operations, lock avoidance techniques, built-in functions like GENERATE_UNIQUE(), timestamp functions, DB2 supplied stored procedures, and some other smaller tips. 
1. Review some of the new features brought through the DB2 releases. 
2. Advanced SQL statements like MERGE, SELECT FROM table change reference. 
3. Multi-row operations, cursors. 
4. Lock avoidance techniques. 
5. Built-in functions and supplied Stored procedures. 
6. Several smaller tips. 



SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2018

Ljubljana - 9th & 10th April 2018
Belgrade - 12th April 2018
Šibenik - 10th - 14th June 2018
Zagreb - 18th September 2018
Opatija - 29th & 30th November 2018