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....
thank you! this has been a huge help!!
Thank you Mohammed!
No excuses to don't use IBM i all the time for everything!
I rent an account in Texas400 ($30 3 month) too 3 years ago!
Very good guy!
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....
I tried in IBM DB2V11, JSON is not supporting.