Training

Popular Courses

IBM

MICROSOFT

Enterprise Architecture (EA)

SOA

Java/Java EE

Cloud Computing

Agile

Mobile computing

SCHEDULED CLASSES

COURSE
MAP

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

VIRTUAL CLASSROOMS

ROOM RENTALS

Contact Training Sales

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

439 University Av
Suite 820
Toronto, ON
M5G 1Y8

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

 

Home > Training > DB2 >

DB202 DB2 SQL / PL Stored Procedures on z/OS Training Training and Courseware

This course presents the use of Stored Procedures as a solution to specific application needs in a Client / Server environment. DB2 SQL is used as the tool to build and test these Stored Procedures. This course covers the use of CREATE PROCEDURE DDL statement for coding Stored Procedures using DB2 SQL Procedure Language (SQL/PL). Several hands-on exercises demonstrate the use of INPUT and / or OUTPUT parameters and internal Stored Procedures logic. Several DB2 Stored Procedure examples are reviewed as an insight into examples of the capabilities of Stored Procedures. The use of the CALL statement is presented as the means to invoke a Stored Procedure. Various methods for debugging a Stored Procedure are also presented.
Learning Objectives
 


Upon successful completion of this course, the student will be able to:

  • Describe what a stored procedure is and how it works
  • Describe various DB2 SQL/PL statements and how to use them in an application
  • Describe the basic structure of a SQL application using Stored Procedures
  • Create DB2 Stored Procedures using the SQL DDL statement - CREATE PROCEDURE
  • Debug Stored Procedures
Audience
  Database application designers and application programmers who need to build, test, and modify DB2 Stored Procedures on DB2 UDB for z/OS.
 
Prerequisites
  The student must have at least 6 months experience with both SQL and the z/OS environment.
 
Duration
  Two days.

Course Outline

There is no detailed outline available at this time.
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
More Details
Outline Course Outline
Buy This Course

Buy on-site and customized class

*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.