Re: Xml greater than 65000 bytes

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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(
systools.httpGetClob('http://api.geonames.org/postalCodeCountryInfo?username=B.Hauser', 

                                             ''))) as XML)
                        Columns "countryCode"     VarChar(30),
                                "countryName"    VarChar(50),
                                "numPostalCodes" VarChar(10),
                                "minPostalCode"  VarChar(10),
                                "maxPostalCode"  VarChar(10)) x;

Hope this helps
Vern

On 9/1/2017 11:10 AM, Bradley Stone wrote:
> You should probably ask on Scott's mailing list (
> http://www.scottklement.com/mailman/listinfo/ftpapi).
>
> 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
> www.bvstools.com
> 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
> > colaboración.
> > The configuration is as400 versión 7.1
> >
> > Orlando Misas
> > Omisas@xxxxxxxxx
> > --
> > 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
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: http://amzn.to/2dEadiD