Result set that the SQL procedure processor (DSNTPSMP) returns
DSNTPSMP returns one result set that contains messages and listings. You can write your client program to retrieve information from this result set. Because DSNTPSMP is a stored procedure, use the same technique that you would use to write a program to receive result sets from any stored procedure.
Each row of the result set contains the following information:
- Processing step
- The step in the DSNTPSMP function process to which the message applies.
- DD name
- The DD statement that identifies the data set that contains the message.
- Sequence number
- The sequence number of a line of message text within a message.
- Message
- A line of message text.
Rows in the message result set are ordered by processing step, DD name, and sequence number.
For an example of how to process a result set from DSNTPSMP, see the Db2 sample program DSNTEJ65.