Procedure - Teradata Vantage - Database Engine 20

To change the Teradata standard MULTINATIONAL collation to the standard Swedish or Norwegian collation, perform the following procedure:

1. Log on to a BTEQ session as user SYSADMIN or user DBC.
2. Execute the DBC.CollInstallMulti macro, specifying the desired standard as the CollationName parameter for the macro.

   For example, any of the following:

   EXECUTE DBC.CollInstallMulti (‘NORWEGIAN_STANDARD’);
   EXECUTE DBC.CollInstallMulti (‘SWEDISH_STANDARD’);
   EXECUTE DBC.CollInstallMulti (‘KANJI5026_STANDARD’);
   EXECUTE DBC.CollInstallMulti (‘KANJI5035_STANDARD’);
   EXECUTE DBC.CollInstallMulti (‘KATAKANA_STANDARD’);

3. On the Command Line of the Database Window of the system console, enter the restart tpa command to restart the database.

   During restart processing, the database displays a message indicating whether the specified collation was installed.