Before you begin, you must complete Exercise 1.3: Creating and building an SQL stored procedure.
The workbench includes an integrated SQL stored procedure debugger. By stepping through your code while running in debug mode and viewing the results, you can discover problems with your stored procedure and make the necessary changes.
The stored procedure debugger supports only debugging SQL stored procedures, with some further limitations depending on your operating system and DB2(R) Universal Database(TM) version. See the SQL stored procedure debugger help topics in the information center for more details.
To debug the stored procedure:
DEPT
, type D11
.
D11 is the ID for a department (EMPLOYEE.WORKDEPT) in the EMPLOYEE table. When you enter this value, the stored procedure will return rows that match this department ID.
The stored procedure opens in the Debug perspective.
Now you are ready to begin Exercise 1.5: Running the SQL stored procedure.
Terms of use | Feedback
(C) Copyright IBM Corporation 2000, 2005.
All Rights Reserved.