Re: sql json_object and boolean

Db2 for i doesn't understand RPG indicators...

,key 'license'
value json_object(key 'valid'
value case :g_valid when '1' then 'true' else 'false'
end
,key 'expires'
value :g_expDate
,key 'remaining'
value trim(char(:g_expDays))
,key 'expired'
value case :g_expired when '1' then 'true' else 'false'
end
)

HTH,
Charles

On Thu, Sep 23, 2021 at 11:24 AM Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
wrote:

I have two var's both declared as IND.
dcl-s g_valid ind inz;
dcl-s g_expired ind inz;

In the pgm I'm obviously only assigning *off or *on to them.
In the usage below, g_valid will show as "0"... but g_expired shows as 0
(with no " around it, which is correct)...

,key 'license'
value json_object(key 'valid'
value :g_valid
,key 'expires'
value :g_expDate
,key 'remaining'
value trim(char(:g_expDays))
,key 'expired'
value :g_expired
format json )

any ideas?

Birgitta?

tia
Jay
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

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

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

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