Special Character in the EXTRACT file created (Fixed Width)
Posted: Wed Nov 03, 2010 3:37 pm
Hi All,
Thanks for looking into this post.
I have an issue which has come just couple of days before the Prodcution Implementation. Pls help me with a resolution.
I am reading the data from DB2 tables & generating an extract.
The extract generated has a SPECIAL CHARACTER in it due to which the downstream system is not able to load the data in their end.
While I open the file in wordpad, I could see the SPECIAL CHARACTER as a BOX (something like this []).
It happens for the fields which I have defined as CHAR. How to resolve this issue? Any help will be greatly appreciated.
Thanks
Freddie
Thanks for looking into this post.
I have an issue which has come just couple of days before the Prodcution Implementation. Pls help me with a resolution.
I am reading the data from DB2 tables & generating an extract.
The extract generated has a SPECIAL CHARACTER in it due to which the downstream system is not able to load the data in their end.
While I open the file in wordpad, I could see the SPECIAL CHARACTER as a BOX (something like this []).
It happens for the fields which I have defined as CHAR. How to resolve this issue? Any help will be greatly appreciated.
Thanks
Freddie