Interskill Learning Mainframe Training

American English British English Brazilian Portuguese French German Italian Russian Spanish (European) Spanish (Latin American)
+44 (0) 1625 441120

The Online Mainframe Training Specialists
Search   Course Catalog   Live Chat!  
Return to Catalog Home     Return to Curriculum Listing

DB2 Stored Procedures

Duration

3 hours

Overview

The DB2 Stored Procedures course describes how stored procedures are used and the platforms on which they can be implemented. The benefits derived from using stored procedures are discussed as well as security implications associated with them.

Audience

Programmers and DBAs requiring training in developing and managing DB2 stored procedures

Prerequisites

Completion of the courses 'Manage Data Definitions with DB2', 'Advanced DB2 SQL' and DB2 SQL Fundamentals', and basic knowledge of DB2, relational databases, and system design.

Objectives

After completing this course, the student will be able to identify how the following programs are written with DB2:

  • Identify the benefits of Using DB2 stored procedures
  • Describe how DB2 stored procedures are used in a z/OS environment
  • Create and invoke DB2 stored procedures

Course Content

Introducing Stored Procedures

DB2 Stored Procedure Fundamentals
DB2 Stored Procedure Features
Creating and Running DB2 Stored Procedures

Introducing DB2 Stored Procedures on z/OS

Introducing DB2 Stored Procedures on z/OS
Creating DB2 Stored Procedures
Autonomous Procedures
Maintaining and Controlling DB2 Stored Procedures

DB2 Stored Procedures Mastery Test

Looking for more information about Interskill Learning Products?
Contact our Learning Consultants or call us at +44 (0) 1625 441120