Articles & Content


Stored Procedures - SQL/PL made Easy for the DBA (E08)

Topic: DB2 for LUW

Subtopic: 2007

DATE: 2007-11-6 (16:45 - 17:45)
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 talk about authority to write and execute a Stored Procedure.

EXP. LEVEL: Beginner,Intermediate


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

Authority to write and execute a Stored Procedure

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.