MAPCHARSETS

Prerequisites

Log on to the database instance DEMODB.

Examples

You can use the system tableMAPCHARSETS to determine the following database information, among other things:

·        Names of all mapchar sets

SELECT DISTINCT mapcharsetname
  FROM DOMAIN.MAPCHARSETS

·        Conversion of the hexadecimal value D6 in the mapchar set DEFAULT MAP

SELECT map_code, map_character
  FROM DOMAIN.MAPCHARSETS
    WHERE mapcharsetname = 'DEFAULTMAP'
      AND intern = X'D6'