16.20 - Fixing Reserved Words - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Node Software Migration Guide

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
Configuration
Installation
featnum
B035-5942-162K
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.