Unix Programming - perl script to read data from database and generate a mail in HTML(in a particular fo

Author

perl script to read data from database and generate a mail in HTML(in a particular fo

2006-12-27, 7:21 pm

Hi all,

I want to write a PERL script to read data from the database and
generate a mail in HTML...

The database contains following data:

CheckName SubSectionName LastComment

------------ -----------------
------------------------------------------------------------------------
abc-ODC DS SUCCESS::82::/home/ade/hfgf/kfhf/

abc-ODC DS SUCCESS::82::/home/ade/hfgf/kfhf/data/

abc-ODC PS ERROR::82:://home/ade/hfgf/kfhf/logs/

def-Pri DS SUCCESS::82::/home/archive/

def-Pri PS SUCCESS::FILE NOT FOUND

Mail format should be :

abc-ODC
----------------
DS
SUCCESS::82::/home/ade/hfgf/kfhf/
SUCCESS::82::/home/ade/hfgf/kfhf/data/

PS
ERROR::82:://home/ade/hfgf/kfhf/logs/

def-Pri
------------
DS
SUCCESS::82::/home/archive/

PS
SUCCESS::FILE NOT FOUND

Thanks,
Nitika