All Forums Connectivity
zyxhrb 3 posts Joined 03/16
11 May 2016
Submit multiple SQL lines to Teradata through R

Hello Everyone, 

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): 

library(RODBC)

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. 
 
Thanks in advance! 
 
 
 
 

 

You must sign in to leave a comment.