Teradata Database Limitations
Limitations that exist in Teradata Database also exist for OLE DB Provider for Teradata.
The limitations are:
No support for distributed transactions.
No support for more than 2048 columns in table.
No support for more than 255 characters in a string constant.
No support for nested transactions.
No support for catalogs. The Schema name is equivalent to the Database name in Teradata.
Support for only Static cursors that move forward.
For Teradata Database, SQL is limited to 1048448 bytes.
If attempting an update or delete using a qualified character (CHAR or VARCHAR) column
with characters containing a WAVE DASH or MINUS, Teradata may not be able to process
the request correctly, since there are multiple Unicode character translations to
SJIS (as well as EUC and EBCDIC) WAVE DASH or MINUS.
OLE DB Provider for Teradata does not support Bookmarks.