15.10 - Appendix C ANSI/ISO SQL Compliance - Teradata Database

Teradata Database SQL Fundamentals

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1141-151K

Teradata Database conforms closely to the ANSI/ISO SQL standard while supporting extensions that enable users to take full advantage of the efficiency benefits of parallelism. Teradata develops new features that conform to existing ANSI/ISO standards and handles differences between Teradata SQL and ANSI/ISO SQL as follows:

 

WHEN ...

THEN ...

the difference between the Teradata SQL dialect and the ANSI/ISO SQL standard for a language feature is slight

the ANSI/ISO SQL is added to Teradata Database feature as an option.

the difference between the Teradata SQL dialect and the ANSI/ISO SQL standard for a language feature is significant

both syntaxes are offered and the user has the choice of operating in either Teradata or ANSI mode or of turning off SQL Flagger. The mode can be defined:

  • Persistently
  • Use the SessionMode field of the DBS Control Record to define session mode characteristics.

  • For a session
  • Use the BTEQ .SET SESSION TRANSACTION command to control transaction semantics.

    Use the BTEQ .SET SESSION SQLFLAG command to control use of the SQL Flagger.

    Use the SQL statement SET SESSION DATEFORM to control how data typed as DATE is handled.