APAR status
Closed as program error.
Error description
When retrieving table data by means of a query using WTX 64bit on a UNIX platform with the ODBC adapter / ODBC drivers, the final column may be missing. The issue seems to only occur with SQL Server UNICODE databases when the final column is defined as an nchar or nvarchar datatype. Using the IANAAPPCODE feature of the ODBC drivers in the ODBC.ini does not resolve the issue, and in fact prevents initial connection.
Local fix
WTXCQ - WTX00040295 PB / PB Circumvention: None
Problem summary
Users Affected: WebSphere Transformation Extender 64 bit ODBC adapter users that are selecting Unicode data from a nvarchar or nchar column in a SQL Server database. Problem Description: Unicode values are not properly retrieved from SQL Server nchar and nvarchar columns. Platforms Affected: All
Problem conclusion
The 64-bit ODBC Adapter can properly process UNICODE-based nchar and nvarchar types from a SQL Server database. Before this fix, the data would get truncated. Delivered in: 8.3.0.5, 8.4.0.2
Temporary fix
Comments
APAR Information
APAR number
PM61227
Reported component name
WEBSPHERE LAUNC
Reported component ID
5724M4011
Reported release
830
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-03-27
Closed date
2012-05-24
Last modified date
2014-05-12
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
WEBSPHERE LAUNC
Fixed component ID
5724M4011
Applicable component levels
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.3","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
12 May 2014