Capturing part of job log using routine

ray.wurlod · Post by **ray.wurlod** » Tue Jun 03, 2008 11:59 pm

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.

Roopanwita · Post by **Roopanwita** » Wed Jun 04, 2008 12:26 am

ray.wurlod · Post by **ray.wurlod** » Wed Jun 04, 2008 1:21 am

"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)?

Roopanwita · Post by **Roopanwita** » Wed Jun 04, 2008 1:23 am

Routine is compiling successfully but unable to send mail.

ArndW · Post by **ArndW** » Wed Jun 04, 2008 1:26 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 04, 2008 1:30 am

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

Roopanwita · Post by **Roopanwita** » Wed Jun 04, 2008 3:31 am

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

ArndW · Post by **ArndW** » Wed Jun 04, 2008 3:41 am

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.

Roopanwita · Post by **Roopanwita** » Wed Jun 04, 2008 5:59 am

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.

ArndW · Post by **ArndW** » Wed Jun 04, 2008 6:30 am

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?

ray.wurlod · Post by **ray.wurlod** » Wed Jun 04, 2008 6:50 am

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

ArndW · Post by **ArndW** » Wed Jun 04, 2008 7:10 am

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...

ray.wurlod · Post by **ray.wurlod** » Wed Jun 04, 2008 3:07 pm

Would your glasses be half full or half empty?

ArndW · Post by **ArndW** » Thu Jun 05, 2008 1:10 am

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

DSXchange

Capturing part of job log using routine

Failure to Compile