SQL Enhancements Delivered with Db2 12 for z/OS

Download PDF

Session title: SQL Enhancements Delivered with Db2 12 for z/OS

Session abstract: Every version of Db2 for z/OS introduces new SQL-related capabilities, and Db2 12 is no exception. In this session I will describe new SQL features delivered with Db2 12, including temporal enhancements, the native REST interface, the new-and-improved MERGE statement, piece-wise DELETE, result set pagination, advanced triggers, “real” Unicode columns in EBCDIC tables, global variable enhancements, new built-in functions, and more.

Speaker biography: Robert Catterall is a Senior Consulting Db2 for z/OS Specialist. He started his IT career with IBM in 1982, and worked throughout the 1990s as a member of the Company’s DB2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist for CheckFree (now part of Fiserv). After working for three years as an independent DB2 consultant, he rejoined IBM in 2010. Robert is a past President of IDUG, a member of IDUG’s Speakers Hall of Fame, and was one of IBM’s inaugural Information Champions. He presents frequently at conferences, and blogs about DB2 for z/OS at http://robertsdb2blog.blogspot.com/.