Properties Associated with BLOBs and CLOBs - OLE DB Provider for Teradata

OLE DB Provider for Teradata User Guide

Product: OLE DB Provider for Teradata
Release Number: 15.00
Language: English (United States)
Last Update: 2018-09-28
dita:id: B035-2498
Product Category: Teradata Tools and Utilities

Properties Associated with BLOBs and CLOBs

Table 17: BLOB and CLOB Properties
Property	Comments
DBPROP_ACCESSORORDER	Current Setting: READ-WRITE, DBPROPVAL_AO_SEQUENTIALSTORAGEOBJECT Used to specify the order in which columns must be accessed by methods that operate on rowsets. OLE DB Provider for Teradata only supports DBPROPVAL_AO_SEQUENTIALSTORAGEOBJECT.
DBPROP_DELAYSTORAGEOBJECT	Current Setting: READ-ONLY VARIANT_FALSE Determines whether LOBs can be used in deferred update mode. VARIANT_FALSE indicates that LOB columns will be updated immediately even when in deferred mode.
DBPROP_MULTPLESTORAGEOBJECTS	Current Setting: READ-ONLY VARIANT_FALSE Determines whether multiple storage objects can be opened at the same time. VARIANT_FALSE indicates only one storage object can be opened.
DBPROP_BLOCKINGSTORAGEOBJECT	Current Setting: READ-ONLY VARIANT_TRUE Determines whether storage objects will prevent the use of other methods on the rowset between the time the object has been created and released. VARIANT_TRUE indicates instantiated storage objects might prevent the use of other methods on the rowset.
DBPROP_UPDATABILITY DBPROP_IRowsetChange DBPROP_IRowsetUpdate	These properties control whether data in a rowset can be updated. LOBs are not supported when updating through a rowset object; therefore, these properties have no affect on LOBs.