|
NWDB1028 DB2 SQL PL Stored Procedures Using Data Studio
DESCRIPTION
This 2 day course provides DB2 developers with the technical knowledge necessary to develop efficient SQL Stored Procedures with the IBM Data Studio. These tools may be used with DB2 on any platform. The course also covers the DB2 Unified Debugger.
AUDIENCE
Analysts and programmers involved in the development of DB2 for z/OS SQL Stored Procedures.
OBJECTIVES
Upon successful completion of this course, the student will be able to
-
Understand the benefits of Stored Procedures
-
Code DB2 Stored Procedures using SQL Procedure Language (including the new “native” stored procedures on DB2 9 for z/OS)
-
Use the IBM Data Studio to develop SQL Procedures
-
Use the Unified Debugger to test and troubleshoot stored procedures
TOPICS
- Introduction to Stored Procedures
- IBM Data Studio
- The SQL Procedure Language
- Working with SQL Procedures
- Global Temporary Tables
- Unified Debugger
PREREQUISITES
Understanding of relational database concepts and SQL syntax (DB2 SQL For Everyone or equivalent).
|
