DB2存储过程编程培训
Objectives
After completing this course, you should be able to:
• Describe DB2 Stored Procedures
• List platform requirements for supporting DB2 Stored Procedures
• Discuss and demonstrate capabilities of the DB2 Development Center
• Describe and use DB2 SQL Procedure Language (SQL PL) statements
• Create and execute, using the DB2 Development Center, SQL PL stored procedures
• Create and execute, using the DB2 Development Center, Java stored procedures
• Describe and use the CALL SQL statement to invoke a DB2 stored procedure
• Describe and use the CREATE PROCEDURE SQL DDL statement
• Describe and execute DB2 Development Center's debugging capabilities
Curriculum Relationship
• CF03 - DB2 Family Fundamentals
• CF10 - DB2 Universal Database Programming Fundamentals
• CF11 - DB2 Universal Database Advanced Programming
• CF12 - DB2 SQL Workshop
• CF13 - DB2 Advanced SQL Workshop
• CF14 - DB2 Call Level Interface Programming
• CF16 - DB2 for OS/390 Application Program Design
• CF82 - DB2 for OS/390 Application Programming Workshop
Agenda
Day 1
Unit 1 - DB2 Stored Procedures and Platform Considerations
Lab - DB2 Stored Procedures and Platform Considerations
Unit 2 - DB2 Development Center
Lab - DB2 Development Center
Unit 3 - DB2 SQL Procedure Language (SQL PL)
Lab - DB2 Development Center and SQL PL
Unit 4 - DB2 Development Center and Java
Day 2
Unit 5 - The CALL SQL Statement
Lab - The CALL SQL Statement
Unit 6 - The CREATE PROCEDURE SQL Statement
Lab - The CREATE PROCEDURE SQL Statement
Unit 7 - DB2 Development Center and Debugging
Lab - DB2 Development Center and Debugging