This covers the SQL-PL language best practices, error handling, etc.
This covers the many different ways to write queries obtaining the same result. Performance on each is described. Great advanced SQL examples throughout
This covers many SQL tuning standards/guidelines and best practices This covers Do’s and Don’t’s of coding, stage 1 and stage 2 predicates, indexable and non-indexable predicates, statistics, design, new SQL features
This session focuses on Db2 12 for z/OS, the most recent release of IBM’s flagship relational DBMS product for the mainframe. This presentation gives a technical overview of Db2 12, and offers an update on the strategic roadmap, client experiences, and recent continuous delivery content. Among many recent innovations are: improvements to enhance application performance … Czytaj dalej