Import problem from AS400

[khawkins]

I have a import problem, I have to pull data from J. D Edwards As400 (DB2) files. My IT department has insisted that all access to the 400 is by writing a world writer report to a file. World Writer is a clunky report writer that comes with JDE. My problem is that I get a square box at the end of some of the fields, and not on every record. I have tried to use right() and trim() to get rid of the problem but access must be seeing this as a character so it will not trim it away. I have tried to find a key that is the same as this but have not been able to. I tried to paste a sample of what I am talking about but the little square box does not come through in the past. Any suggestions on how I can get rid of this will be great. The only way I have found so far is to manually delete it on each record. Not a feasible solution when I have 10 to 20 k records. IT has no clue on how to get rid of it either.
Thanks for any help ahead of time.

 

[Amir]

Hi,
we had same problem with our data from mainframe s/36 (and
AS400). when we get data from them it will include square
boxes in those reports.. The it is EBCDIC (as400 ) to
ascii problem. I got someone looking into how they have
fix this for us and i will publish it soon as they find
out. but funny thing happens if you look at the data in
anything lower then Windows XP the boxes will show up if
you look at the data for example in WordPad in XP it will
actualy look right (no boxes). You might wanna try looking
at your data from XP box to see if it makes difference,
just use your WordPad. You could possibly use find/replace
feature of WordPad and replace all square boxes with
nothing. it only takes few moments to do this.
let you know

-----Original Message-----
I have a import problem, I have to pull data from J. D

Edwards As400 (DB2) files. My IT department has insisted
that all access to the 400 is by writing a world writer
report to a file. World Writer is a clunky report writer
that comes with JDE. My problem is that I get a square box
at the end of some of the fields, and not on every record.
I have tried to use right() and trim() to get rid of the
problem but access must be seeing this as a character so
it will not trim it away. I have tried to find a key that
is the same as this but have not been able to. I tried to
paste a sample of what I am talking about but the little
square box does not come through in the past. Any
suggestions on how I can get rid of this will be great.
The only way I have found so far is to manually delete it
on each record. Not a feasible solution when I have 10 to
20 k records. IT has no clue on how to get rid of it
either.

 

[Bill Murphy]

Test.

I have a import problem, I have to pull data from J. D Edwards As400 (DB2)

files. My IT department has insisted that all access to the 400 is by
writing a world writer report to a file. World Writer is a clunky report
writer that comes with JDE. My problem is that I get a square box at the end
of some of the fields, and not on every record. I have tried to use right()
and trim() to get rid of the problem but access must be seeing this as a
character so it will not trim it away. I have tried to find a key that is
the same as this but have not been able to. I tried to paste a sample of
what I am talking about but the little square box does not come through in
the past. Any suggestions on how I can get rid of this will be great. The
only way I have found so far is to manually delete it on each record. Not a
feasible solution when I have 10 to 20 k records. IT has no clue on how to
get rid of it either.