Home > IT Answers > AS/400 > How to send email through RPG IV or CL?
22917
510 pts.
 How to send email through RPG IV or CL?
AS/400 email, AS/400 Spool Files, CL programs, RPG IV, Spool files
[strong]I need to send my spool file thru  email [/strong]

Software/Hardware used:
AS400
ASKED: April 19, 2011  11:11 AM
UPDATED: May 2, 2011  11:08 PM
RELATED QUESTIONS
Answer Wiki:
Here is a link to a similiar question ask on this website. http://itknowledgeexchange.techtarget.com/itanswers/is-it-possible-to-get-a-pdf-from-as400-spool-file/ Also here is a link to freeware that includes commads to do just what you want. http://www.help400.de/Eng/Freeware.htm
Last Wiki Answer Submitted:  April 19, 2011  3:51 pm  by  CharlieBrowne   33,730 pts.
All Answer Wiki Contributors:  CharlieBrowne   33,730 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 


I have done certain things.I hv listed out those things.

1.Adddire-I have added me in distribution list-user id – “Govindas “ and address – “BWIR”
2.In iseries navigator-I hv created new folder in Root directory-“Govindasas” and in QDLS – “GOVINDAS”
3.Crtpf-I hv copied one spool file to a flatfile named-“FLATF”
4.CPYSPLF-copied my spool file “QPSUPRTF” to my “flatf”

5.CPYTOIMPF-I hv shown the screen –value which I entered …
From file:
File . . . . . . . . . . . . . > FLATF Name
Library . . . . . . . . . . > GOVINDASAS Name, *LIBL, *CURLIB
Member . . . . . . . . . . . . *FIRST Name, *FIRST
To data base file:
File . . . . . . . . . . . . . Name
Library . . . . . . . . . . *LIBL Name, *LIBL, *CURLIB
Member . . . . . . . . . . . . *FIRST Name, *FIRST
To stream file . . . . . . . . . > qdls/GOVINDAS/splf1    this is the folder which I created in iseries navigator

Replace or add records . . . . . *ADD *ADD, *REPLACE
Stream file code page . . . . . > *PCASCII 1-32767, *STMF, *PCASCII…
Record delimiter . . . . . . . . > *CRLF Character value, *EOR…
Record format of import file . . *DLM *DLM, *FIXED
String delimiter . . . . . . . . ‘”‘ Character value, *NONE
Field delimiter . . . . . . . . ‘,’ Character value
More…

6.i am getting the flatf(Spool file) in IFS-new folder which I created.
Is ther still anything I missed out…
7.snddst used,its not working

Next wt I hv to do…

22917
 510 pts.
 

Are you getting an error message with the SNDDST?
What is your joblog showing?

CharlieBrowne
 33,730 pts.
 

Has your system been configured for e-mail? Is the SNA to SMTP bridge configured? Is the SMTP server running?

One minor note:

5.CPYTOIMPF

You probably should be using CPYTOSTMF instead of CPYTOIMPF. The CPYTOIMPF command is intended for database exports, but you are only copying a ‘flat’ file.

Tom

TomLiotta
 110,135 pts.
 

Both Gumbo Software and BVS Tools offer reasonably priced software for the IBM i that does exactly what you need. We have used both tools for many years with good results. In fact, most of our nightly reports are delivered as PDF attachments to e-mail generated with these products directly on the IBM i.

(I have not affiliation with either company. Just a satisfied user).

WoodEngineer
 5,570 pts.