Search found 1 match
- Tue Feb 13, 2024 10:30 am
- Forum: RPG IV
- Topic: JSON_TABLE returns empty results
- Replies: 0
- Views: 2911
JSON_TABLE returns empty results
I am a newbie to SQLRPGLE. I have successfully run the folllowing SQL script using the ACS run SQL scripts. DROP TABLE ORIONTEST.JSONDATA; CREATE TABLE ORIONTEST.JSONDATA (JDATA CLOB(10000) CCSID 1208); INSERT INTO ORIONTEST.JSONDATA VALUES( CAST(' { "header": { "transactionId": ...