small square box

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
kvsudheer
Premium Member
Premium Member
Posts: 20
Joined: Fri Aug 18, 2006 12:01 am
Location: India

small square box

Post by kvsudheer »

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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kvsudheer
Premium Member
Premium Member
Posts: 20
Joined: Fri Aug 18, 2006 12:01 am
Location: India

Post by kvsudheer »

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.
chucksmith
Premium Member
Premium Member
Posts: 385
Joined: Wed Jun 16, 2004 12:43 pm
Location: Virginia, USA
Contact:

Post by chucksmith »

This tool will create a dump of your file:

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