Topic: 2011 NA
Subtopic: DB2 for LUW
DATE: 2011-5-6 (09:15 AM - 10:15 AM)
SPEAKERS: James Surber (CSC)
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. Included in the presenation material will be take home examples that can be used by a DBA to make woek easier and faster.
EXP. LEVEL: Beginner,Intermediate,Advanced
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.