DB2存储过程编程培训

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

课程长度:2天

最新时间:定制课程(内训),人满开班(公开课)

传统的面对面授课方式。

 

课程大纲:

    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