Parameter substitution in e-mail notification

[Seyed]

All,
I have put in several e-mail notification activities in a job sequence. They work fine and generate e-mail under certain conditions. However, I have noticed that the e-mail notifications have problems with parameter substitutions. The parameter substitutions work correctly in the subject line of the notification, but fail to substitute parameter with the passed value in the body of the e-mail.

Here is the code

Subject line:

Code: Select all

[DS - Testing] Input file [#IFN_01#] is NOT Available!

E-mail Body:

Code: Select all

The DataStage job Seq_Load_Layer1_A failed. Please make sure that the input file [#IFN_01#] is available within the allocated wait time.

Here is the result in e-mail

Subject line:

Code: Select all

[DS - Testing] Input file [WFCSNCP_G6_TEST12.txt] is NOT Available!

E-mail Body:

Code: Select all

The DataStage job Seq_Load_Layer1_A failed. Please make sure that the input file [#IFN_01#] is available within the allocated wait time.

Should the parameter substitution be working in the body of the e-mail just like the subject line? My goal was to assign a file name to IFN_01 and have its assigned value be passed to both subject line and body of the e-mail.


Thank you,


Seyed

[kandyshandy]

In the body of the email, DS does not substitute parameter with its value.

[Seyed]

In the body of the email, DS does not substitute parameter with its value.

Hello kandyshandy,
Thank you very much for the information. I won't spend any more time on this issue. I will just hard code the file name in the body of the e-mail.

Continued Success,

Seyed

[JRodriguez]

Would you like a second opinion?

Take a look at DSSendMail routine ..