[R] Using RODBC to use SQL queries

From: Megan J Bellamy <bellammj_at_gov.ns.ca>
Date: Wed, 23 Jul 2008 12:12:10 -0300


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

>channel<-odbcConnect("Oracle ODBC")

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

>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,

Megan



R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Wed 23 Jul 2008 - 13:14:35 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 23 Jul 2008 - 15:32:16 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive