Re: sql json_object and boolean

[Jay Vaughn <jeffersonvaughn@xxxxxxxxx>]

btw, i removed the "format json" from the json_object and it now shows both
variable output wrapped in quotes.

I'm looking for no quotes around the 0 and 1 variable output (which are
indicator)...
but even better, how can I show true or false with no quotes?

Jay

On Thu, Sep 23, 2021 at 2:17 PM Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
wrote:

> 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