Articles & Content


DB2 Stored Procedures - Trends and Technology (E14)

Topic: 2010 EMEA

Subtopic: DB2 for z/OS

DATE: 2010-11-10 (17:00 - 18:00)
SPEAKERS: Robert Catterall (Catterall Consulting)

Stored procedures have been widely used for years in DB2 for Linux, UNIX, and Windows application environments. On the mainframe side, adoption of the technology has been somewhat more limited. That situation is likely to change with the advent of native SQL procedures, delivered in DB2 for z/OS V9. This presentation will lay out a vision of a modern DB2 data-serving system in which stored procedures play a very important role. It will also provide a review of DB2 for z/OS stored procedure enhancements, with a particular emphasis on the advantages of DB2 V9 native SQL procedures. The presentation will conclude with some hints, tips, and go-forward recommendations.

EXP. LEVEL: Beginner,Intermediate,Advanced


A vision of a modern DB2 for z/OS data-serving system, with stored procedures as a foundational element.

Advances in DB2 for z/OS stored procedure functionality since DB2 V4.

DB2 9 for z/OS native SQL procedures - what

Go-forward recommendations regarding the implementation of DB2 9 for z/OS native SQL procedures.

Some DB2 for z/OS stored procedure hints and tips.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.