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.

Reply via email to