sending mail from a param file in datastage

[pragb]

Hello All,

I am having issue in sending mail notification through datastage.

the design of my sequence is as follows

execute command stage-----User variables_Activity---Notification activity

In execute command stage I am trying to read the param file through cat command,the file consists of few email addresses,I need to send mails to them If my job aborts.

But I am struggling to pass proper email addresses in the receiver's list in the notification activity.In the user variable activity stage I have used Oconv function but that is not giving me the desired result.

Can you please suggest what else I can try?

Many thanks in advance.

Regards,
Pragb

[ankursaxena.2003]

Use the following code in User Variable Activity will get all the email address in the Email_List User Variable

UserVariables_Activity_89
Email_List : Field(Convert(@FM, "", ExecCommand.$CommandOutput),'',1)

And then in the Mail Notification activity in the Recipient Email Address write the following code:

#UserVariables_Activity_89.Email_List#

[bhasds]

Hi Pragb,

To get rid of this problem you can use the tr -d '\n' command in execute command activity. For example, if you are using the command cat filename in execute command then it should be-

Code: Select all

cat filename | tr -d '\n'

Now the output from the execute command should wok fine for the notification activity.

[ray.wurlod]

That's what converting @FM to "" achieves.

[pragb]

Hi,

This is resolved.

Many thanks

Pragb