BLOB/CLOB Limitations - 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

BLOB/CLOB Limitations

The following is a list of BLOB and CLOB limitations.

  • LOB columns cannot be updated through rowset objects.
  • Random order is not supported (i.e. DBPROP_ACCESSORORDER cannot be set to DBPROPVAL_AO_RANDOM).
  • For a rowset, only one LOB column can be bound to a storage object in an accessor.
  • If a LOB column in a rowset is to be bound to a storage object, it must be the highest numbered ordinal in the binding of the accessor.
  • LOB columns are not searchable.
  • DB_E_BADSTORAGEFLAG when IRowset::GetData is called if a LOB column has been bound with type defined as DBTYPE_IUNKNOWN, and IID_ISequentialStream specified with write access.
  • The IStream interface is not supported. Only the ISequentialStream interface is supported.