0 votes

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);
    

 

by
reopened by

1 Answer

+1 vote
Best answer
Hi,

Please try checking "Autocommit" in the Teradata connection settings - ignore the warning saying that it's not recommended
by
selected by
Thanks it works now.
1,299 questions
1,327 answers
1,507 comments
11,866 users

©Dataiku 2012-2018 - Privacy Policy