Re: sql json_object and boolean

[Jay Vaughn <jeffersonvaughn@xxxxxxxxx>]

thanks for the reply Birgitta...
I thought for sure I had tried with the removal of "format json" as well...

now I'm discovering I actually need true or false booleans to show instead
of the 0's or 1's... also without quotes.
I know YAJL supports this but does sql?

Jay

On Thu, Sep 23, 2021 at 2:13 PM Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

> It is because you specified Format JSON at the end!
> When specifying FORMAT JSON it means the value is already JSON, so it will
> not add any quotes around.
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
> „Train people well enough so they can leave, treat them well enough so they
> don't want to.“ (Richard Branson)
>
>
> -----Original Message-----
> From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jay
> Vaughn
> Sent: Donnerstag, 23. September 2021 19:24
> To: RPG programming on the IBM i (AS/400 and iSeries)
> <rpg400-l@xxxxxxxxxxxxxxxxxx>
> Subject: sql json_object and boolean
>
> 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