Capturing Help stats result

Tools & Utilities
Enthusiast

Capturing Help stats result

Hi
My requirement is to do collect stats on a particular table once in 1 week....
For that i want to check when was last stats done.....
So that i can run confirm from help stats that when was last stats done and use something like:
.IF MAX(DATE) >= CURRENT_DATE-6... goto nostats.
else gotostas....
Please provide me some way to capture results of HELP STATS .........
1 REPLY
Junior Contributor

Re: Capturing Help stats result

Instead of capturing HELP STATS output you might extract that date from some dbc tables.
You'll find a query extracting some info about collectet stats at:

http://www.teradataforum.com/attach.htm
"New version of statistics query"

Dieter