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 !