Skip to content

Using RODBC to use SQL queries

3 messages · Albin Blaschka, Brian Ripley, Megan J Bellamy

Original
Albin Blaschka
# 
Megan J Bellamy schrieb:
 > After that I'd like to use the odbcQuery function and the SQL statement:
 >
 > SELECT * FROM table_name WHERE SAMPLE_YEA LIKE "1965%"
 > According to the RODBC PDF, the odbcQuery command should accept any 
valid SQL statement. Is there something wrong with my syntax? I have 
tried a few things, like attaching the tables to the data frame but with 
no luck. According to the PDF, I should be able to use this argument:
 >> odbcQuery(channel, query, rows_at_time,=attr(channel, "rows_at_time"))
 >
 > I have also tried to use arguments like:
 >
 >> sqlColumns(channel, "SAMPLE_YEA")
 > but with no luck. Any help with this would be much appreciated! 
Thanks in advance,

Hello,

which error message do you get, what does not work?

Just a blind guess:
Maybe the problem lies within the % - Sign? Try to double it -  ...LIKE 
"1965%%"

Here an working RODBC - Example:

library(RODBC)
channel <- odbcConnect("myODBC", uid="myUser", case="tolower")
sql <- "select x,y,z from mytable"
myresult<- (sqlQuery(channel, sql))

Best wishes,
Albin
Brian Ripley
# 
You should at least start with higher-level functions like sqlFetch(). Oh, 
and reading the posting guide (you show us no examples let alone error 
message) and the tests.R examples file which comes with RODBC.

SQL syntax is DBMS-specific, so we can't comment on abstract examples (and 
it is a long time since I used Oracle).
On Wed, 23 Jul 2008, Megan J Bellamy wrote:

            

      
      
      
    

        

      
      
    

        

  
    

      
      
    

  


  


      

    

    

      


  

        

      Megan J Bellamy
    

    

      
      #
    

  


  

      
Hello,

I am new to the RODBC package, but I have looked over the PDF as well as a few websites that go over the SQL language. I can connect to my database fine using

            

      
      
      
    

        
# then am prompted to enter my user id and password

After that I'd like to use the odbcQuery function and the SQL statement:

SELECT * FROM table_name WHERE SAMPLE_YEA LIKE "1965%"
According to the RODBC PDF, the odbcQuery command should accept any valid SQL statement. Is there something wrong with my syntax? I have tried a few things, like attaching the tables to the data frame but with no luck. According to the PDF, I should be able to use this argument:

            

      
      
      
    

        
I have also tried to use arguments like:

            

      
      
      
    

        
but with no luck. Any help with this would be much appreciated! Thanks in advance,

Megan