Appendix C Restricted Words - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

Restricted words have special meaning for use in Teradata PT. They must not be used in Teradata PT job scripts as identifiers for column names, attributes, or other values.

Following is a list of the Teradata PT restricted words. The words are shown in uppercase type for simplicity, but are restricted regardless of case.

Note: As of this release, Teradata PT reserved keywords are now called Teradata PT restricted words.

For a full list of Teradata reserved, non reserved, and future words SQL Fundamentals (B035-1141).

 

ACCOUNT
ALL
ALLOW
AND
ANSIDATE
APPLY
ARRAY
AS
ATTR
ATTRIBUTES

BIGINT
BLOB
BY
BYTE
BYTEINT

CASE
CAST
CATEGORY
CHAR
CHARACTER
CHARACTERS
CHARS
CHECK
CHECKPOINT
CLOB
COMMAND
COMPONENT
CONSUMER

DATABASE
DATACONNECTOR
DATAGENERATOR
DATE
DATETIME
DAY
DBMS
DDL
DEBUG
DEC

DECIMAL
DEFAULT
DEFERRED
DEFINE
DELETE
DELIM
DELIMITER
DELTATIME
DESCRIPTION
DIRECTORY
DISABLE
DISALLOW
DISCARD
DUPLICATE

ELSE
ENABLE
END
EXECUTE
EXPORT
EXTERNAL
EXTRA

FALSE
FASTEXPORT
FASTLOAD
FILE
FILTER
FLOAT
FOR
FORMATIN
FORMATOUT
FROM

GENERIC
GRAPHIC

HOUR

ID
IF
IGNORE
INCLUDE

INFO
INMOD
INPUT
INSERT
INSERTER
INSTANCE
INT
INTDATE
INTEGER
INTERFACE
INTERVAL
INTO
IS

JOB

JSON

KEEP

LANGUAGE
LATENCY
LENGTH
LIBRARY
LOAD
LOCAL
LONG
LOG
LOGGER
LOGON
LOGREPORT

MACROCHARSET
MARK
MAX
MAXIMUM
MESSAGE
METADATA
MIN
MINUTE
MINUTES
MISSING

MODE
MONTH
MSGCATALOG
MSGNUMBER
MSGTEXT
MULTILOAD
MULTIPHASE
NAME
NODE
NODEBUG
NODENAME
NOINFO
NOT
NOTRACE
NULL
NULLIF
NUMBER
NUMERIC
ODBC
OFF
OFFSET
ON
OPERATOR
OR
OS
OTHER
OUTMOD
OUTPUT

PARALLEL
PASSWORD
PATH
PERIOD
PROCESSID
PRODUCER
PXOPER

REMOTE
RESTARTABLE
ROWS

SCHEMA
SCHEMAMAPPER
SEC
SECOND
SECONDS
SELECT
SELECTOR
SEQUENTIAL
SERIALIZE
SET
SMALLINT
SOURCE
STANDALONE
STEP
STREAM

SUPPORT
SYSTEM

TABLE
TASKID
TASKNAME
YEAR
TERADATA
THEN
TIME
TIMESTAMP
TO
TRACE
TRUE
TYPE

UNION
UNKNOWN
UPDATE
USE
USER
USING

VARBYTE
VARCHAR
VARDATE
VARGRAPHIC
VARYING
VERSION
VIA
VIEW

YEAR


WHEN
WHERE
WITH
WORKING

XML
XSMOD

ZONE