Page 1 of 1
Posted: Fri Nov 07, 2014 8:18 am
by chulett
What code page / characterset is your target database using?
Posted: Fri Nov 07, 2014 9:40 am
by ruf888
The DB2 colleague told me that the target db uses the IBM500 codepage. but If I use this in the job property, the job won't read any lines from the text file, because it can not find the delimeter in the file. So I can not use this code page.
Posted: Fri Nov 07, 2014 9:47 am
by chulett
Not sure how that would cause that... what is your record delimiter? Something unusual?
Posted: Fri Nov 07, 2014 11:09 am
by ruf888
No, the delimeter is comma. If I use the normal code page, like ISO-8859, utf-8, windows-1252, then the same job will run without error, but the character appears like I mentioned, not as I'd like to have.
Posted: Fri Nov 07, 2014 11:15 am
by chulett
So a field delimiter rather than a record delimiter issue. Odd.
Posted: Mon Nov 10, 2014 4:49 am
by chanaka
Hi ruf888,
What is the data type of the column in target? Ideally it should be Nvarchar or Nchar to support multi-byte characters.
Cheers!
Chanaka