We have a spufi query job that sends the output to email.
But the formatting of the columns do not line up.
Might there be any spufi output formatting options I could use to correct this?
Hey once again
Might not be the answer you're looking for, but I'm a fan of using Spark to do the whole process. Here's how I like to do it (in the same program)...
- Connect and execute the query
- Transform the resulting RDD into a pandas dataframe
- Format it nicely
- If it applies, spit it out in a pretty looking chart
- If your plotting library can do that, create a jpeg image and include it in the body of the email
- If you want to look fancier, create an html template to put everything together, then at the end of the email body include a link to the page you just automatically generated
** The result is a guaranteed happy manager :)
Javier Estrada Benavides, Czech Republic / Mexico
IBM Champion for Analytics
IBM Certified System Administrator - Db2 12 for z/OS
IBM Db2 12 DBA for z/OS - 2018 (the ugly brown badge from
IBM Open Badge Program)
IBM Certified System Administrator - DB2 11 for z/OS
IBM Certified Database Administrator - DB2 11 DBA for z/OS
Thank you both for your responses and help!
Let me explain further what my situation is.
My site is transitioning off of SMTP because IBM is stopping support. My site is not moving to its replacement CSSMTP. I do not know why. So our z/OS support team wrote their own rexx program that passes messages and attachments to email. However this mainframe program does not accept or pass along any outlook / email formatting parameters. I was hoping to somehow format my SPUFI output on the mainframe in a way that outlook would accept cleanly and not skew the column alignment.
I hope that makes sense.
This works for me.
As SMTP is going away for you, you'd need to change the output destination & the HELO operand.
/*ROUTE PUNCH IBIMVS.SMTP
//MONO EXEC PGM=IEBGENER,REGION=0M
//SYSIN DD DUMMY
//SYSUT2 DD SYSOUT=(B,SMTP)
//SYSUT1 DD DATA,DLM='%%'
MAIL FROM:<[login to unmask email]>
RCPT TO:<[login to unmask email]>
From:<[login to unmask email]>
To:<[login to unmask email]>
Subject: test html/mono font
<pre style="font: monospace">
test 00000000 11111111 AAAAAAAA IIIIIIII @@@@@@@@ ||||||||
test 11111111 00000000 IIIIIIII AAAAAAAA |||||||| @@@@@@@@
//SYSPRINT DD SYSOUT=*
p.s. you can use either the /*ROUTE PUNCH node.smtpserver
or the ,SMTP) operand in the SYSUT2 DDname, using both is overkill, but works too.
Thank you for your response! Yes we were using those formatting commands. But now the problem is this new in-house rexx program treats those commands as text and they are not reformatting the email message.