In addition to defining output parameters, procedures can return one or more result sets. When defining a procedure that returns a result sets, you must define the maximum number of result sets to be returned using the following syntax:
DYNAMIC RESULT SETS <xx>
XX
is the maximum number of result sets that could be returned by the procedure. The valid values are from 1 to 99.

The default is that the procedure does not return any result sets.