Re: json conditional arrays/objects

[Jay Vaughn <jeffersonvaughn@xxxxxxxxx>]

you are a good man - confessing the limitations of your method

I may write up an IDEA  - it is a bit of a challenge in SQL as well and if
I cannot overcome these escape characters, there is not a way in sql either.

thanks

jay

On Thu, Sep 19, 2024 at 2:03 PM Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

> Actually I have to confess that in this instance I can't.  DATA-GEN has a
> similar issue in that, although it will not output empty array entries, it
> still outputs the object itself with an empty array.
>
> Probably should write up an IDEA on that as it should be possible to fix
> without too much of a problem.
>
>
> Jon Paris
> Jon.Paris@xxxxxxxxxxxxxx
>
>
>
> > On Sep 18, 2024, at 6:18 PM, Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
> wrote:
> > lol. Ok Jon. I’ll bite.
> >
> > Can you show?
> >
> > Thanks
> >
> > Jay
> >
> >
> > > On Sep 18, 2024, at 5:33 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx>
> wrote:
> > > Well you could always use DATA-GEN easy with that ... <evil grin>
> > >
> > >
> > >
> > > Jon P
> > >
> > >
> > >
> > > > On Sep 18, 2024, at 5:16 PM, Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
> wrote:
> > > > Ok I asked a question about this last week and got a good answer back
> from
> > > > Birgitta but I've cleaned my gmail up and cannot find that last post
> > > > unfortunately, so starting a new one...
> > > >
> > > > Lets say I have the following json structure embedded in another json
> > > > object...
> > > >
> > > > "Array1": [
> > > >  {
> > > >      "key1":  "myValue1",
> > > >      "key2":  "myValue2",
> > > >      "Array2": [
> > > >           {
> > > >                    "key3":  "myValue3",
> > > >                    "key4":  "myValue4"
> > > >          }
> > > >     ]
> > > > },
> > > > {
> > > >        "key5":  "myValue5",
> > > >        "key6":  "myValue6"
> > > > }
> > > > ]
> > > >
> > > > But I only want that array or object to show if non-blanks are passed
> to
> > > > any of "myValues"
> > > > and I cannot have empty structures such as {}.
> > > >
> > > > Is there a way to do this with db2 sql json functions?
> > > >
> > > > I used Birgittas instructions on a field basis using syntax such as...
> > > >
> > > > values json_object('key1"
> > > >                            :case when :myValue <> ' '
> > > >                                      then trim(:myValue)
> > > >                             end
> > > >     absent on  null);
> > > >
> > > > But this will leave {} if nothing in myValue.
> > > > How do I ensure it does not build the empty structure?
> > > >
> > > > 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.
> > > >
> > >
> > > --
> > > 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.
> > >
> > --
> > 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.
> >
>
> --
> 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.