noxDB – Not Only XML….

Nox is an opensource framework that makes it easy to work with XML, JSON and SQL with one single approach - From within RPG.

Basically you have an object graph which is build from scratch or loaded from XML, JSON, SQL or even CSV files.

The idea is that it is equally easy to manipulate the data graph from RPG and save/update data right back to XML, JSON or SQL.

This makes this tool perfect to load data from SQL and produce JSON in a web application. Or simply load data from SQL totally dynamically and then update SQL – dynamically.

It bring dynamic result set to RPG, so you don't have to recompile each time you add or change columns to your DB2 tables.

It is as simple as this in your RPG program:

// load a resultset from the product table sql = 'Select * from product';
pRows = json_sqlResultSet(sql);

// Produce a JSON stream file in the root of the IFS
json_writeJsonStmf(pRows :
'/jsonxml/json/resultset-array.json' : 1208 : *ON
);

Look at all the samples in the QJXSAMPLE file