DB2 Server for VM: System Administration

Step 5: Update the SYSTEM.SYSCCSIDS Catalog Table

You must add a row to the SYSTEM.SYSCCSIDS catalog table to identify the CCSID values to be associated with your new character set. You could issue the following statement to update SYSTEM.SYSCCSIDS for the character set defined for this example:

  INSERT INTO SYSTEM.SYSCCSIDS (CCSID,SUBTYPE,DBCSID,SBCSID,CHARNAME)
    VALUES (57344,
            'S',
            0,
            0,
            'PORTUGUESE')

If you are defining your own CCSID (that is, one that is not obtained from the Character Data Representation Architecture (CDRA)) registry, you must use a value that is within the range of 57 344 to 61 439 (X'E000' to X'EFFF'). Values within this range are reserved for user-defined CCSIDs. Ensure that the value you specify does not already exist: the CCSID column cannot contain duplicate information. Also keep the following in mind:

• If the character set that you are defining uses conversion tables that are provided by the CDRA registry, use the CCSIDs that they indicate.
• The SUBTYPE column identifies the subtype of the CCSID. In this example, the value is 'S' for SBCS.
• The SBCSID column and the DBCSID column specify the SBCS and the DBCS components for a mixed CCSID. Because the CCSID in this example is SBCS, the value for both of these columns is 0.
• The value that you specify for the CHARNAME column must be the same as the value that you specified in the NAME column of the SYSTEM.SYSCHARSETS catalog table.

For examples of statements that insert rows into the SYSTEM.SYSCCSIDS catalog table, review the ARITPOP MACRO that is supplied with the database manager.