DSXchange

Posted: **Fri Sep 12, 2014 8:09 am**

Please share your inputs on the issue.

INPUT: CSV file
SOURCE COLUMN A =V671U050117 (VARCHAR 50)
SOURCE COLUMN B=21 (VARCHAR 20)

OUTPUT Derivation:
TARGET COLUMN X (VARCHAR 256) =SOURCE COLUMN A : '_' : SOURCE COLUMN B

Expected OUTPUT:DB2 table
V671U050117_21
ACTUAL OUTPUT:
V671U050117?21

_ is loading as ? in target table

Posted: **Fri Sep 12, 2014 8:16 am**

What are the charactersets involved?

Posted: **Fri Sep 12, 2014 8:24 am**

Thanks Craig!
Characterset used in UNICODE.
Please let me know in case of further questions.

Posted: **Fri Sep 12, 2014 9:14 am**

I meant for both the source and target... still the same answer?

Posted: **Fri Sep 12, 2014 9:31 am**

I wonder if you may be missing a DB2 environment variable.

Did you query the table outside of DataStage to see what it looks like?

Posted: **Fri Sep 12, 2014 9:32 am**

yes,both source and target are unicode characterset.

Posted: **Sat Sep 13, 2014 2:13 am**

Thanks Eric.
Yes checked outside the DataStage environment also character looks '?'.

DSXchange

DB2 table data load issue through DataStage(8.7) job

DB2 table data load issue through DataStage(8.7) job