database - insert into Teradata using R JDBC -


i using r jdbc , teradatar connect r teradata. write table using function dbwritetable, receiving error

[error 3932] [sqlstate 25000] et or null statement legal after ddl statement.)

this works fine using rmysql on mysql database.

there similar thread here problem believed lack of 'begin transaction', turned out wasn't case http://forums.teradata.com/forum/extensibility/teradata-r-create-table-based-on-a-data-frame-using-jdbc

if use ddl statement alongwith dml statements during parallel execution (; semicolon on next line) or in ansi mode, , ddl statement not last statement in block, error.

select * employee ;create table dept select * tmp_dept no data ;update table employee set name = 'abc' id = 101; 

as observe, ddl result in implicit commits; while in transaction either entire transaction committed else rolled back. think intuition. please check if removing ddl code , using dml solves problem


Comments