|
View previous topic :: View next topic
|
| Author |
Message |
RAJANENI
New User
Joined: 19 Feb 2010
Posts: 2
Location: Chennai
|
|
|
|
| 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. |
|
| Back to top |
|
 |
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
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.
Edited:
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. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
If it is too big, well, it is too big. . . I don't believe we can get around the size limit on your system.
You might consider creating multiple files to "attach" to an e-mail or you might consider sending the data via ftp. |
|
| Back to top |
|
|
RAJANENI
New User
Joined: 19 Feb 2010
Posts: 2
Location: Chennai
|
|
|
|
Hi
Thanks for the prompt reply.
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. |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8697
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 |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| So creating multiple files to attach to the same email will again fail. |
Not if you send multiple e-mails with something less that the limit attached to each. . .
| Quote: |
| So FTP will not be of any help to me. |
Sorry, but that makes no sense. . . If you can send the "stuff" as an attachment or in the body of an e-mail and call it "automated", sending the same "stuff" via ftp would also be automated. . .
Possibly, there is something i misunderstand. |
|
| Back to top |
|
|
|
|
