Is there a way to suppress the transaction count from the Macro?
In SQL Server 2000 the command is:
Set Nocount on
Background: 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.