Re: XML-INTO truncating long character fields?

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

On Feb 3, 2010, at 8:43 AM, rpg400-l-request@xxxxxxxxxxxx wrote:

> the data structure is populated as you would expect and all is well,
> except that the 'Image' subfield contains just the first 514  
> characters of
> the data which was in the XML with the rest of this subfield filled  
> with
> whitespace?


I'm assuming you have already checked for PTFs etc.

Is it always 514? It is a strange number.

You call the field "image" - is it indeed an image field? (jpg or  
whatever) in which case any number of issues may arise since  
translation would make no sense and termination characters may be  
detected (for example).

You might get a bit more of a hint by switching the definition to 9999  
Varying. That way you can examine the length that XML-INTO thinks it  
is loading into the space.


Jon Paris

www.Partner400.com
www.SystemiDeveloper.com