Objectives:
  After completing this course the student should be able to:
  • Develop stored procedures and user defined functions (UDF).
  • Debug stored procedures using the “DEVELOPMENT CENTER”
  • Use the DB2 command tools
  • Review BIND options for applications and stored procedures
  • Access result sets from stored procedures
  • Grant privileges for application objects
Target Audience:
  DB2 programmers and data designers who are responsible for DB2 applications.
Prerequisite:
 
  • Relevant Operating Systems experience (AIX/UNIX/LINUX or Windows) along with knowledge of relational database theory and SQL.
  • Previous experience of using DB2 or a similar relational database is required.
Duration:
  Two days.

Outline for DB2 UDB SQL Stored Procedures for UNIX and Windows

Day 1

  • Introduction to Stored Procedures
  • SQL Procedure Language
  • Creating SQL Procedures
  • Calling Procedures and accessing results

Day 2

  • Using the Development center
  • Debugging using the Development center
  • Creating User defined functions