APAR status
Closed as program error.
Error description
The customer has ';' (semicolon) in "Description" field on [Source] tab on CFF stage. And they cannot get the correct data for the column which Description has semicolon when viewing data. Actually, they have a column which is prepared as spare. 1 byte space should be set to the column. And there is a semicolon in "Description" of this column like "CHAR(69);". The data of this column should be 1 byte space, but unexpected data is set at viewing data.
Local fix
Our customer already know that it is possible to avoid the issue by removing the semicolon. But they are requesting to be provided a patch for this issue. This fix is included in 8.0.1 fixpack 3
Problem summary
**************************************************************** USERS AFFECTED: View Data on CFF stage produces incorrect data **************************************************************** PROBLEM DESCRIPTION: On a CFF stage, if the column definitions contains semicolons in the description field they will cause the view data to display incorrect data. **************************************************************** RECOMMENDATION: Install the patch for this APAR JR32520. This change is included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
The view data parser is interpreting the semicolon as a separator and therefore gets the wrong metadata for the stage. Fix the information sent to the parser. The fix is a clientside fix to the logic when constructing stage info.
Temporary fix
Comments
APAR Information
APAR number
JR32520
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
753
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-03-26
Closed date
2009-04-22
Last modified date
2010-12-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CLIENT
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R753 PSY
UP
R801 PSY
UP
R810 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 December 2010