Result-sets-OK - Teradata Tools and Utilities

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Tools and Utilities
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-11-17
dita:mapPath
oxw1641281447623.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
vfj1470443597526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.