Re: sql json_object and boolean

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Now if you were using YJAL, there's a yajl_addBool()

yajl_addBool('valid':g_valid);

Charles

On Thu, Sep 23, 2021 at 1:09 PM Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

> 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