DB2 SQL Stored Procedures & Triggers

Course Code: DBITSP
Duration: 4 days
Audience: Application Developers, Application Programmers, System Administrators and Capacity Planners.
Prerequisites: Completion of our course DB2 SQL Essentials or equivalent knowledge.
Summary: This course focuses on using DB2 UDB for iSeries to develop SQL procedures (SQL PL) and triggers.
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 condition
  • When to consider dynamic SQL
  • When to consider nested SQL procedures
  • Identity columns vs. sequence objects
  • SQL triggers
Objectives: Upon completion of this course, the delegate should be competent to deploy SQL stored procedures and triggers incorporating the features cited under 'Summary', above.
View full outline in PDF formatDetailed Outline

Course Schedule

Request a date for this course

Book Course

Course Outlines

Detailed course outlines are available in PDF format. Download Adobe's Acrobat Reader free from: www.adobe.com
Get Acrobat Reader

Training Topics

GENERAL

print  |  top of page