SET RESULT SETS
The SET RESULT SETS statement identifies one or more result sets that can be returned from a
procedure when the procedure is called by a Client Access client, the SQL Call Level Interface, or when
access from a remote system using DRDA.
Invocation
This statement can only be embedded in an application program. It is an executable statement that cannot
be dynamically prepared. It is not allowed in a REXX procedure.
Authorization
None required.
Syntax
 SET RESULT SETS
,
ARRAY host-structure-array FOR host-variable ROWS
CURSOR cursor-name
NONE

Description
CURSOR cursor-name
Identifies a cursor to be used to define a result set that can be returned from a procedure. The
cursor-name must identify a declared cursor as explained in “Description” on page 375 for the
DECLARE CURSOR statement. When the SET RESULT SETS statement is executed, the cursor
must be in the open state.
ARRAY host-structure-array
host-structure-array identifies an array of host structures defined in accordance with the rules for
declaring host structures. The array cannot contain a C NUL-terminated host variable.
The first structure in the array corresponds to the first row of the result set, the second structure in the
array corresponds to the second row of the result set, and so on. In addition, the first value in the row
corresponds to the first item in the structure, the second value in the row corresponds to the second
item in the structure, and so on.
LOBs cannot be returned in an array when using DRDA.
Only one array can be specified in a SET RESULT SETS statement.
FOR host-variable ROWS
Specifies the number of rows in the result set. The host-variable must be a numeric host variable with
zero scale, and it must not include an indicator variable. The number of rows specified must be in the
range of 0 to 32767 and must be less than or equal to the dimension of the host structure array.
NONE
Specifies that no result sets will be returned. Cursors left open when the procedure ends will not be
returned.