Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/925405

From BetaArchive Wiki

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).

MORE INFORMATION

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:

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.

File name File version File size Date Time Platform
Convertprimex.dll 6.0.2086.0 75,264 30-Apr-2007 23:24 x86
Customcodepage.exe 6.0.2086.0 200,704 30-Apr-2007 23:20 x86
Db2oledb.dll 6.0.2086.0 500,064 01-May-2007 00:19 x86
Db2oledb.h Not Applicable 24,660 30-Apr-2007 23:24 Not Applicable
Dcgen.dll 6.0.2086.0 99,840 30-Apr-2007 23:24 x86
Ddmstr.dll 6.0.2086.0 53,592 01-May-2007 00:19 x86
Dpl1.dll 6.0.2086.0 20,480 30-Apr-2007 23:24 x86
Drdaresync.exe 6.0.2086.0 346,976 01-May-2007 00:19 x86
Hipobjects.dll 6.0.2086.0 1,060,352 30-Apr-2007 23:24 x86
Microsoft.hostintegration.dataaccesslibrary.dll 6.0.2086.0 95,656 01-May-2007 00:14 x86
Microsoft.hostintegration.dataaccesstool.exe 6.0.2086.0 2,712,992 01-May-2007 00:14 x86
Microsoft.hostintegration.msdb2client.dll 6.0.2086.0 124,312 01-May-2007 00:14 x86
Mseidb2c.dll 6.0.2086.0 81,248 01-May-2007 00:19 x86
Mseidb2d.dll 6.0.2086.0 444,768 01-May-2007 00:19 x86
Mseidrda.dll 6.0.2086.0 708,448 01-May-2007 00:20 x86
Snanls.dll 6.0.2086.0 77,824 30-Apr-2007 23:21 x86
Sysctblj.exe 6.0.2086.0 30,720 30-Apr-2007 23:21 x86
Sysctblk.exe 6.0.2086.0 29,696 30-Apr-2007 23:21 x86
Sysctbls.exe 6.0.2086.0 29,696 30-Apr-2007 23:21 x86
Sysctblt.exe 6.0.2086.0 29,696 30-Apr-2007 23:21 x86
Tagen.dll 6.0.2086.0 96,256 30-Apr-2007 23:24 x86
Tranlu62.dll 6.0.2086.0 53,760 30-Apr-2007 23:24 x86
Trantcp.dll 6.0.2086.0 104,960 30-Apr-2007 23:24 x86
Trnsdt.dll 6.0.2086.0 10,752 30-Apr-2007 23:21 x86
Trnsdtj.dll 6.0.2086.0 7,680 30-Apr-2007 23:21 x86
Trnsdtk.dll 6.0.2086.0 6,656 30-Apr-2007 23:21 x86
Trnsdts.dll 6.0.2086.0 6,144 30-Apr-2007 23:21 x86
Trnsdtt.dll 6.0.2086.0 6,656 30-Apr-2007 23:21 x86

How to use the CustomCodepage.exe utility

To create custom code pages by using the CustomCodepage.exe utility, follow these steps:

  1. Run the CustomCodepage.exe utility. The CustomCodepage.exe utility is located in the folder that you selected when you applied this software update.
  2. To create a custom code page, click Add New Entry.
  3. 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.
  4. In the Custom name box, type the name that you want to use for the custom code page.
  5. In the PC codepage list and in the Host CCSID code page list, select the code pages that you want to modify.
  6. 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.

  7. 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.
  8. 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.
  9. In the conversion table, select the character mapping that you want to change, and then click Edit. The Edit conversion table dialog box appears.
  10. 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.

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.

Custom code page name Custom code page ID
Custom_CodePage_1 99119
Custom_CodePage_2 99120


REFERENCES

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates



Additional query words: custom code page NLS

Keywords: kbfix kbqfe kbpubtypekc kbhotfixserver KB925405