DB2 9 for z/Os Native stored procedures

Date: 
Friday, 11 april, 2008 - 10:20 - 11:15
Speaker: 
Florence Dubois

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

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023