FetchRowCount - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-12
dita:mapPath
dsu1527114222346.ditamap
dita:ditavalPath
dsu1527114222346.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.

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 Teradata Database can be ascertained using the CLIv2 DBCHQE Build-information query.