Checking Reserved Words - Teradata Database

Teradata Database Node Software Migration Guide

Product
Teradata Database
Release Number
15.10
Published
November 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
heq1467819788761.ditamap
dita:ditavalPath
5942_Migrating_1510.ditaval.ditaval
dita:id
B035-5942
lifecycle
previous
Product Category
Software
One of the pre_upgrade_prep.pl script checks is for reserved word usage in the pre-upgraded system when targeting an upgrade to the new release. However, the reserved words list can be checked without executing the pre_upgrade_prep.pl script, by compiling and installing the SQLRestrictedWords_TBF UDF using PUTTools.
  1. Enter the command: /opt/Teradata/PUTTools/TDrelease/IUMB_scripts/install_udfs.pl [dbs_version] system/dbc,dbc_password

    where TDrelease is td15.10.xx.xx, and dbs_version is optional and specifies the target release of Teradata Database. If dbs_version is not included, the release is extracted from TDrelease.