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
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

FetchRowCount

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

Table 87 provides field information for the FetchRowCount parcel.

 

Table 87: 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.