Test 000-545: DB2 9.7 SQL Procedure Developer

An IBM Certified Solution Developer - DB2 9.7 SQL Procedure Developer has significant experience with intermediate or advanced level skills in developing DB2 stored procedures, user defined functions and triggers.

Section 1 - SQL Procedural Language (30%)

1. Describe how to define variables and cursors
2. Demonstrate the ability to code assignment statements
3. Demonstrate knowledge of SQL Control statements
4. Demonstrate knowledge of error handling

Section 2 - DB2 SQL Procedures (23%)

1. Demonstrate knowledge how to identify proper usage of SQL procedures
2. Demonstrate the ability to use the CREATE PROCEDURE statement
3. Demonstrate knowledge of the proper structure of an SQL procedure body
4. Demonstrate knowledge of how to return values and result sets from SQL procedures
5. Demonstrate knowledge of nested procedures
6. Demonstrate how to test and deploy SQL procedure

Section 3 - Functions (12%)

1. Demonstrate knowledge how to identify proper usage of functions
2. Demonstrate the ability to use the CREATE FUNCTION statement
3. Demonstrate knowledge of the proper structure of a function body
4. Demonstrate knowledge of how to return values and a table using functions
5. Describe how to invoke functions
6. Demonstrate how to test and deploy functions

Section 4 - Triggers (8%)

1. Demonstrate knowledge how to identify proper usage of triggers
2. Demonstrate the ability to use the CREATE TRIGGER statement
3. Demonstrate the ability to identify the actions of a trigger
4. Demonstrate knowledge of advanced usage of triggers
5. Demonstrate how to test and deploy triggers

Section 5 - Advanced Features (16%)

1. Demonstrate knowledge of Declared Global Temporary Tables
2. Describe how to use system features (ADMIN_CMD)
3. Describe how to use Arrays and Associated Arrays
4. Describe how to use Global Variables
5. Describe how to use Modules
6. Describe how to enable a database to support PL/SQL procedures

Section 6 - Related Tools (10%)

1. Demonstrate knowledge of application development tools
2. Demonstrate knowledge of Debugging with tools
3. Demonstrate knowledge of using Explain with tools