Midrange News for the IBM i Community

Posted by: Bob Cozzi
Rogue Programmer
Cozzi Productions, Inc.
JSON from DB2 for #IBMi
has no ratings.
Published: 18 Nov 2016
Revised: 22 Nov 2016 - 159 days ago
Last viewed on: 29 Apr 2017 (419 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

JSON from DB2 for #IBMi Published by: Bob Cozzi on 18 Nov 2016 view comments

We have great feature in SQL iQuery that allows you to generate JSON from IBM i database files. It can send it to the IFS or to the web and we recently used it to help build a entire website, including product catalog and shopping cart.

What I'm wondering is, what are others using to create JSON? About 2 years ago, I realized JSON was displacing XML at a huge pace, so rather than focus on XML I moved to optimizing DB2 -> JSON in SQL iQuery.

What are you using to generate JSON or isn't it important, or is there something else, such as a 3rd-party tool that converts DB2 to JSON using IBM Db2 SQL?



Return to midrangenews.com home page.
Sort Ascend | Descend