As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
However it has been supported in Data Migrator for a long time and I have seen cases of it working in WF 7.1.x .
AS a DM server is exactly the same as a WF server it should be OK.
7.7.0.2 Documentation is limited to
quote:
Using EDAMAIL, the user can send an e-mail from a procedure with a File Content or an Attachment. To add multiple e-mail recipients, just add a semi colon ( in-between each e-mail recipients address. For example: johnsmith@jpl.com;johndoe@nro.com
The syntax is: EX EDAMAIL to, from, subject, [flag], filetype, data
Where: to - Is the e-mail recipient. from - Is the e-mail sender. subject - Is the e-mail subject. flag - If flag is set to "a", the file is sent as an attachment. Otherwise, it is included in the body of the e-mail. filetype - Defines the data type, such as MASTER, FOCEXEC, and HTML. data - Is the data or [app/]filename with the mail content.
It is possible that the filetype, parameter may not be needed. If you want multiple to addresses put ; between them. If you want multiple attachments put ; between them.
I do use the edamail function sometimes, but reportcaster gives you many more functionality like Bursting Scheduling different and mixed output formats logging of the results
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006
This is great news... ( but I can't find in the help ?!! )
That's because there is none. The only documentation I can find is the 7.7.0.2 NF documentation posted above repeated here
7.7.0.2 Documentation is limited to
quote:
Using EDAMAIL, the user can send an e-mail from a procedure with a File Content or an Attachment. To add multiple e-mail recipients, just add a ; in-between each e-mail recipients address. For example: johnsmith@jpl.com;johndoe@nro.com
The syntax is: EX EDAMAIL to, from, subject, [flag], filetype, data
Where: to - Is the e-mail recipient. from - Is the e-mail sender. subject - Is the e-mail subject. flag - If flag is set to "a", the file is sent as an attachment. Otherwise, it is included in the body of the e-mail. filetype - Defines the data type, such as MASTER, FOCEXEC, and HTML. data - Is the data or [app/]filename with the mail content.
ABT, thanks for the pointer. Dave, Vinay: Went on the WFRS and into General, email settings. Entered my smtp host and sender. I then created a simple fex with the car file. The contents of the report did show in my email. I have yet to get an attachment to work though. Done in (wf) 7611 (aix platform-5312)
TABLE FILE CAR PRINT COUNTRY
ON TABLE HOLD AS JUNK7 FORMAT ALPHA
END
-RUN
EX EDAMAIL aaa.bbb, ccc.,ddd, ira testing it, a,ftm,ibisamp/junk7.ftm
Originally posted by ira: ABT, thanks for the pointer. Dave, Vinay: Went on the WFRS and into General, email settings. Entered my smtp host and sender. I then created a simple fex with the car file. The contents of the report did show in my email. I have yet to get an attachment to work though. Done in (wf) 7611 (aix platform-5312)
TABLE FILE CAR PRINT COUNTRY
ON TABLE HOLD AS JUNK7 FORMAT ALPHA
END
-RUN
EX EDAMAIL aaa.bbb, ccc.,ddd, ira testing it, a,ftm,ibisamp/junk7.ftm
Ira
Ira, i have made the settings in WFRS!
I used the same code which you have mentioned above, still not working.
The error is (FOC1562) EDAMAIL: FILE fmt NOT FOUND
WebFOCUS 7.6.4, Mainframe Focus Windows XP, All Output Formats
EX EDAMAIL to, from, subject, [flag], filetype, data
This works
TABLE FILE CAR PRINT COUNTRY CAR MODEL DCOST ON TABLE HOLD AS MAIL_FILE FORMAT EXL2K END -RUN -MRNOEDIT EX EDAMAIL myemail@edamail.com, , edamail test,A,XHT,mail_file
Note the lack of spaces for the last 3 parameters and also NO .xht on the file name
EX EDAMAIL to, from, subject, [flag], filetype, data
This works
TABLE FILE CAR PRINT COUNTRY CAR MODEL DCOST ON TABLE HOLD AS MAIL_FILE FORMAT EXL2K END -RUN -MRNOEDIT EX EDAMAIL myemail@edamail.com, , edamail test,A,XHT,mail_file
Note the lack of spaces for the last 3 parameters and also NO .xht on the file name
Done via MRE hence the need for the -MRNOEDIT
JG, (FOC1562) EDAMAIL: FILE XHT NOT FOUND.
I haven't put .XHT on the file name, but still i am getting the same error!
WebFOCUS 7.6.4, Mainframe Focus Windows XP, All Output Formats