Search found 1 match

by DeirdreMaguire
Tue Feb 13, 2024 10:30 am
Forum: RPG IV
Topic: JSON_TABLE returns empty results
Replies: 0
Views: 35099

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": "12597 ...