Reserved Words | Teradata Vantage - Reserved Words - Analytics Database - Teradata Vantage

Teradata Vantage™ - Analytics Database Node Software Migration Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
ydx1628095838609.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-5942
Product Category
Teradata Vantage

Reserved words are used as keywords by Analytics Database or ANSI/ISO SQL. They cannot be used as identifiers to name database objects, such as databases, tables, columns, or stored procedures. They also must not be used as macro or stored procedure parameters or local variables, host variables, or correlation names.

Each new release of Analytics Database adds new reserved words. For every release, the Teradata Vantage™ - Analytics Database Release Summary, B035-1098 includes a list of the new reserved words. Teradata provides a view and table function that you can use to generate a complete list of reserved, nonreserved, and future reserved words. For more information, see Teradata Vantage™ - SQL Fundamentals, B035-1141.

The pre-migration script runs the check_reserved_words.bteq and check_reserved_words_tpt.bteq scripts to check for reserved words used by the database and by the Teradata Parallel Transporter (TPT) load utility. If you use TPT, you should check the results in reservedwords_tpt.rpt.