IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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