Defining additional character conversions

You must define valid conversion definitions for source and target CCSIDs for Db2 to use when performing character conversions. Many of these definitions already exist in SYSIBM.SYSSTRINGS and in the conversion image that you set up for z/OS® Unicode Services. However, you might need to add more.

Procedure

To define character conversions:

Add the definition to one of the following places:
  • The Db2 catalog table SYSIBM.SYSSTRINGS

    Insert a row with the appropriate definition. The definitions in this table take precedence over the definitions in z/OS Unicode Services with several exceptions, which are described after this list. Rows that you insert have a value of 'N' in the IBM®REQD column and take precedence over the IBM-supplied rows.

  • z/OS Unicode Services

    You can either load a new conversion image that contains the conversion definitions or add a single conversion definition to the existing image. For instructions on how to load or alter conversion images, see Setting up z/OS Unicode Services for Db2 for z/OS.