JR40302: IN SERVER JOB, NLS MAP DOES NOT WORK FOR CHAR AND VARCHAR COLUMN IN ORACLE CONNECTOR.

IBM InfoSphere Information Server, Version 8.5 Fix Pack 3

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 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