Duration: 2 days
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.
- 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
- 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.
This course is also offered as web-based training. Please contact us for more information.