Regarding Loading chinese characters

ArndW · Post by **ArndW** » Wed Oct 21, 2009 2:57 am

The "view data" functionality should not be used for viewing NLS data as it seldom does that correctly. I am fairly certain that your textfile data is not UTF-8; once you tell DataStage what the correct text file NLS mapping is, it will correctly convert to UTF-8.

manojbh31 · Post by **manojbh31** » Wed Oct 21, 2009 3:21 am

Hi

The feed file which i am getting is UTF-8 only. when i open the file and do save as and check the encoding it is showing UTF 8.

ArndW · Post by **ArndW** » Wed Oct 21, 2009 4:54 am

If the source stage is set to UTF-8 then DataStage is reading the data correctly (despite the view-data output). What are your enviroment settings for DB2 and which DB2 stage are you using to write?

manojbh31 · Post by **manojbh31** » Wed Oct 21, 2009 5:21 am

DB2 Stage is DB2_UDB_Enterprise_15

Database code set = UTF-8

Do i need to change any setting in DS to view the data correctly

ArndW · Post by **ArndW** » Wed Oct 21, 2009 5:32 am

You cannot use the "view data" in DataStage to correctly view multibyte data, unfortunately.
Is your DB2 instance and/or table also set up to use UTF-8?

manojbh31 · Post by **manojbh31** » Thu Oct 22, 2009 6:18 am

Hi,

I am able to load the data into DB2 table using ODBC Enterprise stage. and able to view the data in DB2 table as it looks in source. Can any body let me know why its so. Why cannot i see the correct data when i use DB2 Stage

ray.wurlod · Post by **ray.wurlod** » Thu Oct 22, 2009 3:44 pm

Because View Data does not work properly with multibyte characters.

It is NOT a fault of the stage.