Archives of the TeradataForum
Message Posted: Tue, 06 Apr 1999 @ 23:16:00 GMT
| Subj: | | Re: Ansi Compliance in Teradata |
| |
| From: | | John K. Wight |
Teradata V2R2.0 and higher releases are ANSI-92 Entry Level Compliant. In addition, many features of ANSI-92 Intermediate and
Full specifications are implemented and compliant to the standard definition. (No other vendor does all of Intermediate or Full
compliance either. In fact, other vendors typically have features that exist in the standard but the vendor implementation is not
compliant; most notable is the Oracle implementation of Outer Join which is not ANSI compliant but does not force them to say they
are no because it is an Intermediate level feature.)
As noted, Teradata also has, and will continue to have and expand on, extensions above and beyond the standard. Our policy is that
any feature implemented which exists in the standard will be standard compliant but we will not allow that to keep us from innovating
above and beyond.
V2R3 has several new ANSI Intermediate and Full features including ANSI Date, TimeStamp and interval datatypes, ANSI string
function definitions and Triggers.
Hope this helps. Thanks to the Teradata CTO (Todd Walter) for the clarification!
JK
John K. Wight
Senior Solutions Consultant - Retail Solutions Group
NCR Corp.
| 
