I am trying to insert accented characters into a DB2 table using ODBC Ent stage.The accented character records are getting rejected. Is there any way we can insert them (without using Datastage 'convert').
Thanks.
Handling accented characters
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
My job design is following :
Seq File -> Transformer -> ODBC Ent (with Reject link)
I have set 'UTF-8' in only ODBC Ent stage. The error due to the accented char is shown below :
Character data, right truncation occurred; for example, an update or insert value is a string that is too long for the [odbcUtils.C:1289]
Records with accented char go to Reject link due to the above.When I convert those accented char into English, data gets loaded.
Please advise what NLS option I have to use and in which stage.
Seq File -> Transformer -> ODBC Ent (with Reject link)
I have set 'UTF-8' in only ODBC Ent stage. The error due to the accented char is shown below :
Character data, right truncation occurred; for example, an update or insert value is a string that is too long for the [odbcUtils.C:1289]
Records with accented char go to Reject link due to the above.When I convert those accented char into English, data gets loaded.
Please advise what NLS option I have to use and in which stage.
I have an issue where my source databases can have all kinds of high ASCII characters (general from cut and paste operations) and since I use a src --> text file --> target, I end up with all kinds of problems. I borrowed a routine from some of the great minds here and then modified it to interpret certain high ASCII chars to standard ASCII(32-127). This may not be what you want, but it is pretty efficient and stops all kinds of problems on the processing end. If you would like to see the routine, I'll be happy to post it. Just let me know.
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"