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
------------------------------
Original Message:
Sent: Fri December 24, 2021 03:24 PM
From: Şükrü EREN
Subject: Datastage job with rcp unicode issue
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
------------------------------
#DataIntegration