On Nov 24, 2010, at 9:07 PM, Suphajak Ngamlak wrote:
Dear all,
I would like R to retrieve a table resulting from execute sql stored
procedures. What function can I use? Can RODBC do it.
You might try looking at the package RSQLiite.extfuns
I tried
channel1 <- odbcConnect("ptsecmstqa01-alpha")
query <- paste("execute DB.dbo.usp_test")
Data<- sqlQuery(channel1, query)
However, it returned blank.
Best Regards,
Suphajak Ngamlak
Equity and Derivatives Trading
--
David Winsemius, MD
West Hartford, CT
______________________________________________
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.
