Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

SQL Script multiple statements in Teradata connection

Solved!
cronos003
Level 2
SQL Script multiple statements in Teradata connection

I'm trying to create a SQL script that has two statements: 1) Calling procedure that drops a table if it exists 2) Creating a new table



I'm getting " [Error 3932] [SQLState 25000] Only an ET or null statement is legal after a DDL Statement." which suggests that DSS is submitting the statements as Multi-Statement Request rather than as Single-Statement Request.  I am able to submit the query in SQL Assistant without error 



I tried including the DSS comment string to force splitting but I still get the error. 



I also tried setting TMODE = TERA advanced JDBC properties for the connection profile.



 




CALL ssd_pnr.conditional_drop('db_name', 'tbl_name', outmsg);

-- DKU_END_STATEMENT


CREATE
SET
TABLE db_name.tbl_name,
NO FALLBACK,
NO BEFORE JOURNAL,
NO
AFTER
JOURNAL AS (
SELECT
dw_key
FROM
db_name.src_tbl_name

) WITH DATA PRIMARY INDEX (dw_key);


 

0 Kudos
1 Solution
Clément_Stenac
Dataiker
Dataiker
Hi,

Please try checking "Autocommit" in the Teradata connection settings - ignore the warning saying that it's not recommended

View solution in original post

2 Replies
Clément_Stenac
Dataiker
Dataiker
Hi,

Please try checking "Autocommit" in the Teradata connection settings - ignore the warning saying that it's not recommended
cronos003
Level 2
Author
Thanks it works now.
0 Kudos

Labels

?
Labels (2)
A banner prompting to get Dataiku