Objectives:
A new variation of SQL procedures, native SQL procedures, are introduced in DB2 9 for z/OS. Richer support of the SQL Procedural Language, and attention to the application development lifecycle, offer improved usability and portability. These extensions (including versioning and deployment capabilities) based on new technology can be a favorable alternative to the existing compilation of SQL Procedural Language procedures into an external C language implementation. Since native SQL procedures are managed by DB2 and run within the DB2 engine, there are also significant benefits in terms of improved performance, security, and reduced cost of ownership.
Outline:
Introduction
Background and Motivation
Comparing external vs native SQL procedures
New Features
SQL Enhancements
Versioning and Deployment
Debugging
Performance Technologies