- 3 hours
The DB2 Stored Procedures course describes how stored procedures are used and the platforms on which they can be implemented. The benefits derived from using stored procedures are discussed as well as security implications associated with them.
Programmers and DBAs responsible for developing and managing DB2 stored procedures.
Completion of the courses 'Manage Data Definitions with DB2', 'DB2 SQL Fundamentals', and 'Advanced DB2 SQL' and basic knowledge of DB2, relational databases, and system design.
After completing this course, the student will be able to:
- Identify the benefits of Using DB2 stored procedures
- Describe how DB2 stored procedures are used in a z/OS environment
- Create and invoke DB2 stored procedures
DB2 Stored Procedure Fundamentals
DB2 Stored Procedure Features
Creating and Running DB2 Stored Procedures
Introducing DB2 Stored Procedures on z/OS
Creating DB2 Stored Procedures
Maintaining and Controlling DB2 Stored Procedures