InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 19:07:23 GMT20http://www.teradata.com/teradataforum/Topic10030-1-1.aspxtttAny solutions for this?Thu, 15 May 2008 09:57:41 GMTSpeedsterZ28http://www.teradata.com/teradataforum/Topic10030-1-1.aspxIs there a way to suppress the transaction count from the Macro?In SQL Server 2000 the command is:Set Nocount onBackground:My client has Teradata Macros that execute multiple SQL commands (such as insert, update, and delete) on Global Temporary tables before selecting the result. The client needs to execute these Macros from various 3rd party applications (Crystal Reports, MS Access, etc). The problem is that Teradata returns an empty recordset for inserts and deletes and many of these apps will return a null or blank recordet to display rather than the real recordset.Thanks in advance.Tue, 11 Dec 2007 15:46:35 GMTwtt2b