CODEWITHSUNDEEP
db2ibm-midrange
Sadam Husain
Sadam Husain

Reputation: 41

AS400 - Parse JSON and store the fields into DB2 table

I have got requirement to parse a JSON document that will be passed to a stored procedure inside a CLOB, and store its details into a DB2 table.

I cannot make use of JSON_TABLE function as I am still using IBM i V7R1.

Is there any way I can achieve this ?

Upvotes: 0

Views: 1360

Answers (2)

GenericDisplayName
GenericDisplayName

Reputation: 463

Pre native built in support for JSON in 7.2 I used this third party tool ported to the iSeries and maintained by Scott Klement YAJL (Yet Another JSON Library)

Upvotes: 2

Jairo R. Flores
Jairo R. Flores

Reputation: 734

I've used this apis on production. Excellent work.

Mihael Schmidt's Json Parser

Upvotes: 1

Related Questions