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);
NO BEFORE JOURNAL,
JOURNAL AS (
) WITH DATA PRIMARY INDEX (dw_key);