16.20 - Fetch-maximum-data-length - Teradata Tools and Utilities

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

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

Fetch-maximum-data-length is a four-byte field that specifies the length in bytes of the move area, if any, allocated by the application.

In this language... The variable name for Fetch-maximum-data-length is...
COBOL DBCAREA-FET-MAX-DATA-LEN
PL/I FET_MAX_DATA_LEN
C, C++ fet_max_data_len
IBM Assembler DBFIFDL
This routine... Does this for Fetch-maximum-data-length...
DBCHINI writes
DBCHCL reads (FET)
Fetch-maximum-data-length is used by... To...
applications write
Review the following conditions before calling DBCHCL for any of the following functions:
  • Connect
  • RunStartUp
  • Initiate with Protocol-function
  • Command
  • Initiate Request

If an application is using Move Mode for processing the parcels in the response (that is, Locate-mode is set to N and Parcel-mode-fetch is set to Y in the DBCAREA), then the application must allocate the move area and place its length in Fetch-maximum-data-length.

If Maximum Data Length is set to... Then the largest parcel body is...
O 32763
H 2,147,483,639

Whether Varying-length-fetch is set to N or Y, the length of the move area must be large enough for the largest parcel body. If Varying-length-fetch is set to Y, two more bytes are required for the preceding length field.