Im receiving the folloing warning while running a parallel job which loads data into oracle database from an oracle database:
main_program: Invalid character(s) ([xB0]) found converting string (code point(s): HOLD_TYPE_DESCRIPTION[x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][xB0][x09]![x08][x06][x00][x00][x00][x0A][x00]) from codepage UTF-8 to Unicode, substituting.
All the rows are getting loaded in the target without any rejections.Can anyone help me to avoid the warning?
Thanks in advance.
Mourya
Invalid Characters
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How is this character getting into the data in the first place? It seems to me that prevention may be better than cure, if the field is simply intended to be space padded.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.