Fix Reserved Words | Teradata Vantage - 17.00 - 17.05 - Fixing Reserved Words - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Node Software Migration Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Administration
Configuration
Installation
Publication ID
B035-5942-170K
Language
English (United States)
Eliminate reserved words from your database prior to migration or upgrade by either changing them to something other than reserved words or enclosing them in quotation marks where possible.
  • To eliminate the reserved words, do one of the following:
    • Change the word to something else. For example, change reserved word FUNCTION to THEFUNCTION.
    • For some uses, such as in column names, you can enclose the reserved word in quotes to prevent the database from interpreting it as a reserved word. For example, change reserved word FUNCTION to "FUNCTION".
    The Reserved Words script may not find all instances of the reserved words, because Client databases are not checked and the names can be obscured through aliases and embedded SQL statements.