APAR status
Closed as program error.
Error description
When using the MS SQL Server ODBC driver, SQLSrv32.dll, the output extracted from the database does not match the Unicode data that was stored in an nchar field. The DataDirect SQL Server ODBC driver produces the expected output.
Local fix
WTXCQ - WTX00039821 CH / CH Circumvention: None
Problem summary
Users Affected: WebSphere Transformation ODBC Adapter users that are employing the native Microsoft SQL Server driver. Users of the IBM Branded SQL Server driver are not affected. Problem Description: The MS SQL Server ODBC driver cannot properly retrieve UNICODE data from an nchar field. Platforms Affected: Windows
Problem conclusion
The WTX ODBC Adapter now processes Unicode data for the native Microsoft SQL Server ODBC driver in the same way as it currently and successfully does for the IBM branded SQL Server driver. Delivered in: 8.1.0.6, 8.2.0.6, 8.3.0.5, 8.4.0.1
Temporary fix
Comments
APAR Information
APAR number
PM56033
Reported component name
WSTX
Reported component ID
5724M4000
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-01-16
Closed date
2012-02-22
Last modified date
2013-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WSTX
Fixed component ID
5724M4000
Applicable component levels
R810 PSY
UP
R820 PSY
UP
R830 PSY
UP
R840 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSD8","label":"IBM Transformation Extender"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
01 February 2013