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)|
|56||QEPISSU||QERSSU||A two-byte unsigned integer containing one of the following values:
|One of the following EBCDIC characters:
||One of the following EBCDIC characters:
Smart LOB Request Support.
A two-byte unsigned integer indicating the support level of the Smart LOB Request.
Smart LOB Response Support.
A two-byte unsigned integer indicating the support level of the Smart LOB Response.
||One of the following binary value characters: