InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:44:12 GMT20http://www.teradata.com/teradataforum/Topic9548-6-1.aspxSQL 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!Fri, 04 Jan 2008 01:42:21 GMTwannabGURUhttp://www.teradata.com/teradataforum/Topic9548-6-1.aspxIf 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?Tue, 30 Oct 2007 21:05:24 GMTjudy