Archives of the TeradataForum
Message Posted: Wed, 17 Nov 2004 @ 20:55:03 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|