Archives of the TeradataForum

Message Posted: Thu, 03 Feb 2005 @ 10:00:10 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

It seems there is a DR raised for this problem. Its DR 87815.

We are on Release 05.00.03.29 and need to have a patch installed to overcome this problem.

The problem in our case was that it Redistributed a table when using Queryman ODBC.

And when the same query was used in a macro, the Table (2 GB)inside a Derived Table, got duplicated on all 104 AMPs and had to work 104 times.

     ----------------------------------------------------------------
     DR 87815 All DT in a session gets spooled when a macro using DT
              and system function is executed
     ----------------------------------------------------------------

Regards

ROHIT

	<Prev	Next>		<<First	<Prev	Next>	Last>>