Reading chinese data and loading in db2 tables

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bveeraballi
Participant
Posts: 4
Joined: Tue Sep 14, 2010 7:24 pm

Reading chinese data and loading in db2 tables

Post by bveeraballi »

Hi,
i have a requirement in which i have to read the chinese data(Unicode .txt dile) and store it in the DB2 database tables. Please let me know the necessary additional installions required for this on the datastage side and on the DB2 database side.
i tried reading the file with NLS -GB_2312-80,GBK,gb18030,HZ-GB-2312 and locale=zh. it showed the below warinngs.


##E IIS-DSEE-TFOR-00089 00:05:10(000) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##E IIS-DSEE-TFPM-00040 00:05:10(002) <_ABORT_IDENT_,0> Operator terminated abnormally: runLocally() did not return APT_StatusOk
##E IIS-DSEE-TFSC-00011 00:05:16(000) <main_program> Step execution finished with status = FAILED.
Could some one please help me in starting with this requirement?
Apotluri
Premium Member
Premium Member
Posts: 25
Joined: Sun Dec 25, 2005 10:38 pm

Re: Reading chinese data and loading in db2 tables

Post by Apotluri »

Hi
Try with keeping the NLS as UTF-8 and add the environmental variable DB2CODEPAGE and give the value as 1208 for the variable
Post Reply