DB2 Stored Procedures (SQL PL)

Course Code: DWUSPL
Currency: V8 & V9
Duration: 3 days
Audience: Application Developers, Application Programmers, Production DBAs, Database Administrators and Capacity Planners.
Prerequisites: Completion of our course DB2 SQL Essentials or equivalent knowledge.
Summary: This course focuses on using the IBM DB2 UDB Development Center and Command Line Processor (CLP) to develop SQL procedures (SQL PL).
In addition to discussing a variety of ways complementing conventional SQL with procedural logic to solve simple to complex business requirements, the following related concepts are explored:
  • SQL PL vs. external procedures
  • Result set processing
  • Handling SQL PL exceptional conditions
  • When to consider dynamic SQL
  • When to consider nested SQL procedures
  • Identity columns vs. sequence objects
  • SQL PL in triggers
  • Debugging SQL PL
  • Introduction to VISUAL EXPLAIN

print  |  top of page