Problem INSERTing "£" (pound) character
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi,
I did try with NLS Map ISO8859-1 and ISO8859-1+MARKS. I am receiving the following warning and the row is being rejected. However, using these two NLS maps I am able to view the pound character in the source stage but it is not getting inserted using the same NLS.
Warning:
------------------
Row rejected.
DBMS.CODE=-302, SQLSTATE=22001, [IBM][CLI Driver][DB2/AIX64] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTATE=22001
Thanks,
Corvus
I did try with NLS Map ISO8859-1 and ISO8859-1+MARKS. I am receiving the following warning and the row is being rejected. However, using these two NLS maps I am able to view the pound character in the source stage but it is not getting inserted using the same NLS.
Warning:
------------------
Row rejected.
DBMS.CODE=-302, SQLSTATE=22001, [IBM][CLI Driver][DB2/AIX64] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTATE=22001
Thanks,
Corvus