|
|
Archives of the TeradataForum
Message Posted: Mon, 26 Nov 2007 @ 23:59:36 GMT
Subj: | | Re: Statistics in BT; ET; |
|
From: | | Fields, Dave A |
The problem is that any DDL statement within a transaction must be the *last* statement in the transaction. In your example, COLLECT STATS,
which is a DDL statement, isn't the last statement in the transaction, so you're getting an error.
COLLECT STATS is being changed to be a DML statement in either 13.0 or 13.1 just because of the sort of application you're talking about.
| |