16.20 - Integrated-LOB - 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

Integrated-LOB might be used to ascertain whether various aspects of Large-objects (BLOBs or CLOBs) are supported by the Teradata Database.

Refers to the TDP whose TDP identifier is addressed by the QEPTDP 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 Large-objects are supported by the Teradata Database; whether DEFERRED Large-objects can be identified by name; whether requests may provide a Large-object inline, overriding a DEFERRED specification; and whether responses can override a DBCAREA Return-objects-as option to defer data by returning a locator.

The QERILLO and QERILLN items are also included in the Aggregate-support-list query item.

This query deprecates the Large-object-support and LOB-NAME-support queries.

Item Code Mnemonic Response DBQERIL (DbqerIL 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 QEPIIL
QERILLO
  • largeObjectSupport
  • LARGE-OBJECT-SUPPORT for COBOL
  • LARGE_OBJECT_SUPPORT for PL/I
One of the following EBCDIC characters:
  • ‘N’ with mnemonic QERILLON (QER_NotSupported for C, NOT-SUPPORTED for COBOL,QER_NOT_SUPPORTED for PL/I).
  • ‘Y’ with mnemonic QERILLOY (QER_Supported for C, SUPPORTED for COBOL, QER_SUPPORTED for PL/I).
    QERILLN
  • lobNameSupport for C
  • LOB-NAME-SUPPORT for COBOL
  • LOB_NAME_SUPPORT for PL/I
One of the following EBCDIC characters:
  • ‘N’ with mnemonic QERILLNN (QER_NotSupported for C, NOT-SUPPORTED for COBOL,QER_NOT_SUPPORTED for PL/I).
  • ‘Y’ with mnemonic QERILLNN (QER_Supported for C, SUPPORTED for COBOL, QER_SUPPORTED for PL/I.
    QERILQU
  • requestUsage for C
  • REQUEST-USAGE for COBOL
  • 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 QERILQUN (QER_Ilob_RqstUsageNone for C, NOT-SUPPORTED for COBOL, QER_ILOB_RQST_USAGE_NONE for PL/I) If LOB requests is not supported.
  • 1 with mnemonic QERILQU1 (QER_Ilob_RqstUsageLvl1 for C, LEVEL1-SUPPORTED for COBOL, QER_ILOB_RQST_USAGE_LVL1 for PL/I) if LOB requests is supported at Level 1
    QERILSU
  • responseUsage for C
  • RESPONSE-USAGE for COBOL
  • 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_Ilob_RespUsageNone for C, NOT-SUPPORTED for COBOL, QER_ILOB_RESP_USAGE_NONE for PL/I) if LOB requests is not supported
  • 1 with mnemonic QERILSU1 (QER_Ilob_RespUsageLvl1 for C, LEVEL1-SUPPORTED for COBOL,QER_ILOB_RESP_USAGE_LVL1 for PL/I) if LOB requests is supported at Level 1
58 QEPIUPU QERUPU
  • DbgerUPU for C
  • QERUPU for COBOL
  • DBQERUPU for PL/I
One of the following binary value characters:
  • 0 with mnemonic QERUPUN (QER_UnicodePassthroughUsageNone for C, NOT-SUPPORTED for COBOL, QER_UNICODE_PASSTHROUGH_USAGE_NONE for PL/I).
  • 1 with mnemonic QERUPU1 (QER_UnicodePassthroughUsageLvl1 for C, LEVEL1-SUPPORTED for COBOL, QER_UNICODE_PASSTHROUGH_USAGE_LVL1 for PL/1).