DB2 Stored Procedures
Course Code: G-564
Recommended Duration: 2 Days
The student will learn how to develop stored procedures in DB2, as well
as how to invoke stored procedures from a host-based application.
Application developers who need to create or invoke DB2 stored procedures
written in COBOL, Assembler, PL/I, C/C++, or REXX.
The student should have experience with basic SQL, as well as experience
in doing DB2 application development..
Related IBM Materials
Classroom access to a set of DB2 Reference manuals is desirable but not required.
Major Topics Include
- DB2 stored procedure architecture
- Stored Procedure Address Spaces
- Defining stored procedures
- CREATE PROCEDURE, ALTER PROCEDURE, DROP PROCEDURE
- Stored procedure catalog tables
- Writing stored procedures
- Parameter styles: GENERAL, GENERAL WITH NULLS, and DB2SQL
- Invoking stored procedures
- Preparing stored procedures and their invokers for execution
- DB2 Commands for stored procedures
- Returning result sets
- Accessing result sets
- Dynamic SQL in stored procedures
- ODBC and stored procedures
- SQL procedures language
- Stored procedure builder overview
- REXX and stored procedures
There are five machine exercises and one optional exercise.
- Lecture notes include examples in COBOL, PL/I,
C, Assembler, and REXX. Currently the labs are set up only for
COBOL and C (with one optional exercise in REXX). If desired,
we can add labs in PL/I or Assembler, but we need to know your