Not able to pass a parameter to mail stage in sequencers

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Pavan_Yelugula
Premium Member
Premium Member
Posts: 133
Joined: Tue Nov 23, 2004 11:24 pm
Location: India

Not able to pass a parameter to mail stage in sequencers

Post by Pavan_Yelugula »

hi all
we are not able to pass the parameters to the mail stage in the sequencers it is taking the parameters as hard coded values.

Doesn't mail stage support parameter passing???

it would be very helpful to us if you can send us any round about way for the same.

Thanks and Regards
Pavan
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: Not able to pass a parameter to mail stage in sequencers

Post by chulett »

Pavan_Yelugula wrote:Doesn't mail stage support parameter passing???
Nope. As much as you might think it should, it does not. :?

The 'work around' is to write your own email script that takes parameters in and passes them through to sendmail. Then you can call it using DSExecute in a Routine Activity stage.

Out of curiousity, which bits are you trying to parameterize?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Pavan_Yelugula
Premium Member
Premium Member
Posts: 133
Joined: Tue Nov 23, 2004 11:24 pm
Location: India

Post by Pavan_Yelugula »

:cry:
ohh we are sure in a fix here.

The parameters we are trying to pass are:
The recipent e-mail addresses and the e-mail subject with the country code( a parameter) appended to the message saying countrycode:jobname failed

we hitting around the multiple instance concept so same job is used for different countries and so the country code in front of it will give us a better idea
Pavan_Yelugula
Premium Member
Premium Member
Posts: 133
Joined: Tue Nov 23, 2004 11:24 pm
Location: India

Post by Pavan_Yelugula »

hi all
So now we got to live with the hardcoding in the mail sequencer.

One round about way is to rite a shell script which does the mail functionality and call it using a execute stage in the sequencer

Can you also suggest me if this works.

i have DSSendMail option in basic can i use this command and send in parameters to this by riting it in the job control will this approach work or is there a scenario where even this DSSendMail doesn't accept paramters

Any inputs will be really helpful for us

P.S -> if anyone has implemented this mail functionality in a script .it would be really helpful for us if you can share it with us
Thanks and Regards
Pavan
Post Reply