Why take this course?
After completing this course, you will be able to
- Understand the syntax of the SQL procedure language
- Design and code native SQL stored procedures
- Understand the options of the CREATE PROCEDURE, ALTER PROCEDURE, and DROP PROCEDURE
- Use conditions, handlers, and compound statements in native SQL stored procedures
- Use versioning in the creation and maintenance of native SQL stored procedures
- Understand and use the commands associated with maintaining native SQL stored procedures.
1 Day : Fee - $ 697.00 (CAD) : 
Multi-seat - $ 497.00 (CAD)
Multi-seat - $ 497.00 (CAD)Benefits
The student learns how to design and implement native SQL stored proceduresAudience
Application programmers who will be involved in creating, testing, and implementing native SQL stored procedures in DB2 for z/OSPrerequisites
The student should be knowledgeable of SQL, and have some experience invoking and coding stored proceduresMajor topics covered
- 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