Reference Manual

Back Next

ICUALIAS Statement

The ICUALIAS statement adds or deletes an alias that points to a custom ICU code page.

All

ICUCNVPROPERTY, ICUCONVERTER, and ICUDATADIR

ICUALIAS=(CPN
         ,command
        [,alias]
)

CPN: Required. The code page slot number to which to add an alias, or from which to delete an alias. Valid values are from 301 through 340.

To identify available code page slots, see the ICUCHECK report.
command: Required. The command to apply to the specified code page slot number. Enter one of the following options:

ADD.
Adds the specified alias to point to the specified code page slot number.

For example, to add an alias of CP930 to point to CPN 302, include the following statement:

ICUALIAS=(302,ADD,CP930)

This command causes DB2 columns with CCSID 930 to use this custom ICU code page.

DELETE.
Deletes the specified alias from the specified code page slot number.

For example, to delete the CP930 alias from CPN 206, include the following statement:

ICUALIAS=(206,DELETE,CP930)

DELETEALL.
Deletes all aliases from the specified code page slot number.

The DELETEALL command uses the following parameters only:

ICUALIAS=(CPN,DELETEALL)

For example, to delete all defined aliases from CPN 206, include the following statement:

ICUALIAS=(206,DELETEALL)
alias: Required if the second parameter is ADD or DELETE. An alternative name for the code page, which can be used to find a code page. Aliases for DB2 CCSIDs begin with
cp
. Maximum length is 30 characters.