Books & Blogs


Books
  • The Little Prince - Antoine de Saint-Exupéry
  • The Simple Path to Wealth: Your Road Map to Financial Independence and a Rich, Free Life - J.L.Collins

IBM i(AS400)












General

JLCollinsnh - The SImple Path to Wealth

Popular posts from this blog

PF2XLS - Python

Image
Convert Physical File / Table to Spreadsheet (Excel) using Python - Xlsxwriter and send the spreadsheet in IFS folder to email address using SNDSMTPEMM. The method is to connvert PF to csv using CPYTOIMPF in IFS then invoke python script to convert it to spreadsheet. The python script can be invoked using shell script. Now all this can be wrapped into CL. Make a custom command - PF2EXCEL. Thanks to Simon Hutchinson (RPGPGM.COM) for teaching me many things on IBM i. I learnt about shell scripting error handling from his blog. Regarding csv to excel, numerous python blog helped to learn and implement it. :-)    ** The python script i enhanced it to bold the header, add borders to columns and also graphs but missed that code during PDP refresh. But just wanted to hihglight the possibilities with python scripting. --------------------------------------------------------------------------------------------- Source code for PF2EXCEL command PF2EXCEL.sh head -1 /...
Read more

NoSQL on IBM i

Image
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 ‘...
Read more

PROFOUND LOGIC - Web API (Weather App) - Part 3

Image
This blog is about making a web API called to openweathermap.org.  Yes, many have already done this i.e. just from Node.JS console but I wanted to try the same from ProfoundUI screen. I tried many open API's but felt weather app would be a good start. I'm planning to write one with ipconfig.io/json but that's for later.  Create a account with openweather and use the key to access the free current API from program. While Profoundjs has different approach to handle web API but I could not get a grasp of it. I use the traditional Node.JS method to request data . REQUEST module is most popular for making HTTP request. There is HTTP module as well but REQUEST module make it lot easier. The below code submits a HTTP GET request to URL i.e to openweather API and it will return the data i.e. in this can we can opt for HTML or JSON data.  In the below scenario, I have set the JSON:true. The same request can be used for POST, PUT or DELETE. request( URL , function( ...
Read more