Result-sets-OK - Call-Level Interface Version 2

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	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' DBRIRSON for Assembler DBC_RsltSetsNo for C DBC‑NO for COBOL DBC_RSLT_SETS_NO for PL/I
indicates that the connection used to call the procedure is used.	'Y' DBRIRSOY for Assembler DBC_RsltSetsYes for C DBC‑YES for COBOL DBC_RSLT_SETS_YES for PL/I

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 Chapter 17: “Stored Procedures.”