I've completed work on CSV, Sylk (Excel), HTML and other file conversion formats.
I am now beginning my task of creating JSON directly from an SQL statement over DB2 for i.
IBM has announced JSON support, however their API does NOT create JSON from db2 files, it only stores, searches and returns JSON content stored in a BLOB within a DB2 file. Good for certain things, but not what I'm looking for.
I need to be able to create JSON directly from a delivered SQL statement, such as:
SELECT cstnbr,cstname,addr1,addr2,city,state,zipcode FROM mlib/customers order by zipcode
Once the SQL statement produces its resultset, I would deliver the records in JSON format to the caller or write them to STDOUT (the web).
QUESTION: Am I off track here? Don't we need db2-to-JSON?