17.10 - Activating Collation Codes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

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.