CLIv2-limits might 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 totalling 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. |
||