IColumnsRowset - 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

IColumnsRowset

Programming Limitations

The following programming limitations apply:

  • If the consumer uses a column alias, then OLE DB Provider for Teradata does not return the corresponding column name of the underlying table in DBCOLUMN_BASECOLUMNNAME.
  • Example:

    SELECT  CustomerNo as CustNo
      CarMaker as CarManufacturer
      CarModel
      from ServiceHistory

    In this case, the aliases CustNo and CarManufacturer are returned in the columns DBCOLUMN_BASECOLUMN and DBCOLUMN_NAME.

  • Auto increment columns are not supported in Teradata. For the DBCOLUMN_ISAUTOINCREMENT column, OLE DB Provider for Teradata returns a value of FALSE.
  • For the DBCOLUMN_ISCASESENSITIVE column, OLE DB Provider for Teradata always returns a value of FALSE.