On-site & Public, Instructor-led, Hands-on IT Training
(International 01) 908.233.8900
  400+ Course Offerings:

Search for Course:

DB1029 Exploiting Native SQL Stored Procedures on DB2 for z/OS
Duration3 Days
Delivery MethodInstructor Led, Hands-on workshops
Public Price$1800.00

DESCRIPTION (Return to Top)

One of the most anticipated new features of DB2 for z/OS was the Native SQL PL stored procedure. A key advantage is the ability to work entirely within the IBM Data Studio environment and accomplish DB2 development with no green screen. This course covers the mechanics of coding, testing and debugging and deploying these stored procedures.

AUDIENCE (Return to Top)

Analysts and programmers involved in the development of DB2 for z/OS SQL Stored Procedures.

OBJECTIVES (Return to Top)

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

  • Understand the benefits of Stored Procedures
  • Code DB2 Stored Procedures using SQL Procedure Language (including the new “native” stored procedures on DB2 for z/OS)
  • Use the IBM Data Studio to develop SQL Procedures
  • Use the Unified Debugger to test and troubleshoot stored procedures

TOPICS (Return to Top)
  • Introduction to Stored Procedures
  • The SQL Procedure Language
  • IBM Data Studio
  • Error Handling in SQL PL
  • Global Temporary Tables
  • Native SQL Logistical & Performance Considerations
  • Unified Debugger in IBM Data Studio


Understanding of relational database concepts and SQL syntax (DB2 SQL For Everyone or equivalent).