Suppressing Row Counts in Stored Procs and Macros

UDA
N/A

Suppressing Row Counts in Stored Procs and Macros

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.

Thanks in advance.

1 REPLY

Re: Suppressing Row Counts in Stored Procs and Macros

ttt

Any solutions for this?