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

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

LISTAGG() - Built function - My recent favorite

Image
The LISTAGG function aggregates a set of string elements into one string by concatenating the strings. Optionally, a separator string can be provided which is inserted between contiguous input strings. Table results - "Select * from Animals" Table results with LISTAGG() - SELECT SP_GROUP, SUB_GROUP,  LISTAGG(rtrim(NAME),',')  WITHIN    GROUP(ORDER BY NAME)  FROM animals  GROUP BY SP_GROUP, SUB_GROUP This function will be a great help in providing a easy to read reports to users.
Read more