Invalid Character Error while reading data from Db2

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
nansekar
Participant
Posts: 29
Joined: Mon Nov 03, 2008 6:23 am

Invalid Character Error while reading data from Db2

Post by nansekar »

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.
nansekar
Participant
Posts: 29
Joined: Mon Nov 03, 2008 6:23 am

Re: Invalid Character Error while reading data from Db2

Post by nansekar »

Hello Team

Any Suggestions to sort out this error please..
Post Reply