Articles & Content

Archives

DB2 Stored Procedures - Trends and Technology (E14)

Topic: DB2 for z/OS

Subtopic: 2010



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

OBJECTIVES:

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.



Click Here to Download

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