Creating JSON using SQL statement | JSON_OBJECT function | yusy4code

In this video i have explained how to create JSON using in build JSON_OBJECT SQL scalar function.

Reference:

[higiniofuentes]

I rent an account in Texas400 ($30 3 month) too 3 years ago!
Very good guy!

[higiniofuentes]

Thank you Mohammed!
No excuses to don't use IBM i all the time for everything!

[higiniofuentes]

Hi Mohammed, thank for this refreshing video!
I tried values json_object ('id' value 12, 'name' value 'pollo', 'office' value 'el 24'
absent on null)
And the answer is *POINTER
but if I try values cast(json_object ('id' value 12, 'name' value 'pollo', 'office' value 'el 24'
absent on null) as varchar(100))
I receive the expected content: {"id":12, "name":"pollo", "office":"el 24"}
The same for select cast(json_object....

[mariannehatcher]

thank you! this has been a huge help!!

[CasualCatches]

I tried in IBM DB2V11, JSON is not supporting.