Email file from iseries

The above command will just include the field name in the excel as a coloumn heading. If you like to add a different meaningful heading, then follow the below steps. Need to capture jobname, worstation and number in the CL. Step copy the flat or dds file into CSV. It may require to exclude headings and certain heading. So use a query or a rpgoram to exclude certain lines from the spool file before if needed.

You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account. If you think about it, outgoing and incoming mail are opposite sides of the same coin. Ultimately, a destination server receives the message and stores it in a mailbox to wait for the user to pick it up.

All these roles use SMTP for at least part of the job. An MUA is the software that sits in front of the user. Because e-mail is supposed to be reliable. If the first attempt fails, the MUA should retry at regular intervals. So the MUA needs a server that it trusts to hand the message to. Then, that server can queue the mail up and retry it if necessary.

In other words, it either sends it to the destination or queues it up and retries later. Often, companies configure their MTAs to scan messages for viruses and spam in addition to relaying and requeuing the messages. MDAs sometimes also do virus or spam checking. Ultimately, they put the message in the mailbox, and at that point, the SMTP process is finished.

MUA software designed to run on the server itself might directly access the mailbox that the MDA saved the mail in so that it can display the message to the server. In fact, in one article, I even demonstrated how to use sockets to send an e-mail message. To use it, you call a routine that creates an SMTP handle which is really a temporary area of memory used to keep track of the state of the SMTP session , and you pass it to subprocedures that carry out the same SMTP commands typed in the Telnet session.

This code connects to an SMTP server at smtp. There are other ways to provide that SMTP data, but more about that later. After the sample program runs, the same commands that you saw during the Telnet session will be visible in your job log. That way, if something does go wrong, the job log shows exactly what happened. While writing this utility, I thought about all the existing programs that I have e.

For example, consider the following code that calls QtmmSendMail :. To convert the preceding code to use my new utility, all I have to do is change the name of the API it calls, as follows:. And then, of course, I have to re-create the program and bind it to my SMTP service program so that it can use the new subprocedure.

Because these changes are relatively minor, upgrading my programs is easy. Also it needs to be mentioned that if no spool number is provided in the command, the last spool file of the job this is useful in batch processing will be sent. Thanks to Manouchehr for sharing his utility with us. I know that e-mailing from the System i can be a challenge at times, so I was glad to pass his code along to the readers.

Post this story to del. Sponsored by ProData. IBM i software to help you navigate your universe! Use these tools to get where you are going: DBU to easily, yet securely, access the data on your IBM i or remote system.

RDR retrieves those records which were deleted in error. And more!