-
课程介绍:
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