Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS forUNIX SQL Reference - NCR

NCR Teradata RDBMS forUNIX SQL Reference - NCR, 1997. - 913 p.
Download (direct link): teradataforunix1997.pdf
Previous << 1 .. 191 192 193 194 195 196 < 197 > 198 199 200 201 202 203 .. 241 >> Next

Teradata SQL Versus ANSI SQL

Teradata SQL Versus ANSI SQL: Introduction

Teradata SQL Versus ANSI SQL: Introduction

This appendix compares, in summary form, the current Teradata SQL with the ANSI SQL standard, primarily to provide information on portability issues.

The Teradata SQL software release used in this comparison is V2R2.0, the first Teradata release to include a complete set of entry-level ANSI-compliant features.

As the Teradata RDBMS evolves, each major release is expected to move Teradata SQL closer to conformance with full SQL2, and include features from the SQL3 standard.

It should be noted that portability can be defined at different levels. The largest differences between Teradata SQL and ANSI SQL are in Data Definition Language (DDL), and some issues of portability concern only the Data Management Language (DML) statements, that is Queries, Inserts, Updates and Deletes, where portability can be achieved by avoiding the use of a small set of Teradata SQL features or options, and a small set of ANSI SQL features or options.

V2R2.0 has been certified by U.S. Government NIST tests as conformable at ANSI SQL Entry Level. In practice, V2R2.0 also includes compliant versions in Intermediate ANSI SQL, and some functionality in Full ANSI SQL, as shown in Table B-1.

Because this appendix is for comparison, it does not include complete syntax and semantics of all Teradata RDBMS functions, particularly those which have no ANSI SQL counterparts. This manual, the Teradata RDBMS for UNIX SQL Reference, and the Teradata RDBMS for UNIX Database Design and Administration, are the primary resources for detailed exposition of Teradata RDBMS features.

A considerable amount of SQL functionality can be expressed in either Teradata SQL syntax, which will be supported for some time because of backward compatibility requirements, or in ANSI SQL syntax.New applications should use ANSI SQL syntax wherever it provides the required functionality.

Teradata RDBMS for UNIX SQL Reference

B-1
Teradata SQL Versus ANSI SQL

Teradata SQL Versus ANSI SQL: Summarized

Teradata SQL Versus ANSI SQL: Summarized

KeyWords and Phrases for Teradata SQL are listed below with indication of ANSI SQL equivalence. This comparison is a summary only, and does not cover semantic differences between the Teradata SQL and ANSI SQL. It does not include all of the keywords of ANSI SQL, that is, it does not allow for searching all ANSI SQL syntax for inclusion in the Teradata SQL.

Under ANSI SQL Equivalence:

ANSI(E) means entry level ANSI

ANSI(I) means intermediate level ANSI

ANSI(F) means full level ANSI

Table B-1

Teradata SQL Vs. ANSI SQL, Summarized

Teradata SQL Syntax or Function ANSI SQL Equivalence Notes
ABORT Non ANSI Extension See ROLLBACK WORK
ABORTSESSION Non ANSI Extension Performance Monitor Feature
ABS Non ANSI Extension Arithmetic Function
ACCOUNT Non ANSI Extension Administrative Feature
ADD ANSI(E) See ALTER TABLE
ADD_MONTHS Non ANSI Extension DateTime Function
AFTER Non ANSI Extension Journaling Option
ALL ANSI(E) with Extensions Qualified Comparisons
ALL PRIVILEGES ANSI(E) with Extensions Access Rights
ALTER TABLE ANSI(I) with Extensions Statement
AMP Non ANSI Extension Administrative Feature
AND ANSI(E) Boolean Expressions
ANY ANSI(E) Qualified Comparisons
AS ANSI(E) AS name
ASC ANSI(E) ORDER BY Direction

B-2

Teradata RDBMS for UNIX SQL Reference
Teradata SQL Versus ANSI SQL

Teradata SQL Versus ANSI SQL: Summarized

Teradata SQL Syntax or Function ANSI SQL Equivalence Notes
AVE Non ANSI Use AVG
AVERAGE Non ANSI Use AVG
AVG ANSI(E) Aggregate Function
BEFORE Non ANSI Extension Journaling Option
BEGIN LOGGING Non ANSI Extension Administrative Feature
BEGIN TRANSACTION Non ANSI See Transaction Modes
BETWEEN ANSI(E) Comparison Operator
BOTH ANSI(I) TRIM Option
BT Non ANSI See BEGIN TRANSACTION
BUT Non ANSI Extension See Access Rights
BYTE Non ANSI Extension Data Type
BYTEINT Non ANSI Extension Data Type
BYTES Non ANSI Extension Data Type
CASE ANSI(I) Expression
CASESPECIFIC Non ANSI Extension Data Attribute
CAST ANSI(I) Data Conversion Attribute
CD Non ANSI See CREATE DATABSE
CHAR ANSI(E) Data Type
CHARS Non ANSI Use CHAR or CHARACTER
CHARACTER ANSI(E) Data Type
CHARACTERS Non ANSI Use CHAR or CHARACTER
CHAR VARYING ANSI(I) Data Type
CHARACTER VARYING ANSI(I) Data Type
CHAR2HEXINT Non ANSI Extension String Function
CHECK ANSI(I) Column or Table Constraint
CHECKPOINT Non ANSI Extension Archive Function
CM Non ANSI Extension See CREATE MACRO
COALESCE ANSI(I) See CASE
COLLATION Non ANSI Teradata RDBMS and ANSI provide COLLATION control, but with different syntax.

Teradata RDBMS for UNIX SQL Reference

B-3
Teradata SQL Versus ANSI SQL

Teradata SQL Versus ANSI SQL: Summarized

Teradata SQL Syntax or Function ANSI SQL Equivalence Notes
COLLECT STATISTICS Non ANSI Extension Performance Feature
COMMENT Non ANSI Extension Administrative Feature Note: This is a Teradata RDBMS Dictionary table COMMENT, not a comment in a statement.
Previous << 1 .. 191 192 193 194 195 196 < 197 > 198 199 200 201 202 203 .. 241 >> Next