16.10 - Activating Collation Codes - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K

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.