16.20 - CLIv2-limits - 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

CLIv2-limits can be used either to choose CLIv2 settings to optimize its execution for the accessed Teradata Database or to prevent errors caused by exceeding limits.

Refers to the Teradata Database associated with the TDP whose TDP identifier is addressed by the QEPTIDP field and has length specified by the QEPTLEN field. Since they do not apply, the QEPRQST and QEPTOKEN fields must contain binary zeroes.

Returns limits for the Teradata Database affecting an application's values for CLIv2 settings. The response consists of four fields totaling thirty-two bytes.

Item Code Mnemonic ResponseDBQERC2L (DbqerC2L for C)
Fields Value
35 QEPIC2L QERC2LQL ('requestLen' for C, REQUEST-LEN for COBOL, REQUEST_LEN for PL/I)

An eight-byte unsigned integer that specifies the maximum Request-length in bytes.

In C compilers not supporting 64bit integers, an array named 'requestLenHalf' consisting of two four-byte unsigned integers, each containing four bytes of the value, is used.

QERC2LGL ('segmentLen' for C, SEGMENT-LEN for COBOL, SEGMENT_LEN for PL/I)

An eight-byte unsigned integer that specifies the maximum segment Request-length in bytes for SQL Stored Procedures (refer to Stored Procedures).

In C compilers not supporting 64bit integers, an array named 'segmentLenHalf' consisting of two four-byte unsigned integers, each containing four bytes of the value, is used.

QERC2LUL ('usingLen' for C, USING-LEN for COBOL, USING_LEN for PL/I)

An eight-byte unsigned integer that specifies the maximum Using-data-len in bytes.

In C compilers not supporting 64bit integers, an array named 'usingLenHalf' consisting of two four-byte unsigned integers, each containing four bytes of the value, is used.

QERC2LSL ('responseLen' for C, RESPONSE-LEN for COBOL, RESPONSE_LEN for PL/I)

An eight-byte unsigned integer that specifies the maximum Response-len in bytes.

In C compilers not supporting 64bit integers, an array named 'responseLenHalf' consisting of two four-byte unsigned integers, each containing four bytes of the value, is used.