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
?

?
?