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
Post a Comment