Fixing Reserved Words - Teradata Database

Teradata Database Node Software Migration Guide

Product
Teradata Database
Release Number
16.10
Published
November 30, 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
bkn1504122461303.ditamap
dita:ditavalPath
5942_Migrating_1610.ditaval
dita:id
B035-5942
lifecycle
previous
Product Category
Software
Whenever words in the databases and applications are the same as any on the reserved words list, those words must be changed or placed in quotes before moving to a new version of the Teradata Database.
  1. View the output report file reservedwords.rpt for discovered reserved words.
  2. Correct the found words. For example:

    Reserved word: FUNCTION found in the database or application.

    Use one of the following methods to correct the problem:
    • Change the column name to THEFUNCTION or FUNCTION_
    • Replace every occurrence of FUNCTION with "FUNCTION"
    The Reserved Words script may not catch all instances of the reserved words because Client databases are not checked and the names can be obscured through aliases and embedded SQL statements.