APAR status
Closed as program error.
Error description
The job uses Oracle Connector stage with NVarChar column on the output link to read data from a text column in Oracle table. Some of the column values contain NULL characters. The connector truncates these values at the first NULL character. It treats the NULL character as the value terminator. Instead the connector should read the value in its entirety, including any NULL characters in the value.
Local fix
Use VarChar column instead of NVarChar column on the output link, and do not set the Extended column attribute to Unicode. The character set encoding of the value will be determined by the NLS_LANG setting.
Problem summary
**************************************************************** USERS AFFECTED: The users of Oracle Connector who extract text data will NULL values using DataStage NVarChar columns on the output link. **************************************************************** PROBLEM DESCRIPTION: When extracting values from character columns in the Oracle table (for example VARCHAR2, NVARCHAR2, etc) and the corresponding columns on the output link were of NVarChar type or VarChar type with Extended attribute set to Unicode, the connector would not preserve NULL characters in the text values but would treat the NULL characters as value terminators and would therefore truncate the value at those NULL character boundaries. **************************************************************** RECOMMENDATION: Install Connector Rollup Patch 2 (CCRP2). This change is included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
The code was fixed to preserve NULL characters in the extracted column values.
Temporary fix
Comments
APAR Information
APAR number
JR34039
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-08-18
Closed date
2009-09-28
Last modified date
2009-12-15
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
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R810 PSN
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":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 December 2009