RE: qsys2.http_post - get http status code

OMG, I just start switch over to that also

dcl-s request varchar(1024);

exec sql
values QSYS2.HTTP_POST_VERBOSE(:urlRest, :request, :options)
into :response, :responseHdr;


request gives me this error SQL0390: Position 20 Use of function HTTP_POST_VERBOSE in QSYS2 not valid.
When I add the VERBOSE but with

exec sql
values QSYS2.HTTP_POST_VERBOSE(:urlRest, :request, :options)
into :response;


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jay Vaughn
Sent: Thursday, December 12, 2024 3:14 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: qsys2.http_post - get http status code

________________________________
CAUTION: This email originated from outside of the PENCOR network. Do not click on any links or open attachments unless the sender is known, and the content is verified as safe.
________________________________

Nadir's magic is what I was looking for.

thanks

Jay

On Thu, Dec 12, 2024 at 2:39 PM Jack Woehr via MIDRANGE-L < midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

What magic way do you have in mind that the VERBOSE functions should
return this info as opposed to how they do it currently?
They're table functions.






________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of
Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
Sent: Thursday, December 12, 2024 12:08
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: qsys2.http_post - get http status code

CAUTION: This email originated from outside of the organization. Do
not click links or open attachments unless you recognize the sender
and know the content is safe.

lol thanks Jack, but I don't think you took the time to read the
extent of my inquiry.




Jack Woehr
Independent Consulting Programmer

303-847-8442

jack.woehr@xxxxxxxxxxx

www.procern.com

Stay Connected!

Proactive. Preventive. Problems Solved.

 NON-DISCLOSURE NOTICE: This communication including any and all
attachments is for the intended recipient(s) only and may contain
confidential and privileged information. If you are not the intended
recipient of this communication, any disclosure, copying further
distribution or use of this communication is prohibited. If you
received this communication in error, please contact the sender and
delete/destroy all copies of this communication immediately.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.