Problem:
This is the easiest and quickest way to animate a DB2 stored procedure with UDB 8.1 with latest fixes or a later version of UDB. This assumes that the Net Express development environment is installed on the UDB server machine.
Resolution:
The procedure for animating a COBOL Stored proedure is as follows:-
1. put a call to CBL_DEBUGBREAK within in your stored procedure program
2. compile the stored procedure and create it as a dll
3. link the stored procedure with db2api.lib
4. make sure the stored procedure dll is linked as shared , dynamic and includes the system files
5. copy dll to IBM's sqllib\\function subdirectory
6. run the stored procedure from IBM's development center and enter necessary parameters
7. when the dialog box appears that indicates the RTS has encountered a call to CBL_DEBUGBREAK , do you want to debug - answer yes
8. the stored procedure should pop up in animator, ready for animating
Note: Review your animation setting and ensure that "attach to the process" is not set.
