Invalid Character Error while reading data from Db2
Posted: Sun Dec 22, 2013 11:37 pm
Hello Team
We are facing issues in reading the data from DB2 and loading into a sequential file .
Job Details :
Source stage : DB2
Processing Stage: Transformer ( Used to remove char(10) values in convert function )
Target Stage : Sequential File.
NLS Map : Project default (ISO-8859-1)
Below are the error message :
APT_CombinedOperatorController,0: Invalid character(s) ([x2019]) found converting Unicode string (code point(s): `~!@#$%^&*()|_+{[x005B]}}\;:[x2019][x201D]",".<>/?[x00C0][x00C1][x00C3][x00C4][x00C8][x00C9][x00CB][x00CC][x00CD][x00CF][x00D1][x00D2] ) to codepage ISO-8859-1, substituting.
xfmProcess,1: Invalid character(s) ([x2019]) found converting Unicode string (code point(s): TRAVEL INDOCHINA (STATISTICAL)`~!@#$%^&*()_+{[x005B]}}\;:[x2019][x201D],.< ) to codepage ISO-8859-1, substituting.
Kindly help in resolving the issue.
We are facing issues in reading the data from DB2 and loading into a sequential file .
Job Details :
Source stage : DB2
Processing Stage: Transformer ( Used to remove char(10) values in convert function )
Target Stage : Sequential File.
NLS Map : Project default (ISO-8859-1)
Below are the error message :
APT_CombinedOperatorController,0: Invalid character(s) ([x2019]) found converting Unicode string (code point(s): `~!@#$%^&*()|_+{[x005B]}}\;:[x2019][x201D]",".<>/?[x00C0][x00C1][x00C3][x00C4][x00C8][x00C9][x00CB][x00CC][x00CD][x00CF][x00D1][x00D2] ) to codepage ISO-8859-1, substituting.
xfmProcess,1: Invalid character(s) ([x2019]) found converting Unicode string (code point(s): TRAVEL INDOCHINA (STATISTICAL)`~!@#$%^&*()_+{[x005B]}}\;:[x2019][x201D],.< ) to codepage ISO-8859-1, substituting.
Kindly help in resolving the issue.