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

Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

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.”