DSXchange

Hi,

I have data in a XYZ (table A) trailing with special character small square box in db2.
I know this is not just space to trim, I do not know what that character is??
I am using the above said XYZ column to join with another table B using join stage
and the join fails as the table A data has square brackets and the table B doesn't.

table A
-------

XYZ (char(20))
123AB4567<square box>(10 to 20)

table B
-------

XYZ (char(20))
123AB4567

Any thoughts on getting rid of square box and join two tables are greatly appreciated.

Thanks.

Did the file come from Windows? Then the character is likely to be Ctrl-M (carriage return) which you can represent as Char(13). Use a hex editor to find out what this character actually is.

Original file is coming from Unix. I take this file and load in to column of tableA char(20).
I do not where the hex editor is and how to use it. Please advice.

Thanks.

This tool will create a dump of your file:

http://www.anotheritco.com/tools/downlo ... ile_v3.htm