APAR status
Closed as program error.
Error description
The :bind([T], variable) is bound as SQL_NUMERIC instead of text in the SQLBindParameter which causes an "[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005" error message.
Local fix
WTXCQ - WTX00037465 BD / BD Circumvention: None
Problem summary
Users Affected: WebSphere Transformation Extender customers using DB2 adapter Problem Description: The DB2 adapter's bind command does not work correctly for text data. Platforms Affected: ALL
Problem conclusion
The DB2 adapter properly binds text fields when using the adapter's "bind" command. Before this fix, the text-based bind command, ":bind[TEXT]", would bind data as numeric versus text. Delivered in: 8.1.0.6, 8.2.0.6, 8.3.0.5
Temporary fix
Comments
APAR Information
APAR number
PM39220
Reported component name
WEBSPHERE LAUNC
Reported component ID
5724M4011
Reported release
820
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-05-16
Closed date
2011-06-10
Last modified date
2011-10-14
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
R810 PSY
UP
R820 PSY
UP
R830 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.2","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
14 October 2011