sql to scan and substring

I'm trying to select the value from a log file which holds part of large
json rows, but the json incomplete and not readable so the "status" never
in same position. I need the value of status.or even the whole string
"status":"Paid"
(scan and substring may be wrong description)
sample data
"status":"Paid","allow
],"status":"Declined",

I can picture this in RPGLE but trying to improve my sql...
Found solutions online but not DB2.

Jim Franz