How to COLLECT STATS in BTET Mode in Multi-Statement BTEQ Scripts!

Tools
Enthusiast

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.

BT;
Update....;
ET;

BT;
COLLECT STATS...;
ET;

BT;
DELETE....;
ET;

Help please!!!!!!!!!
2 REPLIES
Senior Apprentice

Re: How to COLLECT STATS in BTET Mode in Multi-Statement BTEQ Scripts!

In BTEQ there's no need to use BT/ET for a multistatement, because it's already a transaction.

COLLECT STATS is considered as a DDL statement, thus it's not allowed within a multistatement unless it's the last statement.

There's no way to bypass that restriction.

"Also the below process throwing the error."
Which error? This is supposed to run.

Dieter
Enthusiast

Re: How to COLLECT STATS in BTET Mode in Multi-Statement BTEQ Scripts!

Yeah - we need to use an ET after COLLECT STATS
that's working fine....
there is no error in the last statement...
thanks Dieter...