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