A fix is available
APAR status
Closed as fixed if next.
Error description
Server job developer guide insists that NLS map works for columns of SQL type Char and VarChar as well as NChar and NVarChar column. But Oracle Connector in a server job does not function like this, NLS map works only when the SQL type is set to NChar or NVarChar.
Local fix
Use NChar or NVarChar instead of Char or VarChar in columns tab of Oracle Connector stage.
Problem summary
Oracle Connector Chars on SE canvas requires NLS_LANG be set to UTF-8 because it expects only utf-8 characters. Also it is not allocating enough bytes for the Char/Varchar columns in some cases. DataStage NVarchar/NChar columns are working fine on the SE canvas with Oracle Connector.
Problem conclusion
Temporary fix
Change to NVarchar OR set NLS_LANG=...AL32UTF8 and incrase Varchar/Char length to (max number of chars in Oracle column) * (4). So if there's a Varchar(10) in the Oracle database, on the SE canvas set the length to 40 and set NLS_LANG=...AL32UTF8. Where "..." is your local specific to your environment.
Comments
APAR Information
APAR number
JR40302
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
850
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-08-29
Closed date
2011-08-31
Last modified date
2011-08-31
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R850 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 October 2021