Archives of the TeradataForum

Message Posted: Tue, 06 Apr 1999 @ 23:16:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>