Hello,
I am trying to load data from DB2 into Teradata using Bulk(Fast) method with the connector stage (DS 8.5). If using NLS='window-1252' and Client Character Set='LATIN1252_0A' there are issues with some special characters. '9D' hexadecimal in source ends up being '1A' in Teradata.
Was trying to set Client Character Set to UTF16 but the job aborts. However, setting NLS=UTF-16' for the job and Client Character Set to UTF16 works all right with Immediate method.
Is there any way to make Bulk method loading all possible characters in Teradata?
Thanks,
L.
Loading special characters in Teradata - Bulk mode
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Re: Loading special characters in Teradata - Bulk mode
There is only one client character set in Teradata that is 100% compatible with Windows Code page 1252 - LATIN1252_3A0. Currently the Teradata connector does not support this character set. I am working on trying to get the character set supported right now - you should enter a PMR with IBM.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
Re: Loading special characters in Teradata - Bulk mode
could be use the limitations given below
1.set datatype as EDCDIC
2.target table should be empty
3.insert only allowed
4.loads only one table in one job task
1.set datatype as EDCDIC
2.target table should be empty
3.insert only allowed
4.loads only one table in one job task
mgplk
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: