16.20 - Activating Collation Codes - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine International Character Set Support

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
User Guide
featnum
B035-1125-162K

To activate the collation codes you inserted using the DBC.CollationsV view, perform the following procedure:

  1. Execute the CollInstallMulti macro, as follows:
    EXECUTE CollInstallMulti (‘collation_name’);

    where collation_name is the CollName you specified in your BTEQ job.

  2. Restart the Teradata Database (enter the restart tpa command from the Database Window of the system console) to install the codes as the new default collation sequence.

From now on, the collation sequence you just installed is the default when the COLLATION option is set to MULTINATIONAL.