-
課程介紹:
This course is designed to provide the database application designer or application programmer with the knowledge to recognize when an IBM stored procedure is the correct solution for an application. It also covers how to set up the environment to support stored procedures,how to use the DB2 Development Center, how to CALL a stored procedure, how to create a stored procedure using DDL, and how to troubleshoot a stored procedure.課程對象:?Database application designers and database application programmers supporting DB2 stored procedures would all benefit from attending this course.
-
課程大綱:
????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