Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Multi statement code stops before completion
 
From:   Robert Meunier

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023