When a client request executes a server procedure or transaction, it can generate the following types of result sets that are returned to the client application:
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 contain a single return status value. 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 ct_results, which indicates the type of result available by setting the result_type argument. The application calls ct_results once for each result row. ct_results returns CS_CMD_DONE in result_type 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. ct_results returns CS_CMD_SUCCEED
to indicate the success of a request that does not return results.
