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

Advanced SQL

EXPLAIN Modifier: Examples of Complex Queries

Teradata mode produces the following result:

Explanation

1) First, we lock a distinct PERSONNEL."pseudo table" for write on a RowHash to prevent global deadlock for PERSONNEL.employee.

2) Next, we lock PERSONNEL.employee for write.

3) We do an all-AMPs UPDATE from PERSONNEL.employee by way of an all-rows scan with a condition of ("PERSONNEL.employee.DeptNo = 640").

4) Finally, we send out an END TRANSACTION step to all AMPs involved in processing the request.

-> No rows are returned to the user as the result of statement 1.

In ANSI mode the transaction is not COMMITed, therefore it is not ended, whereas in Teradata mode, no COMMIT is required to end the transaction.

Teradata RDBMS for UNIX SQL Reference

9-31
Advanced SQL

EXPLAIN Modifier: Examples of Complex Queries

9-32

Teradata RDBMS for UNIX SQL Reference
Teradata SQL Keywords

Appendix A

Teradata SQL Keywords

Teradata RDBMS for UNIX SQL Reference
Teradata SQL Keywords

Teradata RDBMS for UNIX SQL Reference
Teradata SQL Keywords

Teradata SQL Keywords

Teradata SQL Keywords

The Teradata SQL keywords, which are reserved for use in SQL statements are listed below. For abbreviations, the full spelling follows the abbreviation, in parentheses).

ABORT

ABORTSESSION

ABS

ACCOUNT

ADD

ADD_MONTHS

AFTER

ALIAS

ALL

ALTER

AMP

AND

ANY

AS

ASC

ASCII

AUTHORIZATION AVE (AVERAGE)

AVERAGE

AVG (AVERAGE)

BACKUP

BEFORE

BEGIN

BETWEEN

BOTH

BT (BEGIN TRANSACTION)

BUT

BY

BYTE

BYTEINT

BYTES

CASE

CASESPECIFIC

CAST

CD (CREATE DATABASE)

CHAR (CHARACTERS)

CHARACTER (CHARACTERS)

CHAR2HEXINT

CHARACTERS

CHARS (CHARACTERS)

CHECK

CHECKPOINT

CLUSTER

Teradata RDBMS for UNIX SQL Reference

A-1
Teradata SQL Keywords

Teradata SQL Keywords

CM (CREATE MACRO)

COALESCE

COLLATION

COLLECT

COLUMN

COMMENT

COMMIT

COMPRESS

CONSTRAINT

COUNT

CREATE

CROSS

CS (CASESPECIFIC)

CT (CREATE TABLE)

CURRENT

CURSOR

CV (CREATE VIEW)

DATABLOCKSIZE

DATABASE

DATE

DAY

DEC (DECIMAL)

DECIMAL

DEFAULT

DEL (DELETE)

DELETE

DESC

DESCRIPTOR

DIAGNOSTIC

DISTINCT

DOUBLE

DROP

DUAL

DUMP

EACH

EBCDIC

ECHO

ELSE

END

EQ ( = )

ERRORFILES

ERRORTABLES

ESCAPE

ET (END TRANSACTION) EXCEPT

EXCL (EXCLUSIVE)

EXCLUSIVE

EXEC (EXECUTE)

EXECUTE

EXISTS

EXP

A-2

Teradata RDBMS for UNIX SQL Reference
Teradata SQL Keywords

Teradata SQL Keywords

EXPLAIN EXTRACT

FALLBACK FASTEXPORT FIRST FLOAT FOR

FOREIGN FORMAT FREESPACE FROM FULL

GE

GIVE GO

GOTO GRANT GRAPHIC GROUP GT

HASH HASHAMP HASHBAKAMP HASHBUCKET HASHROW HAVING HELP HOUR

IMMEDIATE

IN

INCONSISTENT

INDEX

INDICATOR

INNER

INS (INSERT) INSERT

INT (INTEGER)

INTEGER

INTERSECT

INTO

IS

JOIN

JOURNAL

KEY

LAST

LE ( <= )

( >= )

( > )

Teradata DBS for UNIX SQL Reference

A-3
Teradata SQL Keywords

Teradata SQL Keywords

LEADING

LEFT

LIKE

LN

LOADING

LOCAL

LOCK (LOCKING)

LOCKING

LOG

LOGGING

LOGON

LONG

LT ( < )

MACRO

MAX (MAXIMUM)

MAXIMUM

MCHARACTERS

MIN (MINIMUM)

MINDEX

MINIMUM

MINUS

MINUTE

MLOAD

MOD

MODE

MODIFY

MONITOR

MONRESOURCE

MONSESSION

MONTH

MSUBSTR

MULTISET

NAMED

NATURAL

NE

NO

NOT

NOWAIT

NULL

NULLIF

NULLIFZERO

NUMERIC

OCTET_LENGTH

OF

ON

OPTION

OR

ORDER

OUTER

OVERRIDE

A-4

Teradata RDBMS for UNIX SQL Reference
Teradata SQL Keywords

Teradata SQL Keywords

PASSWORD

PERCENT

PERM (PERMANENT)

PERMANENT

PN

PRECISION

PRIMARY

PRIVATE

PRIVILEGES

PROTECTION

PUBLIC

READ

REAL

REFERENCES

RELEASE

RENAME

REPLACE

RESTART

RESTORE

RET (RETRIEVE)

RETRIEVE

REVALIDATE

REVOKE

RIGHT

RIGHTS

ROLLBACK

ROLLFORWARD

ROW

SECOND

SEL (SELECT)

SELECT

SESSION

SET

SETSESSRATE

SETRESRATE

SHARE

SHOW

SMALLINT

SOME

SPOOL

SQRT

SS (SET SESSION)

STARTUP

STATISTICS

SUBSTR

SUBSTRING

SUM

TABLE

TEMPORARY

Teradata DBS for UNIX SQL Reference

A-5
Teradata SQL Keywords

Teradata SQL Keywords

THEN

TIME

TIMEZONE_HOUR

TIMEZONE_MINUTE

TITLE

TO

TRAILING

TRANSACTION

TRIM

TYPE

UC (UPPERCASE)

UNION

UNIQUE

UPD (UPDATE)

UPDATE

UPPER

UPPERCASE

USER

USING

VALUES

VARBYTE

VARCHAR

VARGRAPHIC

VARYING

VIEW

WAIT

WHEN

WHERE

WITH

WORK

WRITE

YEAR

ZEROIFNULL

A-6

Teradata RDBMS for UNIX SQL Reference
Teradata SQL Versus ANSI SQL

Appendix B

Teradata SQL Versus ANSI SQL

Teradata RDBMS for UNIX SQL Reference
Teradata SQL Versus ANSI SQL

Teradata RDBMS for UNIX SQL Reference
Previous << 1 .. 190 191 192 193 194 195 < 196 > 197 198 199 200 201 202 .. 241 >> Next