15.10 - FetchRowCount - Call-Level Interface Version 2

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

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

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 88 provides field information for the FetchRowCount parcel.

 

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