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.
-
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.