FetchRowCount - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-07
dita:mapPath
jen1488824663137.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

Specifies the maximum number of rows, as specified by the DBCAREA Row-count field, to return in the response buffer. When the parcel is not present no row limit exists.

Parcel Data

The following table provides field information for the FetchRowCount parcel.

FetchRowCount Parcel Information 
Flavor Mnemonic TRDSPBRC
Field Length Value
190 TRDSPFRC PBRCCNT 4-byte unsigned integer Maximum number of rows to return in the response buffer. A value of zero imposes no row limit.
PBRCOACT 1-byte unsigned integer If the count cannot be satisfied, indicates whether an error (a value of zero) is reflected or the count is ignored (a value of one). When built by CLIv2, zero is forced.

If the DBCAREA option Request-mode=B was specified and a request is being built that is similar to what CLIv2 builds, when present, the FetchRowCount parcel must be immediately before whichever of the ExtendedRespond, ExtendedKeepRespond, KeepRespond, or Respond parcels is present. Whether the FetchRowCount parcel is supported by the Database can be ascertained using the CLIv2 DBCHQE Build-information query.