DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Arun86
Participant



Joined: 11 Oct 2009
Posts: 7
Location: chennai
Points: 96

Post Posted: Tue May 15, 2012 11:23 pm Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Server
OS: Unix
Additional info: Notification Stage- Email Body
I am using a DS 7.5 Server job, which extracts the Batch name,Status,Batch Start time and End time details from the audit table.

Extracted batch details are loaded into the csv file and the notification stage is used to distribute the batch status report csv as an attachment.


I would like to attach the extracted batch details in the email body instead of attachment in notification stage to distribute the batch report.

Can anyone please help me to achieve this.

Thanks
Arun
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 49959
Location: Canberra, Australia
Points: 271512

Post Posted: Wed May 16, 2012 12:32 am Reply with quote    Back to top    

Take a look at the sample code Routines\Built-In\Utilities\DSSendMailTester and DSSentMailAttachmentTester to find out how to use a routine. You could invoke this routine from a Transformer stage or, ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong
Delivering Outcomes Together
Rate this response:  
Not yet rated
vamsi.4a6
Participant



Joined: 22 Jan 2012
Posts: 234

Points: 2008

Post Posted: Wed May 16, 2012 12:41 am Reply with quote    Back to top    

I do not know what i need to mention for SMTPServer?I know what is meant by SMTP Server.where to get SMTP Server details?
Rate this response:  
Not yet rated
arvind_ds
Participant



Joined: 16 Aug 2007
Posts: 360
Location: Manali
Points: 2803

Post Posted: Wed May 16, 2012 3:28 am Reply with quote    Back to top    

Get in touch with unix administrator in your organization to get SMTP details.

_________________
Arvind
Rate this response:  
Not yet rated
vamsi.4a6
Participant



Joined: 22 Jan 2012
Posts: 234

Points: 2008

Post Posted: Wed May 16, 2012 3:34 am Reply with quote    Back to top    

Just want to know Is there any unix command to get SMTP server name instead of asking unix administrator.I am developer
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 36601
Location: Denver, CO
Points: 186567

Post Posted: Fri May 18, 2012 10:55 pm Reply with quote    Back to top    

You don't need to populate the SMTP server property.

_________________
-craig

It's a scheme of devices to get at low prices all goods from cough mixtures to cables
Which tickled the sailors by treating retailers as though they were all veg-e-tables
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours