Following are issues pertaining to ECDA Option for ODBC.
(For DataDirect drivers only) 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 ECDA Option for ODBC. 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.”
CLOB data is limited to 32K. BLOB datatype is not supported.
Workaround: Use DirectConnect for z/OS Option.
