DSXchange

The language is DataStage BASIC, not C. Therefore you must use BASIC-style comments, not C-style comments. The "/*" characters are the immediate cause of your failure to compile.

"Not working" is meaningless.

Is it compiling (which is the only thing I addressed)?

What do you want the routine to do, what is it producing (if anything)? What is appearing in the log (or in the Results window in the test grid)?

Routine is compiling successfully but unable to send mail.

roopanwita - put in PRINT statements to see if you get valid values for your calls, i.e. print out FROM_MAILID, TO_MAILID, and the evaluation of the parameter to DSSendMail.

Calls to DSLogInfo() will serve in place of PRINT statements.

It is throwing error ,while compiling - "3 Errors detected, No Object Code Produced."

You cannot modify input arguments. At the beginning of your job, add

TempFROM_MAILID = FROM_MAILID
TempTO_MAILID = TO_MAILID
TempSUBJECT = SUBJECT

and use the Temp... variables in your job.

With modified value of TO_MAILID & FROM_MAILID (as u mentioned to define as TempTO_MAILID) , the routine is running for long time and unable to send mail msg.

Add
MailCommand = "From:":FROM_MAILID:"\nTo:":TO_MAILID:"\nSubject:":SUBJECT:"\nBody:"

and then PRINT or Call DSLogInfo() of the MailCommand variable. What do you get?

It's DataStage BASIC, not a shell script. Comments do not begin with "#" in DataStage BASIC.

Comments in DataStage BASIC can be specified in three ways:

• a statement beginning with "*" and containing at least one space
  a statement beginning with "!" and containing at least one space
  a statement beginning with "REM" and containing at least one space

I should have caught that. I just looked at the error message, not the red text to see what actually caused it. I need glasses...

Would your glasses be half full or half empty?

My glass is half full, if I could find it...