Channel failure - Number of unsent leads

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Channel failure - Number of unsent leads

Rate Topic

Display Mode

Topic Options

Author

Message

judy

Posted 10/30/2007 9:05:24 PM

Forum Newbie

Group: Forum Members
Last Login: 1/17/2008 4:02:58 AM
Posts: 3, Visits: 4

If TCRM channel process fails we'd like to be able to log which communications are affected and the estimated number of leads that have not been sent for each of the communications as a result.
Has anybody got any advice on the best way of doing this?

Post #9548

wannabGURU

Posted 1/4/2008 1:42:21 AM

Forum Newbie

Group: Forum Members
Last Login: 1/4/2008 1:32:24 AM
Posts: 4, Visits: 2

SQL is the answer. Create a macro that takes in the channel ID as a parameter and joins all the necessary tables to retrieve whatever it is you want. You'll need extensive IOS knowledge to be able to do that. For help with understanding what field is referenced where, visit this link
http://forrit.dk/teradata/ and download Teradata QuickSearch. Great tool!

Post #10160

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 10:15pm