When a client request executes a server procedure or transaction, it can generate various types of result sets that are returned to the client application. These include:
Regular row results, which contain one or more rows of tabular data.
Return parameter results, which contain a single row of return parameter data. Return parameters are values returned by stored procedures and transactions in the parameters (arguments) of the called function. For information on return parameters, see “Remote procedure calls (RPCs)”.
Return status results, which consist of a single row that contains a single value, a return status. For more information on a stored procedure return status, see “Remote procedure calls (RPCs)”.
These are the only result types supported by Open ClientConnect. Although
additional result types are supported by Open Client for other platforms,
they are not supported on the mainframe.
Results are returned to an application in the form of result sets. A result set contains only a single type of result data. Regular row result sets can contain multiple rows of data, but other types of result sets contain at most a single row of data.
An application processes results by calling CTBRESULTS. The type of result available is indicated in the RESULT-TYP argument. The application calls CTBRESULTS once for each result row. CTBRESULTS returns CS-CMD-DONE in RESULT-TYP to indicate that a result set processed completely.
Some requests, for example a language request containing a Transact-SQL update statement, do not generate results. CTBRESULTS returns CS-CMD-SUCCEED to indicate the success of a request that does not return results.
