Restricted Words | Teradata Parallel Transporter - Overview - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2023-11-29
dita:mapPath
abr1608578396711.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
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.
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, see Teradata Vantage™ - 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

LOG

LOGGER

LOGON

LOGREPORT

LONG

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

TERADATA

THEN

TIME

TIMESTAMP

TO

TRACE

TRUE

TYPE

UNION

UNKNOWN

UPDATE

USE

USER

USING

VARBYTE

VARCHAR

VARDATE

VARGRAPHIC

VARYING

VERSION

VIA

VIEW

WHEN

WHERE

WITH

WORKING

XML

XSMOD

YEAR

ZONE