IBM DB2 12 for z/OS Technical Overview

SQL

In this chapter, SQL-related functionality introduced in DB2 12 for z/OS is described. Many examples are provided to help demonstrate how the new features work. The examples can help you in adapting and using the new features in your applications.

This chapter covers the following topics:

•Introduction

•Additional support for triggers

•Pagination support

•Additional support for arrays

•MERGE statement enhancements

•New built-in functions

•Enhanced built-in function support

Many SQL changes are available only when new function is activated ...