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?