Following are issues pertaining to DirectConnect for DB2 UDB.
For code page conversions involving extended character sets, refer to the Enterprise Connect Data Access Options User’s Guide for Access Services, Chapter 2, “Configuring the Access Service Library for DirectConnect,” the section titled, “Code page translation for ODBC-based products.”
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 Data Source Name (DSN) that you are going to use with DirectConnect. See the Enterprise Connect Data Access Installation Guide for Microsoft Windows, Chapter 5, the section titled, “Add the WorkArounds2 string key to pad DB2 character data.”
