NoSQL on IBM i
db2nosql – A command line shell to create and query JSON data using Mongo commands. To start the command line processor, use QSHELL and run /QIBM/ProdData/OS/SQLLIB/bin/db2nosql. The command runs through JDBC driver so ensure JRE is set in the PATH and CLASSPATH has the JDBC driver. Once command line processor shows “NoSQL” type enable (true) to set up the database artifacts. SQL Terms/Concepts MongoDB Terms/Concepts database database table collection row document or BSON document column field index index table joins $lookup, embedded documents primary key primary key Specify any unique column or Column combination as primary key. In MongoDB, the primary key is automatically set to the _id field. aggregation (e.g. group by) aggregation pipeline Database and Collections Create a database with ‘...