Re: HTTP Post via Sql/RPG

[Ricky Thompson <rickyt29@xxxxxxxxx>]

I got it to work after I had asked for help but yes you are correct.  The
type should have been BLOB_FILE and it should've been HTTPPOSTBLOB.  Can't
wait for the technical refresh to get loaded on our system so I can use
some of the SQL IFS tools in it.  Also the CCSID had nothing to do with it,
in case someone comes across this post in the future.

Thanks for the help.


> date: Wed, 21 Oct 2020 12:55:03 -0600
> from: Charles Wilt <charles.wilt@xxxxxxxxx>
> subject: Re: HTTP Post via Sql/RPG
>
> Good catch, yes indeed HTTPPOSTBLOB should be used.
>
> CCSID on the .ZIP might not matter then, but it should still be set to
> 65535.
>
> Charles
>
>
> On Wed, Oct 21, 2020 at 10:38 AM John Yeung <gallium.arsenide@xxxxxxxxx>
> wrote:
>
> > On Mon, Oct 19, 2020 at 9:03 PM Ricky Thompson <rickyt29@xxxxxxxxx>
> wrote:
> > > I am creating a zip file on the IFS.  I then define the zip file as a
> > > SQLTYPE(CLOB_FILE). I then use SYSTOOLS.HTTPPOSTCLOB to send the
> > CLOB_FILE
> > > to the web service. This seems to be sending fine but the encoding
> seems
> > > off to me.
> >
> > I don't use those tools personally, so please forgive my ignorance,
> but...
> > Since a zip file is binary data, would you not want to define it as a
> > BLOB (rather than a CLOB)? And then use HTTPPOSTBLOB?
> >
> > John Y.