Re: XML-INTO truncating long character fields?

Just in case anyone else runs into this in future I thought I'd share the
resolution. After a little help from our friends in Rochester, it turned
out this issue was part of:

V6R1M0 APAR SE38364 (RPGLE-RUN-MSGCPE3460 XML-INTO PROCESSING A LARGE XML
DATA FILE)

To resolve the problem, we applied runtime PTF SI36080 and compiler PTF
SI38316

Kind Regards,

Joe Maguire




From:
Joe.Maguire@xxxxxxxxxxxx
To:
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Date:
04/02/2010 01:12
Subject:
Re: XML-INTO truncating long character fields?
Sent by:
rpg400-l-bounces@xxxxxxxxxxxx



Yes, I've looked for PTFs and no sign of anything relevant.

It is always 514 bytes that I get, regardless of how long the target
subfield is.

You're correct regarding the content here, it is a binary file (usually
tiff), but it is base64 encoded so it should not have any odd characters.
Just to be sure I tried replacing the data in my sample XML file with a
string of 700 "A" characters and again I got just 514 of them.

And I tried your suggestion of making the subfield varying, and sure
enough %Len(SupplierInvoice.Image) reports 514.

Time to raise a PMR for IBM to have a look methinks ... I'm stumped :-\

Kind Regards,

Joe Maguire


Jon Paris wrote on 03/02/2010 15:10:54:

Re: XML-INTO truncating long character fields?

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


--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.