Adding the WorkArounds2 String Key to Pad DB2 Character Data
For DB2 only, verify that a special string key is defined in the Windows
Registry to allow the driver to pad DB2 char for bit data fields with spaces, instead of
binary zeros.
Warning! Be cautious when using regedit.exe or regedt32.exe, as
you may disable your machine. Make a backup of your registry before making any
changes.
Use the Windows Registry editor (regedit.exe or
regedt32.exe); open one of these sections in the
Registry:
For User DSN: HKEY_CURRENT_USER \SOFTWARE\ODBC\ODBC.INI
For System DSN:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI
In this section, locate an entry for the DSN you created.
If the WorkArounds2 string key does not exist, select Edit > New > String Value from the Edit menu, to add a String Value
named WorkArounds2 (case-sensitive). After it has been
created, modify the new entity and enter a value of 131072.
Click OK.
Repeat this process for each DB2 UDB DSN you are using with ECDA.