Tag: IBM

Community

(Updated) NoSQL and JSON with DB2

(Henrik Loeser) You may have heard that DB2 10.5, which recently became available, includes a technology preview “DB2 NoSQL JSON”. JSON is the JavaScript Object Notation. The important stuff for JSON in DB2 can be found in the sqllib/json directory. Once I added the “lib” directory to the Java CLASS

Community

Practical SQL: OLAP, Part 2

(Joe Pluta) In my previous OLAP article, I used the OLAP function ROW_NUMBER to provide the concept of "next record" that we take for granted in RPG’s native access (contrast RPG’s native ISAM access with SQL’s relational access). In this article, I’ll show you the magic of GROUPING SETS and how the