Articles & Content

Archives

Stored Procedures - SPL/PL Made Easy for Everyone (F09)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2007



DATE: 2007-5-9 (09:50 AM - 10:50 AM)
SPEAKERS: James Surber (Zurich)

Stored Procedures are being used by Application groups and DBA’s more for many reasons. We will cover some of the differences of z-OS and LUW. I will talk writing a single return Stored Procedures in three easy steps. We will then add a multi-return (LUW). After we understand the simple Stored Procedure add some features to make the then more powerful and have some logic. In the final part we will look at and talk about some cool examples you can take back and use.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

When, Where, and How to use Stored Procedures

Differences between z/OS and LUW

Three easy steps to write a Stored Procedure

Continued features of Stored Procedures

Cool examples you can take home and use (RI and View Chains - Up and Down)



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.