Microsoft KB Archive/925405

= A software update is available that lets you create custom code pages for use in applications that use the Transaction Integrator feature and the Data Integration feature of Host Integration Server 2004 =

Article ID: 925405

Article Last Modified on 12/4/2007

-

APPLIES TO


 * Microsoft Host Integration Server 2004 Standard Edition
 * Microsoft Host Integration Server 2004 Enterprise Edition

-



INTRODUCTION
This article discusses a software update that lets you create custom code pages. You can use these custom code pages in applications that use the Transaction Integrator (TI) feature and the Data Integration feature that are included in Microsoft Host Integration Server 2004.

Note The Data Integration feature includes the Microsoft OLE DB Provider for DB2. Additionally, the Data Integration feature includes the Microsoft OLE DB Provider for AS/400 and Virtual Storage Access Method (VSAM).



Software update information
After you apply this update, you can create custom code pages by modifying existing code pages to include non-standard character conversions. The CustomCodepage.exe utility that is included with this software update provides a graphical user interface (GUI) to create custom code pages.

A supported feature that modifies the default behavior of the product is now available from Microsoft, but it is only intended to modify the behavior that this article describes. Apply it only to systems that specifically require it. This feature may receive additional testing. Therefore, if you are not severely affected by the lack of this feature, we recommend that you wait for the next Microsoft Host Integration Server 2004 service pack that contains this feature.

To obtain this feature immediately, download the feature by following the instructions later in this article or contact Microsoft Product Support Services. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

File information
The English version of this update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

How to use the CustomCodepage.exe utility
To create custom code pages by using the CustomCodepage.exe utility, follow these steps:  Run the CustomCodepage.exe utility. The CustomCodepage.exe utility is located in the folder that you selected when you applied this software update. To create a custom code page, click Add New Entry. In the Custom CCSID box, type a value for the Character Code Set Identifier (CCSID). This value uniquely identifies the custom code page.

Host Integration Server includes the Custom CCSID value in the PC codepage connection string parameter when you use the custom code page in a Universal Data Link (UDL) file. When you use the OLE DB Provider for DB2 to connect to a computer that is running IBM DB2, Host Integration Server uses the UDL file for the connection. In TI Manager, the custom code page will appear in the Code page list on the Locale tab of the Remote Environment settings. In the Custom name box, type the name that you want to use for the custom code page. In the PC codepage list and in the Host CCSID code page list, select the code pages that you want to modify. If you want the custom code page to have one-to-one character mappings, click to select the Conversion is 1:1 check box. If the code pages that you selected in step 5 do not contain one-to-one mappings, you receive the following error message:

Duplicate Mapping

A duplicate character character code exists in the conversion table.

Duplicate characters are not allowed when you use one-to-one character conversions. Update one of the duplicate characters.

 Click OK. The PC to Host conversion table appears. In this table, you can create custom character mappings. Host Integration Server uses these custom character mappings when you send Windows data to a host computer such as a computer that is running IBM DB2.

For example, when you use host code page EBCDIC – U.S./Canada (37), the PC codepage ANSI – Latin I (1252) code page maps character 0x30 to character 0xF0. If you want to change this mapping, change the value in row 3, column 0, of the PC to Host conversion table. Change the value from F0 to the value for the character to which you want Host Integration Server to convert the F0 character.</li> Click Direction. The Host to PC conversion table appears. In this table, you can create custom character mappings. Host Integration Server uses these custom character mappings when you receive data from a Host computer.

For example, when you use PC codepage ANSI – Latin I (1252) code page, the EBCDIC – U.S./Canada (37) code page maps character 0xF0 to character 0x30. If you want to change this mapping, change the value in row F, column 0, of the Host to PC conversion table. Change the value from 30 to the value for the character to which you want Host Integration Server to convert the F0 character.</li> In the conversion table, select the character mapping that you want to change, and then click Edit. The Edit conversion table dialog box appears.</li> After you have made all the character mapping changes that you want to make, click OK to save the changes and to close the Edit conversion table dialog box.

The custom code page changes are saved in a file that is named Custom.tbl. This file is located in the %SNAROOT% folder.</li></ol>

You can use the custom code page by referencing the Custom CCSID that you specified when you created the custom code page. To view the available custom code pages, run the CustomCodepage.exe utility. The following table lists the custom code pages as they appear in the CustomCodepage dialog box.

<div class="references_section">