Execute DB2 command to display all defined subsystems - the following screen is shown:
Screen 1 - Defined DB2 subsystems
In the Rcmd column next to the subsystem DSN9 enter spm command. The 'DX/SPM - Select routines' pop-up window is displayed. To limit selection of routines enter SYSPROC in the Routine schema field:
Screen 2 - Select routines
Next to DSNACCOR stored procedure in Rcmd column enter run command to prepare SP for execution:
Screen 3 - Enter run command to prepare the stored procedure for execution
A screen with the DSNACCOR parameters is display. The input parameters are formatted as modifiable fields so that you can enter input information. The output parameters are protected fields which mat receive values after the stored procedure execution.
Screen 4 - DSNACCOR parameters
Fill the input parameters on the screen and use UP/DOWN commands (PF7/PF8) to scroll screen up and down. When all parameters are entered press ENTER key.
Screen 5 - DSNACCOR parameters - 2
After stored procedure is executed the output parameters are filled in and several information sections are displayed:
- Generated SQL statement - shows generated SQL statement used to test the stored procedure.
- SQL message - is DSNTIAR translated message obtained from SQLCA that was set after the CALL statement.
- Procedure returned 2 result set(s) - list first 20 rows of all returned result sets
Screen 6 - After CALL statement - 1
Screen 7 - After CALL statement - 2
Screen 8 - After CALL statement - 3
Screen 9 - After CALL statement - 4
Screen 10 - After CALL statement - 5