Call DSExecute

[chowdary]

Hi

I am using this function in one of my routine to send an email with an attachment "Call DSExecute(ShellType, Command, Output, SystemReturnCode)"

this is my syntax in the routine

Call DSExecute("UNIX",'/usr/bin/uuencode filename filename|/usr/bin/mailx -s "SUBJECT" "you@you.com,me@me.com"','Output','SystemReturnCode')

when i hardcoded the file name and email address everything is working fine, but when i try to pass filename and email address as arguments it is not sending the email.

I am using DataStage 7.1

Is there any way to pass the filename and email address as parameters.

Please throw some suggestions.

[kcbland]

The problem is a common one. The issue is that your command is being stripped of the double quotes. The DSExecute API has issues when you try to do what you're doing.

The recommendation is to use a shell script that does all of the steps that you need, with the variable information passed as arguments to the script. Worst case, write the arguments to a text file and use indirection to feed the arguments to the script.

[chowdary]

Thanks for the reply, I can't use the Shell Script due to some internal problems (as the unix stuff maintained by some other group). They want to do with in the DataStage with out using Shell Script.

I am wondering is there any way to solve this problem with out using the Shell Script.Please throw some suggestions.

[kcbland]

Worst case, write the arguments to a text file and use indirection to feed the arguments to the script.