How to COLLECT STATS in BTET Mode in Multi-Statement BTEQ Scripts!
I need to COLLECT STATS after an Update Statement.
BT ; Update Table ; COLLECT STATS ; Delete ; ET;
I've to use BT; ET; as a Multi-statement request in my BTEQ scripts. But I'm getting Error - as DDL statement (COLLECT STATS) can't allowed in Multi-statement request. Also DDL statement (COLLECT STATS) has to be the last statement of the script.
How should I use COLLECT STATS inside a Multi-statement request using BTET? Also the below process throwing the error.