Hi All,
Is it possible to parse JSON data in PL/I? My requirement is to parse request JSON received through z/OS connect and use those key fields and values in constructing a WHERE clause dynamically for DB2 query in my program.
eg:
Request received:
{ { EMP_ID:'abc',EMP_NAME:'abc',EMP_NO:'20',EMP_REG:[1,4,5,6],EMP_STATUS:'A'},
{ EMP_ID:'xyz',EMP_NAME:'acd',EMP_NO:'10',EMP_REG:[9,10],EMP_STATUS:'A'},
…
….
… }
Expected WHERE clause in program (after parsing and appending data wherever needed):
SELECT COL1, COL2
FROM TABLE1
WHERE
((EMP_ID='abc' AND EMP_NAME='abc' AND EMP_NO='20' AND EMP_REG=[1,4,5,6] AND EMP_status='A') OR
(EMP_ID='xyz' AND EMP_NAME='acd' AND EMP_NO='10' AND EMP_REG=[9,10] AND EMP_status='A'} OR
…
….
… ))
Is there a concept 'JSON Parser' in PL/I? Any leads would be appreciated.
Thanks,
Aswini Abraham
------------------------------
Aswini Abraham
------------------------------