All Forums Database
KVB 124 posts Joined 09/12
20 Mar 2015
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

Glass 225 posts Joined 04/10
20 Mar 2015

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

ravimans 54 posts Joined 02/14
20 Mar 2015

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 124 posts Joined 09/12
22 Mar 2015

I executed like MSR not separately.

You must sign in to leave a comment.