3009 - IBM Db2 for i: Customizing Character Data

Syniti DR/DBMoto locates and reads the CCSID configuration file ccsid_properties.xml
in the <SynitiDR_DBMoto_install_path>\CodePages directory. To customize character data, it is possible to create a .ovr file for a specific CCSID, then edit ccsid_properties.xml to add the mapping.

Let's look at a sample ccsid_properties.xml file, which contains common scenarios:

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<ccsid_properties xmlns="http://www.hitsw.com">
<property ccsid="1114" mapToCcsid="950"/>
<property ccsid="1252" mappingFileName="1252.bin"/>
<property ccsid="933" type="MULTI" mappingFileName="933.bin" overrideFileName="933.ovr"/>
<property ccsid="951" type="MULTI NO SHIFT" derivedFromCcsid="950" overrideFileName="951.ovr" />
</ccsid_properties>

<property ccsid="1114" mapToCcsid="950"/>
Maps 1114 to 950, i.e. whenever 1114 is referenced, CodePage will substitute it with 950
(CodePage also has an internal list)

<property ccsid="1252" mappingFileName="1252.bin"/>
Tells CodePage to use the specified mapping file 1252.bin for 1252

<property ccsid="933" type="MULTI" mappingFileName="933.bin" overrideFileName="933.ovr"/>
Tells CodePage to use 933.bin and 933.ovr, type is used to specify the type of table (MULTI
means not single)

<property ccsid="951" type="MULTI NO SHIFT" derivedFromCcsid="950" overrideFileName="951.ovr" />
Creates a new CCSID derived from an existing CCSID (uses the mapping of an
existing CCSID) and then applies overrides to it.
Note that the type here is MULTI NO SHIFT - the 950 conversion does not use shift in and shift out.

If type is not specified, CodePage will try to figure it out using an internal list.

Override files have an .ovr extension and need to be copied into the same directory as the ccsid_properties.xml file:
C:\Program Files\HiT Software\DBMoto V9\CodePages.

The .ovr file is a text file that contains mapping overrides.

Example file content:
! comment - commenting lines starts with !
! each mapping has 3 tokens: <native value> <operator> <unicode value>
! 1) the operator = or , means 2-way native to unicode to native mapping
! 2) the operator > means 1-way native to unicode mapping
! 3) the operator < means 1-way unicode to native mapping (unicode is always on the right hand side)

Example CCSID Overrides:
05 = 5A (equivalent to 05 , 5A)
A7 > 100A
2A00 < 128A

Note that the Override CCSID connection property has been deprecated and that the way to override codepage conversion is now by the use of the xml file. In V 9.7.1 and above, values from the Override CCSID field are placed in Extended Properties, but have no effect. Please delete the property value and create the override using the method described in this article.