Archives of the TeradataForum

Message Posted: Wed, 17 Nov 2004 @ 20:55:03 GMT

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

Basically, as the others have indicated, you cannot do this in a macro.

As a cheesy work-around (beware...this solution has its own set of associated risks) you can insert into a physical table (versus a global temp) with a user_id column and pre-seeded statistics. For instance, build your physical table, load it with a demographically representative batch of data, collect stats, delete data. For this point forward, your macro can insert into this physical table.

In this case, fake stats may be better than no stats (if you pre-seeded stats are truly representative of the data) and are 100% better than stats collected on an empty table.

Hope this helps,

Clay

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