Course Description

Course name

DB2UDB SQL Stored Procedures

Course code

ADVDB2SQL

Audience

Programmers who need to create SQL Stored Procedures.

Prerequisites

Familiar with running queries using DB2UDB.

Objectives

Upon successful completion, the participant will be able to:
  • Create SQL Stored Procedures using some of the following:

CREATE PROCEDURE Statement

CREATE PROCEDURE Statement Parameters & Clauses

SQL Procedure Body Statement

Comments

Compound Statement – BEGIN / END

Defining Variables – DECLARE Statement

Special Registers

CASE & IF constructs

Looping – WHILE & REPEAT Statements

Looping – REPEAT Statement

COMMIT and ROLLBACK

Error Handling

Condition Handlers

DECLARE handler-type HANDLER FOR condition SQL-procedure-statement;

SIGNAL

RESIGNAL

Duration

1 Day