Failure 3932 Only an ET or null statement is legal after a DDL Statement.

Database
KVB
Enthusiast

Failure 3932 Only an ET or null statement is legal after a DDL Statement.

Hi

 I am trying to execute the MSR as below.It's throwing error as

 *** Failure 3932 Only an ET or null statement is legal after a DDL Statement.

Could anyone help me in this regard?

bteq <<EOF

..credentials provided here.

create table t

(

id integer

)

;create table t1

(

column1 integer,

column2 varchar(10)

)

;create table t2

(

column1 integer,

column2 varchar(10)

)

;create table t3

(

column1 integer,

column2 varchar(10)

);

EOF

Regards

KVB

3 REPLIES
Enthusiast

Re: Failure 3932 Only an ET or null statement is legal after a DDL Statement.

KVB,

Multistatement requests can only have DML.

check out: SQL Request and Transaction Processing documentation.

If you use seperate statements instead of multistatement request this will run.

Rglass

Enthusiast

Re: Failure 3932 Only an ET or null statement is legal after a DDL Statement.

KVB,

I tried the same way where i am able to run successfully. Let me know how you executed?

 *** Logon successfully completed.

 *** Teradata Database Release is 14.10.04.03

 *** Teradata Database Version is 14.10.04.03

 *** Transaction Semantics are BTET.

 *** Session Character Set Name is 'ASCII'.

 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

 *** Warning: EOF on INPUT stream.

+---------+---------+---------+---------+---------+---------+---------+----

create table dbname.t

(

id integer

)

;

 *** Table has been created.

 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

create table dbname.t1

(

column1 integer,

column2 varchar(10)

)

;

 *** Table has been created.

 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

create table dbname.t2

(

column1 integer,

column2 varchar(10)

)

;

 *** Table has been created.

 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

create table dbname.t3

(

column1 integer,

column2 varchar(10)

);

 *** Table has been created.

 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

 *** Warning: EOF on INPUT stream.

 *** BTEQ exiting due to EOF on stdin.

 *** Exiting BTEQ...

 *** RC (return code) = 0

KVB
Enthusiast

Re: Failure 3932 Only an ET or null statement is legal after a DDL Statement.

I executed like MSR not separately.