java - How to execute multiple queries in teradata? -

for example query : create table ; select xxx ; delete ;

how execute in 1 session ?

i saw 1 answer similar question mysql. trick turn on allow multiple queries

string dburl = "jdbc:mysql:///test?allowmultiqueries=true"; 

---

for teradata specifically, solution ?

i tried

string dburl = "jdbc:odbc:dsn?allowmultiqueries=true"; 

it not working ?

you're looking multi statement request (msr). it's sending multiple sql statements server sepatarated semicolons.

but can't mix ddl , dml in single msr because ddl must commited , msr treated transaction (when running in teradata session).

try 2 seperate requests:

create table ;   select xxx ; delete ;