17.20 - Definition of the CollInstallMulti Macro - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support

Advanced SQL Engine
Teradata Database
Release Number
June 2022
Last Update
Content Type
User Guide
Publication ID
English (United States)

The CollInstallMulti macro takes the codes you load into the DBC.CollationsV view and inserts them into the underlying system table as the new default collation sequence.

The :CollationName parameter you submit to the macro must match the CollName value you specified for DBC.CollationsV.

During this process, CollInstallMulti performs the following actions.

  1. Verifies that the value of :CollationName is not MULTINATIONAL.
  2. Verifies that :CollationName is found in the CollName column of DBC.CollationTbl.
  3. Deletes the row where CollName is MULTINATIONAL.
  4. Inserts (through DBC.CollationsV) a row with the following values:
    • The string MULTINATIONAL in CollName
    • The letter Y in CollInstall
    • The codes for CollEqvClass, CollOrderCS, and CollOrderUC, which are selected from the row you loaded (where CollName should be equal to :CollationName).

The SQL code for CollInstallMulti is as follows:

   REPLACE MACRO CollInstallMulti (CollationName CHAR(30)) AS
   ( ABORT 'Argument cannot be MULTINATIONAL collation'
   WHERE :CollationName = 'MULTINATIONAL';
   ABORT 'Specified collation has not been defined'
   WHERE :CollationName NOT IN
   ( SELECT CollName
   FROM DBC.CollationsV );
   DELETE FROM DBC.CollationsV
   INSERT INTO DBC.CollationsV
   CollOrderCS, CollOrderUC
   FROM DBC.CollationsV
   WHERE CollName = :CollationName; );