ANSI SQL with No Equivalent Teradata Simulation - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities
ANSI SQL abilities that have no equivalent in Teradata Database are not simulated. Use of these features will cause errors. Examples are as follows:
  • UPDATE and DELETE where CURRENT OF cursor (cursor library can be used to provide this functionality)
  • Outer join extensions to SQL
  • Cursor scrolling is limited to the forward direction only