|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/8/2008 2:06:58 PM
Posts: 1,
Visits: 7
|
|
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.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 7/30/2008 10:31:41 AM
Posts: 4,
Visits: 6
|
|
ttt
Any solutions for this?
|
|
|
|