To activate the collation codes you inserted using the DBC.CollationsV view, perform the following procedure:
- Execute the CollInstallMulti macro, as follows:
EXECUTE CollInstallMulti (‘collation_name’);
where collation_name is the CollName you specified in your BTEQ job.
- 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.