R help - Nov 2010 - Execute SQL Stored Procedure in R

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.

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
Phatra Securities Public Company Limited
Tel: (66)2-305-9179
Email: suphajak@phatrasecurities.com


	[[alternative HTML version deleted]]

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