Sequence job

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
SUMAN CHILUVURI
Premium Member
Premium Member
Posts: 19
Joined: Fri Oct 15, 2010 1:26 pm

Sequence job

Post by SUMAN CHILUVURI »

How to print the data in a file in the email body using datastage sequence stages ?
suman Datastage Developer
vinothkumar
Participant
Posts: 342
Joined: Tue Nov 04, 2008 10:38 am
Location: Chennai, India

Post by vinothkumar »

You can do that only through unix script. Through DataStage you cant
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

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

"You can never have too many knives" -- Logan Nine Fingers
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: Sequence job

Post 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.
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Or DSSendMailTester as well, also check their source code which can be copied and adjusted to your need.
-craig

"You can never have too many knives" -- Logan Nine Fingers
bobyon
Premium Member
Premium Member
Posts: 200
Joined: Tue Mar 02, 2004 10:25 am
Location: Salisbury, NC

Post by bobyon »

ray.wurlod wrote:Search DSXchange for DSSendMail to learn how to do it.
Oh Yippee. Only 326 results to look through. :-)
Bob
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Only 52 if you restrict the author to Ray. Technically 51 as this one doesn't count. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply