Loading Course Schedule...
PT0947
Training Summary
The student learns how to design and implement native SQL stored procedures.
Prerequisites
Before taking this course, students should be knowledgeable of SQL, and have some experience invoking and coding stored procedures.
Duration
1 Day/Lecture & Lab
Audience
This course is designed for application programmers who will be involved in creating, testing, and implementing native SQL stored procedures in Db2 for z/OS.
Course Topics
CREATE PROCEDURE
- Stored procedure options
- Stored procedure parameters
- SQL Procedure Language syntax
- Compound statements
- Conditions and Handlers
- ALTER PROCEDURE
- Versioning
- Commands for native SQL stored procedures
- Deploying native SQL stored procedures
- DB2 Catalog tables for stored procedures