02 9482 8200 info@datasync.com.au

CL71: DB2 Stored Procedures Programming Workshop

Code: CL71
Duration: 2 days

Description

This course is designed to provide the database application designer with knowledge to recognise when a stored procedure is the correct solution for an application. The development of stored procedures is taught using the SQL Procedural Language. This course exposes you to the IBM Optim Development Studio GUI tool to rapidly develop and test SQL stored procedures using the SQL Procedural Language. In addition to using the GUI tool to develop and implement stored procedures, you are taught how to implement these SQL stored procedures using a text editor with the IBM DB2 Command Window and the Command Editor.

The course engages you in a series of lectures, each followed by a hands-on exercise to create and call SQL procedures using extensive process flows and cursor processing to return result sets to the invoking client or caller. Each exercise builds on the previous exercise to allow the student to use condition handling, dynamic SQL, user-defined types, large objects, nested procedures, IBM Optim Development Studio debugging facility, SQL procedure tracing using sqlpltrc, security considerations, and tuning and performance techniques.

Outcomes

  • Describe stored procedures
  • List Intel platform requirements for supporting DB2 stored procedures
  • Discuss and demonstrate capabilities of the IBM Optim
  • Development Studio to implement SQL stored procedures
  • Describe basic SQL procedure structure
  • Demonstrate the use of SQL Procedure Language Elements
  • Use cursor processing to return result sets to the invoker
  • Handle Exceptions
  • Nest Stored Procedures
  • Use IBM Optim Development Studio debugging capability to debug an SQL stored procedure
  • Use sqlpltrc API to trace SQL stored procedures
  • Employ security techniques for SQL procedures
  • Analyze and improve SQL access plans

Audience

This intermediate course is for:

  • Database application designers and database application programmers supporting DB2 stored procedures in a Linux, UNIX, or Windows environment, would all benefit from attending this course.
  • Database application programmers supporting DB2 stored procedures with the SQL database language.

Prerequisites

Database application designers and database application programmers supporting DB2 stored procedures with the SQL database language. This prerequisite knowledge may be from prior experience or attendance at CE03 – DB2 Family Fundamentals or CE12 – DB2 SQL Workshop

Format

The course is taught using lectures, demos, and machine exercises on a Windows platform using DB2.

This course is also offered as web-based training. Please contact us for more information.

Course available by request – please contact us for further details.