Nulpalakal - நூல் பல கல்




Nul pala kal (read many books) is a line from Aathichoodi written by Avvaiayar. Aathichoodi has 109 sacred lines written in Tamil alphabetical order.

https://en.wikipedia.org/wiki/Aathichoodi
This is my first blog. Planning to use this blog to share my thoughts about technical books, blogs that I read, also some random thoughts as well.

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

Stock Analysis - Example with Ashok Leyland

Image
Ashok Leyland (AL) is 2nd largest commercial vehicle in India. Disclaimer - The below items are based on personal learning over a few months so I'm not a expert and recommend ppl reading(incase anyone) to do their own research and plunge into share market. This is no way a recommendation page.  Why I'm buying AL shares in (Nov-Dec) '19 ? The current slump is temporary due to economic conditions and Axle /BS VI norms. Also this has resulted in large inventory  in Q3. So I hope to see there will be turn around in March'20.   Earnings Per Share - Net Profit dividend by Number of shares. For example - 2019 Net Profit is Rs.19832000000 / Number of outstanding shares is 2935527000.  Earning Per share is 6.76. What will be share price of AL in 2023 ? My assumption it will be between Rs.197-340 i.e. with average 20% growth year on year. Why averaging at 20% - One year it can go as high as 30% and other year at 10% . With mSME picking up volu...
Read more

Python on IBM i

Image
Python on IBM i has been around for many years now but only few are using it. In most banking application, using open source language is not allowed. So though we are able to run some basic programs on pyton/Node.js we do not get to install/use all the modules. ITjungle has many articles on iseriespython. I assume earler it had to installed but with V7R1 i assume it comes pre-installed. On IBM i, 5733-OPS placeholder for open source technologies contains python,Node.js. Thanks to Aaron Bartell, litmis spaces for providing the platform for learning. Litmis spaces is hosting IBM i on cloud and provides single tenant for free. You can also try out pub400.com which is a free server. Open the Qshell with QSH  from command line and to identify the location of python runtime type below command - $which python3 /QOpenSys/usr/bin/python3 Python3 does not reside here but a symbolic representation. The original location /QOpenSys/QIBM/ProdData/OPS/Python3.4/bin/python3. $python3 ...
Read more