hi i want to execute following satement in .net
TDStrSQL = "create volatile table tab1(somename varchar(100)) on
commit preserve rows;create volatile table tab2(somenames
varchar(100)) on commit preserve rows;" 'insert into tab1 values
('a'); insert into tab2 values ('b'); select * from tab1 union select
* from tab2;"
TDODBCcn.Open()
TDODBCcmdSelect = New Odbc.OdbcCommand(TDStrSQL, TDODBCcn)
TDODBCdtr = TDODBCcmdSelect.ExecuteReader
and database is teradata i the error is
ERROR [25000] [NCR][ODBC Teradata Driver][Teradata Database] Only an
ET or null statement is legal after a DDL Statement.