Re: Help with Consuming A REST Web Service Using SQL And POST from ITJungle

Giovanni ... you have your job running in CCSID 65535 ... no CCSID.
For SQL HTTP Functions you need to set a CCSID for the JOB ...
In those case, in my RPGSQLLE I've got something like this

exec sql call qsys2.qcmdexc('CHGJOB CCSID(280)'); // Yes ... I'm Italian
too!
exec sql select systools.httpgetclob(xxx)
exec sql call qsys2.qcmdexc('CHGJOB CCSID(*USRPRF )');



Il giorno mar 3 mar 2020 alle ore 23:59 Giovanni Arturi via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> ha scritto:

Hi Kevin

I tried to read the discussion in RPG400 ;

i tried :

1. to set DCL-S fieldname datatype CCSID(37) , but i receive error
in compiling (i’m run V7r2 ) !!

2. I have tried with chgjob CCSID 1141 and when i run the pgm i don’t
receive error but the WebService answer with “API_KEY wrong”, but the
API_KEY is correct , i tried with Postman (with the same data)

3. I Have tried with chgjob CCSID 1144 (Italian CCSID) and now i
receive error that says “An indicator variable is required”



Any suggestion ?

Thanks



Da: Kevin Bucknum [mailto:Kevin@xxxxxxxxxxxxxxxxxxx]
Inviato: martedì 3 marzo 2020 18:29
A: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: giovanni.arturi@xxxxxxxxx
Oggetto: Re: Help with Consuming A REST Web Service Using SQL And POST
from ITJungle



You can't use the sql http functions with a job ccsid of 65535.
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzajq/rzajqhttpoverview.htm





There was a discussion this morning on the RPG400 list that discusses this
same error.





On Tue, 2020-03-03 at 18:14 +0100, Giovanni Arturi via MIDRANGE-L wrote:

Hi all

I have found the example at

<
https://www.itjungle.com/2017/10/02/guru-consuming-rest-web-service-using-sq>



https://www.itjungle.com/2017/10/02/guru-consuming-rest-web-service-using-sq




l-post/ and followed it. I have customized the example, but when i run the
program i receive in SqlCode the value "-332" and as message i receive
"Invalid character conversion between CCSID 65535 and CCSID 1200"

Where am i wrong ? mu job run under 65535 CCSID

Thanks in advance





--
Questa e-mail è stata controllata per individuare virus con Avast
antivirus.

<https://www.avast.com/antivirus>

https://www.avast.com/antivirus







Kevin Bucknum
Senior Programmer Analyst
MEDDATA / MEDTRON
120 Innwood Drive
Covington LA 70433
Local: 985-893-2550
Toll Free: 877-893-2550
https://www.medtronsoftware.com



CONFIDENTIALITY NOTICE



This document and any accompanying this email transmission contain
confidential information, belonging to the sender that is legally
privileged. This information is intended only for the use of the
individual or entity named above. The authorized recipient of this
information is prohibited from disclosing this information to any other
party and is required to destroy the information after its stated need has
been fulfilled. If you are not the intended recipient, or the employee of
agent responsible to deliver it to the intended recipient, you are hereby
notified that any disclosure, copying, distribution or action taken in
reliance on the contents of these documents is STRICTLY PROHIBITED. If you
have received this email in error, please notify the sender immediately to
arrange for return or destruction of these documents.

--
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@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com