Unsung Heroes of the DB2 for z/OS Application Development

15:00  -  15:45
Kraków Galileo

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 and that have the potential to help reducing the costs by improving the performance or making the application simpler, are not yet fully exploited.

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, and some other small tips.

Objectives:

  • Review some of the new features brought through the DB2 releases.
  • Advanced SQL statements like MERGE, SELECT FROM table change reference.
  • Multi-row operations, cursors.
  • Lock avoidance techniques.
  • Several smaller tips using built in functions.

Languages :  Polski Session Category :  Kraków 2016 

By continuing to use the site, you agree to the use of cookies. więcej informacji

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Zamknij