Keep-response - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
lvt1544831946862.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

Keep-response is a one-byte field that specifies whether the database is to keep the spool file after it sends the last parcel of the Teradata SQL response to the client.

Within an External Stored Procedure, a request initiated with the DBCAREA Return-result-to option, a Keep-response setting of 'N' is not permitted. A setting of 'Y' indicates that the results are non-scrollable so are positioned to the next unfetched row, with fetched rows not propagated; while a setting of 'P' indicates that results are scrollable so the propagated results are positioned to the last row fetched, with earlier fetched rows also propagated.

If the procedure used a multi-statement request (multiple SQL statements separated by semicolons) to return results, the response to each of these requests is reflected. If the procedure positioned to other than the first of these responses, the earlier ones are positioned beyond the end of their rows. While scrollable results may be repositioned to these earlier statement rows, non-scrollable results cannot.

In this language... The variable name for Keep-response is...
COBOL DBCAREA-KEEP-RESP
PL/I KEEP_RESP
C, C++ keep_resp
IBM Assembler DBOKRSP
This routine... Does this for Keep-response...
DBCHINI writes
DBCHCL reads (CON; RSUP; IRQ; IWPF; CMD)
Keep-response is used by... To...
applications write.