DSXchange

Hi All,

Here My ETL Design is somthing like this.

Source_Tbl, Limit_Tbl, Transformer ----frm Transforer to Seq_file

Source_Tble ----------------------- I will get the Source,
Limit_Tbl ---- have Min_Limit, and Max_Limit for the Source

I want to get an email these details : Source_Count, Min_Limit and Max_Limit Details as Email Body !!


Pls advise me on this

Thanks,

John

Create a routine that invokes DSSendMail().

Would you please help me to create a routine ............

Pls send me the code for creating routine....to invoke DSSendMail()

Looking for your kind help in this

Thanks,

John

There's a few examples to be found if you Search DSXchange.

There's also a couple of examples (e.g. DSSendMailTester) supplied with the product.

John Daniel wrote:... as Email Body !!

Just as an FYI, that alone forces you down the routine path. Without it, you could leverage the Email Notification stage in a Sequence job.

Thanks for your inputs !!

It would be better if you provide the code for routine !!

How can I get these 3 columns (Source_count, Min_limit and Max_Limit) data into a mail notifications.

Please advise

Thanks,

John

No, it would be a much better learning experience if you manage this on your own... with some guidance, of course.

First order of business would be to capture or store the information you need to send, say like a flat file or the USERSTATUS area of a job. Have you done that?

chulett wrote:No, it would be a much better learning experience if you manage this on your own... with some guidance, of course.

First order of business would be to capture or store the information you need to send, say like a flat file or the USERSTATUS area of a job. Have you done that?

I have done this part 'stored the three valuse in a sequential file'.

After wht should I do ?? Pls guide me in this

Thanks,

John

Look at the source code for the DSSendMailTester routine, you'll need to copy and tweak it to fit your purposes. Depending on how you populated it, the data in the flat file could be retrieved using 'cat' at the O/S level or a job could read it. You'll need to combine that with whatever other text you need and send it to your new routine as the email body.

Or save yourself a lot of work - use the Email Notification stage in a Sequence job and simply attach the file.