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@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, [EMAIL PROTECTED]
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@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.
