Statement-status-usage - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

Statement-status-usage

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:

  • 0 with mnemonic QERSSUN (QER_StmtStatusNone for C, NOT-SUPPORTED for COBOL, QER_STMT_STATUS_NONE for PL/I) if the StatementStatus response parcel is not supported.
  • 1 with mnemonic QERSSU1 (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).