I recommend looking at the SQL table function XMLTABLE and HTTPGETCLOB (this is in SYSTOOLS schema) - this is available at 7.1 and can pull directly from a web service into a result set.

I saw this at one of Birgitta's presentations at this year's COMMON meeting.

Here is an example:

        Select x.*
           From XMLTABLE('geonames/country'
                         Passing Cast(XMLParse(Document(
                                             ''))) as XML)
                        Columns "countryCode"     VarChar(30),
                                "countryName"    VarChar(50),
                                "numPostalCodes" VarChar(10),
                                "minPostalCode"  VarChar(10),
                                "maxPostalCode"  VarChar(10)) x;

Hope this helps

On 9/1/2017 11:10 AM, Bradley Stone wrote:
You should probably ask on Scott's mailing list (

But, I would guess HTTPAPI must have a way to use a stream file as the XML
instead of a variable in the program. That way there's really no limit.

Bradley V. Stone
MAILTOOL Benefit #19 <https://www.bvstools.com/mailtool.html>: The ability
to turn off "Strict SSL" settings. This means no importing Certificate
Authorities (CAs) unless you want to.

On Fri, Sep 1, 2017 at 8:49 AM, orlando misas <omisas@xxxxxxxxx> wrote:

Good day

I have to consume a web service soap using httpapi sending an xml with
more than 65000 bytes. As I define the field in rpg that takes the xml
structure with a size greater than 65000 bytes? I appreciate the
The configuration is as400 versión 7.1

Orlando Misas
This is the RPG programming on the IBM i (AS/400 and iSeries) (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.

Please contact support@xxxxxxxxxxxx for any subscription related

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].