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 .. 192 193 194 195 196 197 < 198 > 199 200 201 202 203 204 .. 241 >> Next

COMMIT ANSI(I) See COMMIT WORK
COMMIT WORK ANSI(E) Transaction Control Statement
COMPRESS Non ANSI Extension Data Storage Attribute
CONSTRAINT ANSI(I) In CREATE or ALTER TABLE, to define a Constraint
COUNT ANSI(E) Aggregate Function
CREATE DATABASE Non ANSI Analogy to CREATE SCHEMA. See also CREATE USER
CREATE INDEX Non ANSI Extension Correspondence to adding a UNIQUE or PRIMARY KEY constraint in ANSI
CREATE MACRO Non ANSI Extension Statement
CREATE TABLE ANSI(I) with Extensions Both ANSI and non-ANSI syntax are supported.
CREATE USER Non ANSI Analogy to CREATE SCHEMA
CREATE VIEW ANSI(E) Statement
CROSS JOIN ANSI(F) Join Type
CS Non ANSI See CASESPECIFIC
CT Non ANSI See CREATE TABLE
CV Non ANSI See CREATE VIEW
DATABASE Non ANSI Extension Statement. Used to specify default Database
DATABLOCKSIZE Non ANSI Extension Data storage control feature
DATE Non ANSI Keyword DATE is ANSI, but Teradata RDBMS DATE functionality is not the same as ANSI.
DAY ANSI(I) See EXTRACT function
DEC ANSI(E) Data Type
DECIMAL ANSI(E) Data Type
DEFAULT ANSI(E) Column attribute. Also used in extensions.

B-4

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
DEL Non ANSI Use DELETE
DELETE ANSI(E) Statement
DESC ANSI(E) ORDER BY direction
DISTINCT ANSI(E) Query option
DOUBLE PRECISION ANSI(E) Data Type
DROP DATABASE Non ANSI Statement
DROP INDEX Non ANSI Extension Correspondence to ALTER TABLE dropping a UNIQUE or PRIMARY KEY constraint in ANSI
DROP MACRO Non ANSI Extension Statement
DROP STATISTICS Non ANSI Extension Statement
DROP TABLE ANSI(I) Performance feature
DROP VIEW ANSI(I) Statement
DUAL Non ANSI Extension Journaling Option
EACH Non ANSI Extension Access Logging option
ECHO Non ANSI Extension User prompt
ELSE ANSI(I) In CASE expression
END ANSI(I) In CASE expression
END LOGGING Non ANSI Extension Access logging control
END TRANSACTION Non ANSI See Transaction Modes
EQ Non ANSI Use ='
ESCAPE ANSI(I) Option for LIKE
ET Non ANSI See END TRANSACTION
EXCEPT ANSI(I) Query Expression Operator
EXEC Non ANSI Extension See MACRO
EXECUTE Non ANSI Extension See MACRO
EXISTS ANSI(E) Predicate
EXP Non ANSI Extension Arithmetic function
EXPLAIN Non ANSI Extension Statement modifier
EXTRACT ANSI(I) Partial Teradata RDBMS version operates only on Teradata RDBMS DATE and TIME values.
FALLBACK Non ANSI Extension Data protection option

Teradata RDBMS for UNIX SQL Reference

B-5
Teradata SQL Versus ANSI SQL

Teradata SQL Versus ANSI SQL: Summarized

Teradata SQL Syntax or Function ANSI SQL Equivalence Notes
FIRST Non ANSI Extension Access logging option
FLOAT ANSI(E) Data type
FOR ANSI(I) Non ANSI Extension Substring option Locking modifier
FOREIGN KEY ANSI(I) Referential integrity
FORMAT Non ANSI Extension Type attribute and attribute function.
FREESPACE Non ANSI Extension Data storage control
FROM ANSI(E) Query phrase
FULL ANSI(I) Join type
GE Non ANSI Use >=
GIVE Non ANSI Extension Resource Management Feature
GRAPHIC Non ANSI Extension Data type
GRANT ANSI(E) With Extensions
GRANT OPTION Non ANSI Extension Logon control
GRANT OPTION FOR ANSI(I) Option for REVOKE
GROUP BY ANSI(E) With extensions
GT Non ANSI Use >
HASHAMP Non ANSI Extension Row distribution function
HASHBAKAMP Non ANSI Extension Row distribution function
HASHBUCKET Non ANSI Extension Row distribution function
HASHROW Non ANSI Extension Row distribution function
HAVING ANSI(E) Query phrase
HELP Non ANSI Extension User information function
HOUR ANSI(I) See EXTRACT
IMMEDIATE Non ANSI Extension Data storage control feature
IN ANSI(E) Comparison operator
INDEX Non ANSI Extension Privilege for CREATE and DROP INDEX
INNER ANSI(I) Join type
INS Non ANSI Use INSERT
INSERT ANSI(E) Statement
INT ANSI(E) Data type
INTEGER ANSI(E) Data type

B-6

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
INTERSECT ANSI(I) Query expression operator
INTO ANSI(E) Optional in INSERT for Teradata RDBMS, required for ANSI.
IS IN Non ANSI Use IN
IS NOT IN Non ANSI Use NOT IN
IS NOT NULL ANSI(E) Predicate
IS NULL ANSI(E) Predicate
JOIN ANSI(I) Specify joined tables
JOURNAL Non ANSI Extension Data protection control
LAST Non ANSI Extension Access logging control
LE Non ANSI Use <=
LEADING ANSI(I) TRIM option
LEFT ANSI(I) Join type
LIKE ANSI(E) String
LN Non ANSI Extension Arithmetic function
LOCAL Non ANSI Extension Journaling option
LOCK Non ANSI Extension Shared access control
LOCKING Non ANSI Extension Shared access control
LOG Non ANSI Extension Arithmetic function
LONG VARCHAR Non ANSI Extension Data type
LONG VARGRAPHIC Non ANSI Extension Data type
LT Non ANSI Use <
MAX ANSI(E) Aggregate function
MAXIMUM Non ANSI Use MAX
MCHARACTERS Non ANSI String function
Previous << 1 .. 192 193 194 195 196 197 < 198 > 199 200 201 202 203 204 .. 241 >> Next