I have a job that queries tables and writes the records in a dataset with HTML tags. This file will be used to send a report attached with an email. The problem is, if the file created exceeds the mail delivery size, the email delivery fails. Please help me with in emailing the attachment after zipping the file.
Joined: 26 Apr 2004 Posts: 4650 Location: Raleigh, NC, USA
OK, but you haven't given us much detail for what you need help with. My suggestion is to forget about email (that's NOT really a good data exchange protocol, for the reason you already stated) and use some other method.
I thought I'd also add that there are plenty of existing topics for just about every aspect of this question: topics on using SMTP, MIME, PKZIP, gzip, tar, infozip, ZIP/390, and others.
The data is already available in our tables. I could prepare the report manually and send it across. We wanted to automate this process. So FTP will not be of any help to me.
The problem is the limitation with the size of all the files attached to the mail. So creating multiple files to attach to the same email will again fail. This is the reason for looking at options of attaching the zipped excel file. Please assist whether this can be accomplished.
Joined: 06 Jun 2008 Posts: 8212 Location: Dubuque, Iowa, USA
Has your site purchased and installed a mainframe ZIP package already? If not, be aware that zip packages are not free on the mainframe and can get pretty expensive -- both in price and in resource consumption.
I also note that you do not say if the limit is your TCP/IP stack limitation on sending or your email client limit or your email server limit -- if the mainframe TCP/IP MAXMAILBYTES parameter needs to be changed, that requires your site support group to change it, recycle TCP/IP (or use OBEYFILE), and then the new limit applies.
You have several options:
1. Change the email size limit and send the files as is
2. Forget sending these large emails
3. Purchase a ZIP package, install it, and use it before sending the email
4. Install SMB to allow the PC to directly pick up the file off the network
5. Transfer the data to Unix System Services and run pax against it, then transfer the pax file
6. Install gzip / gunzip (open source zip) on Unix System Services and use it to zip files before sending them