DataStage - Data Integration

 View Only
Expand all | Collapse all

Datastage job with rcp unicode issue

  • 1.  Datastage job with rcp unicode issue

    Posted Mon December 27, 2021 04:29 PM
    Hi everyone,

    i have a job with rcp, no column defined that is why i can't set extended unicode therefore my data get corruption could you please help me?

    Best Regards

    ------------------------------
    Şükrü EREN
    ------------------------------


  • 2.  RE: Datastage job with rcp unicode issue

    Posted Tue December 28, 2021 04:01 AM
    Try the following in your SQL (example for DB2),

    cast(CHAR_COL as GRAPHIC(n) as CHAR_COL
    ,cast(VARCHAR_COL as VARGRAPHIC(n) as CHAR_COL

    then DataStage should then read your columns as ustring (there is no difference in Datastage between e.g. CHAR extended unicode and NCHAR).

    In DB2 your have to be carefull that GRAPHIC/VARGRAPHIC have a max length of 128/16352 which is half the max length of CHAR/VARACHAR, so you may have to cast a CHAR bigger than 128 to VARGRAPHIC

    You could also try to fiddle around with your DB2CODEPAGE environment variable (set $DB2CODEPAGE in the administrator) which should affect the reading connector

    KR Ralf

    ------------------------------
    Ralf Martin
    Principal Consultant
    Infologistix GmbH
    Bregenz
    ------------------------------