Checks for multiple results from the execution of its SQL request(s).
Syntax varies with the programming language.
The RESCHECK command uses the value from the SPAREA field SPSTATUS (see “SPSTATUS”), which specifies the status of the results returned.
CALL 'RESCHECK' USING SPAREA.
One RESCHECK must be issued for each expected result after the first result is received. If you expect the CSA to receive only one result, then you do not need to issue this command.
The REQEXEC command provides the
result information for the first or only SQL statement.
When the CSA issues the RESCHECK command, Mainframe Client Connect places result information in the SPSTATUS field. The CSA can examine this field to determine if more results are available. The possible values are:
'OK' indicates success.
'E' indicates an error.
'W' indicates a warning.
'R' indicates a result is available.
[Blank] indicates no result is available.
