Show TOC

Example documentationMAPCHARSETS

 

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'