I am having a problem of running queries through R. Here is the error message "Only an ET or null statement is legal after a DDL Statement". I've done my researches: I know one way to fix is to run the queries in separate calls. However, given I have so many existing queries, I AM WONDERING IF THERE IS A WAY I COULD DO IT IN THE SINGLE CALL (basically I just want to open my existing sql files and copy/paste):
channel <- odbcDriverConnect("dsn=Enterprise Data Warehouse;uid=123123;pwd=123123") sqlQuery(channel, " create volatile table fast_list as ( select cust_nbr from customer where natl_acct_nbr ='1234' ) with data primary index (cust_nbr) on commit preserve rows ;
insert into fast_list (cust_nbr) values (1235); ")
I have seen posts:
1. suggest add "ET;" and I tried to add between "on commit preserve rows;" and "intert...", it didn't work.
2. suggest add "session mode = Teradata". I tried to add this into odbcDriversConnect and it didn't work either.