Statement-status-usage might be used to ascertain whether the DBCAREA Statement-status option is honored, and in what situations, or to what degree the Database returns information about the processing of a request.
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 whether the DBCAREA Statement-status option will be honored or ignored, and if honored, the type of information that might be returned about the processing of a request.
Item Code |
Mnemonic |
Response DBQERSSU (DbqerSSU for C) |
|
Field |
Value |
||
56 |
QEPISSU |
QERSSU |
A two-byte unsigned integer containing one of the following values: (QER_StmtStatusNone for C, NOT-SUPPORTED for COBOL, QER_STMT_STATUS_NONE for PL/I) if the StatementStatus response parcel is not supported. (QER_StmtStatusLevel1 for C, LEVEL1-SUPPORTED for COBOL, QER_STMT_STATUS_L1 for PL/I) if the StatementStatus response parcel may be returned and supports the following optional self-defining extensions: Warning message (id 1); Merge activity counts (id 10); TDP generated response (id 27). |
57
|
QEPIILB
|
QERILLB |
One of the following EBCDIC characters: (QER_NotSupported for C, NOT-SUPPORTED for COBOL, QER_NOT_SUPPORTED for PL/I). (QER_Supported for C, SUPPORTED for COBOL, QER_SUPPORTED for PL/I). |
QERILEN |
One of the following EBCDIC characters: (QER_NotSupported for C, NOT-SUPPORTED for COBOL, QER_NOT_SUPPORTED for PL/I). (QER_Supported for C, SUPPORTED for COBOL, QER_SUPPORTED for PL/I. |
||
QERILCU |
Smart LOB Request Support. A two-byte unsigned integer indicating the support level of the Smart LOB Request. (QER_LobRequestUsageNone for C LOB-REQUEST-USAGE-NONE for COBOL QER_LOB_REQUEST_USAGE_NONE for PL/I) if LOB requests is not supported (QER_LobRequestUsageLevel1 for C LOB-REQUEST-USAGE-LVL1 for COBOL QER_LOB_REQUEST_USAGE_LVL1 for PL/I) sif LOB requests is supported at Level 1 |
||
QERILSU |
Smart LOB Response Support. A two-byte unsigned integer indicating the support level of the Smart LOB Response. (QER_LobResponseUsageNone for C LOB-RESPONSE-USAGE-NONE for COBOL QER_LOB_RESPONSE_USAGE_NONE for PL/I) if LOB requests is not supported (QER_LobResponseUsageLevel1 for C LOB-RESPONSE-USAGE-LVL1for COBOL QER_LOB_RESPONSE_USAGE_LVL1 for PL/I) if LOB requests is supported at Level 1 |