16.20 - Result-sets-OK - Teradata Tools and Utilities

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

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

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

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.