Following are issues pertaining to DirectConnect for DB2 UDB.
For code page conversions involving extended character sets, configure a DRDA Data Source Name (DSN) to match the code page of the DirectConnect client application by setting its IANAAppCodePage property to the client's code page.
DirectConnect for DB2 UDB supports code page translation for one code page for each DirectConnect for DB2 UDB service. To configure code page translation, add the following setting to the ODBC DSN configurations corresponding to your DirectConnect for DB2 UDB services:
IANAAppCodePage – set this to the code page of the clients connecting to the DirectConnect for DB2 UDB service using this DSN entry. Unless you are using characters in the extended character set of the code page, a common code page (for example, 1252) is recommended.
For additional information, refer to the Enterprise Connect Data Access Options User’s Guide for Access Services, in Chapter 2, “Configuring the Access Service Library for DirectConnect.”
For space padding, you need to verify that a special string key, the WorkArounds2=131072 string value, is defined in the Windows registry. This allows the driver to pad DB2 char for bit data fields with spaces instead of binary zeros. Repeat the process for each DB2 UDB DSN that you are going to use with DirectConnect. See the Enterprise Connect Data Access Installation Guide for Microsoft Windows, in Chapter 5, in the section titled, “Add the WorkArounds2 String Key to pad DB2 character data.”
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
