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
?
?
?