Result-sets-OK is a one byte EBCDIC field that indicates whether SQL results selected by SQL or External Stored Procedures may be propagated to the application.
Result-sets-OK exists only when DBCHINI had been called for a DBCAREA with Total-length set to at least 640 (that is, the returned DBCAREA Level value is at least 1). For a smaller DBCAREA, Result-sets-OK is ignored.
In this language... | The variable name for Result-sets-OK is... |
---|---|
COBOL | RESULT-SETS-OK |
PL/I | RESULT_SETS_OK |
C, C++ | resultSetsOK |
IBM Assembler | DBRIRSO |
This routine. . . | Does this for Result-sets-OK. . . |
---|---|
DBCHINI | writes |
DBCHCL | reads (RSUP; IRQ; IWPF) |
Result-sets-OK are used by. . . | To... |
---|---|
applications | write |
One of the following values may be set before initiating a request:
If... | Then set Connect-type to... |
---|---|
indicates that a new connection is established. | 'N'
|
indicates that the connection used to call the procedure is used. | 'Y'
|
If not specified, the default from the HSHSPB is used, which as distributed is "N". This default is provided to allow the possible return of results from a procedure in diagnostic situations. The procedure could always attempt to return diagnostic information but this information is received by the application only if the HSHSPB default is changed. If such use is envisioned, the application should allow for the ResultSet parcel and data even though it is not expected under normal circumstances.
For details on External Stored Procedures, refer to Stored Procedures.