Re: HTTP Post via Sql/RPG

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.