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.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

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).
    		•

    57

     

     

     

    QEPIILB

     

     

     

    QERILLB
    LOB-SUPPORT for C
    LOB-SUPPORT for COBOL
    LOB_SUPPORT for PL/I

    One of the following EBCDIC characters:

  • ‘N’ with mnemonic QERILLBN
    (QER_NotSupported for C,
    NOT-SUPPORTED for COBOL,
    QER_NOT_SUPPORTED for PL/I).
  • ‘Y’ with mnemonic QERILLBY
    (QER_Supported for C,
    SUPPORTED for COBOL,
    QER_SUPPORTED for PL/I).
    		•

    QERILEN
    elicitName for C
    ELICIT-NAME for COBOL
    ELICIT_NAME for PL/I

    One of the following EBCDIC characters:

  • ‘N’ with mnemonic QERILENN
    (QER_NotSupported for C,
    NOT-SUPPORTED for COBOL,
    QER_NOT_SUPPORTED for PL/I).
  • ‘Y’ with mnemonic QERILENY
    (QER_Supported for C,
    SUPPORTED for COBOL,
    QER_SUPPORTED for PL/I.
    		•

    QERILCU
    LobRequestUsage for C
    LOB-REQUEST-USAGE for COBOL
    LOB_REQUEST_USAGE for PL/I

    Smart LOB Request Support.

    A two-byte unsigned integer indicating the support level of the Smart LOB Request.

  • 0 with mnemonic QERILCUN
    (QER_LobRequestUsageNone for C
    LOB-REQUEST-USAGE-NONE for COBOL
    QER_LOB_REQUEST_USAGE_NONE for PL/I)
    if LOB requests is not supported
  • 1 with mnemonic QERILCU1
    (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
    LobResponseUsage for C
    LOB-RESPONSE-USAGE for COBOL
    LOB_RESPONSE_USAGE for PL/I

    Smart LOB Response Support.

    A two-byte unsigned integer indicating the support level of the Smart LOB Response.

  • 0 with mnemonic QERILSUN
    (QER_LobResponseUsageNone for C
    LOB-RESPONSE-USAGE-NONE for COBOL
    QER_LOB_RESPONSE_USAGE_NONE for PL/I)
    if LOB requests is not supported
  • 1 with mnemonic QERILSU1
    (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
    		•