16.20 - FetchRowCount - Teradata Tools and Utilities

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

Teradata Tools and Utilities
September 2019
Programming Reference


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.