Re: qsys2.http_post - get http status code

so I know my requirement was to get the http status code after the
http_post, but using http_post_verbose gives it back to use in the same
call so this is better for us...
so thanks for leading me there.

thanks
Jay

On Thu, Dec 12, 2024 at 3:19 PM Slanina, John via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

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.

--
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.