Re: open-weather.sqlrpgle Example

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Gio

I think you might be at an earlier release of the operating system. At 
7.1 I see that named constants cannot be used as host variables. Take a 
look at this link -
https://www.ibm.com/docs/en/i/7.1?topic=uhviiratus-declaring-host-variables-in-ile-rpg-applications-that-use-sql

Now the 7.2 version of this page says the same thing, but I'm not sure - 
I just compiled a module from that source on a 7.4 box with 
TGTRLS(V7R2M0), and it compiled. And CTRPGM worked.

So maybe there was a PTF for 7.2, I haven't looked. Now the same 
knowledge page for 7.3 suggests simple named constants CAN be used as 
host variables.

Anyhow, it worked on a 7.5 machine, as well as a 7.4 machine with 
TGTRLS(V7R2M0).

Regards
Vern

On 6/6/2022 4:37 PM, gio.cot via RPG400-L wrote:
> Hi all
>
> I'm try to compile the source of open-weather.sqlrpgle that i found  at
> <https://github.com/fathert/json-rpg-example/blob/master/open-weather.sqlrpg
> le>
> https://github.com/fathert/json-rpg-example/blob/master/open-weather.sqlrpgl
> e   (Thanks to Tim Fathers) but i receive this errors:
>
>   
>
> Variable HOST,  ENDPOINT APPID  and  not defined . Reason: No declaration
> for the variable exists, the declaration is not within the current scope, or
> the variable does not have an equivalent SQL data type.
>
> At this program point :
>
>   
>
>    // Execute the webservice call.
>
>    exec sql
>
>      set :response = systools.httpgetclob(
>
>        concat(:HOST, replace(replace(:ENDPOINT, '&CITY_IDS', :cities),
> '&APPID', :APPID)),
>
>        :requestHeaders
>
>      );
>
>   
>
> can some one help me to understand where am i wrong ?
>
> thanks in advance
>
> Gio