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

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
Configuration
Installation
featnum
B035-5942-170K
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.