DB2 table data load issue through DataStage(8.7) job

naveed.zuber · Post by **naveed.zuber** » 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

chulett · Post by **chulett** » Fri Sep 12, 2014 8:16 am

What are the charactersets involved?

naveed.zuber · Post by **naveed.zuber** » Fri Sep 12, 2014 8:24 am

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

chulett · Post by **chulett** » Fri Sep 12, 2014 9:14 am

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

qt_ky · Post by **qt_ky** » 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?

naveed.zuber · Post by **naveed.zuber** » Fri Sep 12, 2014 9:32 am

yes,both source and target are unicode characterset.

naveed.zuber · Post by **naveed.zuber** » Sat Sep 13, 2014 2:13 am

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