Using json_arrayagg() to return list of values without names

[TheZenbudda]

How do I use db2 sql to generate a list of values without names?

{
  "name" : "value",
  "myarray" : ["value1","value2","value3"]
} 

[TheZenbudda]

It took me a while to figure it out.

select
    json_object(
        'name' value 'value',
        'myarray' value json_arrayagg(
              mycolumn
        )
    )
from mytable
where mykey = keyvalue
group by mykey 

[Scott Klement]

Oh, I see... you wanted all values of a column to be reported as an array within the json document.