Loading Course Schedule...
PT27076
Training Summary
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 and deployment with no green screen. Students will leave this course with the ability to code new SQL PL stored procedures and maintain existing. This is a very hands-on course where students code, test, and deploy 7 stored procedure programs. First introduced in V9, there has been a number of enhancements to the SQL PL language that also get covered in this course. Topics like XML parameters, array parameters, autonomous processing, piece-wise delete, and UDF code enhancements are covered. Everyone leaves with a set of ‘Best Practices’.
Prerequisites
Understanding of relational database concepts and SQL syntax (Db2 SQL For Everyone or equivalent).
Duration
3 Days/Lecture & Lab
Audience
Analysts and programmers involved in the development of Db2 for z/OS SQL Stored Procedures.
Course Topics
- 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
- User Defined Functions with SQL PL