Progress_Learner
Member
Hello Guys, hope you all are doing well.
I have a Longchar variable that contains JSON data of 4 fields. I want to write a query and compare these longchar variable values with DB table/fields.
For Example: My Longchar variable contains below json data, I want to compare these JSON key : value pairs with customer table fields/values.
I am not getting how to query a Longchar variable for this purpose, please share your inputs on this.
Regards,
I have a Longchar variable that contains JSON data of 4 fields. I want to write a query and compare these longchar variable values with DB table/fields.
For Example: My Longchar variable contains below json data, I want to compare these JSON key : value pairs with customer table fields/values.
Code:
{"Customer": [
{
"cust-num": 121,
"name": "Jack",
"state": "Texas",
"city": "Houston"
}
]}
I am not getting how to query a Longchar variable for this purpose, please share your inputs on this.
Regards,