Page 1 of 1

Sequence job

Posted: Mon Jun 24, 2013 3:34 pm
by SUMAN CHILUVURI
How to print the data in a file in the email body using datastage sequence stages ?

Posted: Mon Jun 24, 2013 3:41 pm
by vinothkumar
You can do that only through unix script. Through DataStage you cant

Posted: Mon Jun 24, 2013 4:42 pm
by chulett
You can't with DataStage out of the box, true. A script is not the only solution however, a custom routine could be written to do this.

Re: Sequence job

Posted: Mon Jun 24, 2013 5:07 pm
by SURA
Is it the first line or last line?

There are lot of ways to do that. As said scripts / any other language etc. If you are not familiar, then you can do it using a job in the flow of that sequence.

Posted: Mon Jun 24, 2013 10:52 pm
by ray.wurlod
chulett wrote:You can't with DataStage out of the box, true. A script is not the only solution however, a custom routine could be written to do this.
Search DSXchange for DSSendMail to learn how to do it.

Posted: Mon Jun 24, 2013 11:14 pm
by chulett
Or DSSendMailTester as well, also check their source code which can be copied and adjusted to your need.

Posted: Fri Oct 04, 2013 1:06 pm
by bobyon
ray.wurlod wrote:Search DSXchange for DSSendMail to learn how to do it.
Oh Yippee. Only 326 results to look through. :-)

Posted: Fri Oct 04, 2013 1:10 pm
by chulett
Only 52 if you restrict the author to Ray. Technically 51 as this one doesn't count. :wink: