DB2 Version 9.7 for Linux, UNIX, and Windows

alt_collate - Alternate collating sequence configuration parameter

This parameter specifies the collating sequence that is to be used for Unicode tables in a non-Unicode database.

Configuration type

Database

Applies to

Database server with local and remote clients
Client
Database server with local clients
Partitioned database server with local and remote clients

Parameter type

Configurable

Default [range]

Null [IDENTITY_16BIT ]

Until this parameter is set, Unicode tables and routines cannot be created in a non-Unicode database. Once set, this parameter cannot be changed or reset.

This parameter cannot be set for Unicode databases.