Archives of the TeradataForum

Message Posted: Thu, 25 Nov 2010 @ 10:20:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

If I run the following in BTEQ I get the error "Failure 3932 Only an ET or null statement is legal after a DDL Statement."

     create table test1
     (
     cola char(1)
     )
     ;create table test2
     (
     cola char(1)
     )
     ;

If I run the above through SQL Assistant using Tools > Execute Parallel I get the same error.

If I run the above through SQL Assistant using Tools > Execute I do not get an error, but in this case it is not running as a multi-statement request.

The rule for transactions, and a multi-statement request is a transaction, is that DDL statements can ONLY be the last statement in a transaction.

It would appear to me that what you were executing was NOT a multi-statement request.

However, this does not get to the issue of why it fails. It just clarifiys that what you are running is not a multi-statement request.

Robert Meunier

	<Prev	Next>		<<First	<Prev	Next>	Last>>