Example documentationMAPCHARSETS Locate this document in the navigation structure

 

Use of the system table DOMAIN.MAPCHARSETS

Prerequisites

You can use the DEMODB demo database. Start the Database Studio and log onto the demo database DEMODB: Logging On to a Database.

Activities

You can use Database Studio to enter and execute SQL statements. More information: Working with SQL Statements: Overview

Note the General Instructions for formulating SQL statements.

You can use the system table MAPCHARSETS 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 D6in the mapchar set DEFAULTMAP

    SELECT map_code, map_character

    FROM DOMAIN.MAPCHARSETS

    WHERE mapcharsetname = 'DEFAULTMAP'

    AND intern = X'D6'