versuchs mal mit json_query
https://www.ibm.com/docs/en/i/7.3?to...ons-json-query
Code:
values json_query(
'{ "id": 2,
  "address": {
           "name": "Meier",
           "addressType": "privat",
           "street": "Goethestraße 4"
  }
}', '$.address');