ALTER CATALOG

The ALTER CATALOG statement establishes the character set for character columns of the tables defined within the current dictionary. The character set is used to correctly sort additional national characters for the named language. It is also a CA IDMS extension of the SQL standard.
idmscu
Contents
The ALTER CATALOG statement establishes the character set for character columns of the tables defined within the current dictionary. The character set is used to correctly sort additional national characters for the named language. It is also a CA IDMS extension of the SQL standard.
Authorization
To issue an ALTER CATALOG statement, you must have DBADMIN authority, and ALTER authority for the SYSTEM schema.
This statement must be executed immediately following the execution of the TABLEDDL file that records the definition of the catalog tables themselves. The statement must precede the definition of any user SQL tables in that catalog.
Syntax
  ►►─── ALTER CATALOG DEFAULT CHARACTER SET 
alternate-character-set-name
 ───────►◄  
Parameters
  • alternate-character-set-name
    Identifies the character set whose collating scheme is to be used for the CHAR and VARCHAR columns defined in the catalog. Currently-supported values for
    alternate-character-set-name
    are DENMARK, FINLAND, NORWAY, and SWEDEN.
Usage
The ALTER CATALOG DEFAULT CHARACTER SET statement changes the collating sequence for all CHAR and VARCHAR columns defined in user tables in the dictionary, including non-SQL defined tables. It does not affect columns in the SYSTEM tables.
Swedish and Finnish
The additional national characters, the uppercase forms of which are represented by the symbols
$, #,
and
&theta.
, sort at the end of the standard alphabet. The accented
E
and
U
sort the same as their unaccented equivalents, and are returned to application programs as their unaccented equivalents.
Norwegian and Danish
The additional national characters, the uppercase form of which is represented by the symbols
#, &theta.
, and
$
, sort at the end of the standard alphabet. The accented
U
sort in the same sequence as its unaccented equivalent and are returned to application programs as an unaccented U.
Example
The following statement causes the data values of all CHAR and VARCHAR columns to collate according to the conventions of the Finnish alphabet.
alter catalog default character set FINLAND