|
|
|
Forum Member
 
Group: Forum Members
Last Login: 10/30/2009 6:28:19 AM
Posts: 34,
Visits: 117
|
|
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!!!!!!!!!
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/5/2009 4:40:02 PM
Posts: 717,
Visits: 466
|
|
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
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/30/2009 6:28:19 AM
Posts: 34,
Visits: 117
|
|
Yeah - we need to use an ET after COLLECT STATS
that's working fine....
there is no error in the last statement...
thanks Dieter...
|
|
|
|