Re: [R] Using RODBC to use SQL queries

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
Date: Wed, 23 Jul 2008 14:45:48 +0100 (BST)

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:

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

-- 
Brian D. Ripley,                  ripley_at_stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

______________________________________________
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 - 15:02:40 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