- 3 hours
The DB2 Stored Procedures course provides the learner with an overview of DB2 and SQL, and expands this knowledge to describe operational tasks associated with the DB2 subsystem. The course also looks at building application programs and DB2 stored procedures used to access DB2 data, and the DB2 tools to optimize SQL and programs.
Programmers and DBAs requiring training in developing and managing DB2 stored procedures.
Basic knowledge of DB2, relational databases, and SQL.
After completing this course, the student will be able to:
- Identify DB2 stored procedures: what they are, different types, why they are used
- Recognize how to create and maintain 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 Stored Procedures
Maintaining and Controlling Stored Procedures