Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I want to do INSERTs into Teradata Vantage database from an R script using the dataiku R api. Speciaficaly to support database interaction from a shiny app.
I've tried doing the following:
library(dataiku)
dataiku::dkuSQLQueryToData(connection="DATAIKU_DEV_03", query="insert into <database>.<table> values (1, 2, 3, 4)")
which doesn't give an error, but also nothing happens...
I've read in the documentation (here https://doc.dataiku.com/dss/api/8.0/R/dataiku/reference/dkuSQLQueryToData.html), that in some databases a COMMIT is needed after the transaction.
However, doing:
dataiku::dkuSQLQueryToData(connection="DATAIKU_DEV_03", query="insert into <database>.<table> values (1, 2, 3, 4)", postQueries=c("COMMIT"))
Gives the error:
[Teradata Database] [TeraJDBC 17.10.00.22] [Error 3706] [SQLState 42000] Syntax error: COMMIT WORK not allowed for a DBC/SQL session.
Does anyone know how to do this in Teradata database?