|
|
Archives of the TeradataForum
Message Posted: Mon, 01 Aug 2005 @ 20:00:01 GMT
Subj: | | Collect Stats in a Procedure |
|
From: | | Srikanth Goli |
Can we invoke a maco from a stored procedure? I delete and load rows into a table in a procedure. Then I need to collect stats on the table,
before I execute other statements in the procedure. I thought, I could not collect stats in a procedure, so I created a macro. But now, I realize
I cannot invoke the macro from the procedure either. Wondering how other users achieve this (Collect stats on a table in a procedure) ?
Thanks for your help !
| |